Skip to content

Instantly share code, notes, and snippets.

Stefan Urbanek Stiivi

Block or report user

Report or block Stiivi

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
View polymerase.sepro
DEF TAG polymerase
DEF SLOT complement
# Template site
DEF SLOT t_site
# Complementary site
DEF SLOT c_site
DEF TAG nucleotide
DEF TAG promoter
DEF TAG free
DEF TAG taken
@Stiivi
Stiivi / cubes2.0-goals.md
Last active Aug 5, 2017
Cubes 2.0 Goals
View cubes2.0-goals.md

Cubes 2.0

Hi there. After almost two years of none or very sparse activity due to life and career situation, I’m committing myself back to the Cubes project. It will take some time to ramp-up, but we will eventually get there. I apologize for not meeting expectations lately and for letting the framework, mailing list and discussions go stale.

I got quite a lot of useful feedback and recommendations from users and people in the domain and that revived my motivation to spend more of my spare time to make Cubes better and modern OLAP toolkit.

Now, let’s move forward. To do any improvements or changes, Cubes needs quite a lot of housekeeping. The whole 2.0 release addresses that. Only when we have consistent, well-defined interface, when we have goals and equally importantly non-goals set, we can start growing Cubes again.

Links:

@Stiivi
Stiivi / sqlalchemy.py
Last active Mar 25, 2017
Cubes SQLAlchemy imports
View sqlalchemy.py
"""Aliases for SQL/SQLAlchemy objects that are assured to be correctly
type-checked."""
import sqlalchemy
# Engine
# ======
Engine = sqlalchemy.engine.base.Engine
Connection = sqlalchemy.engine.base.Connection
View interfaces.pyi
from typing import Any, Iterator, List, Mapping, Optional
# Note: The value type `Any` should be a DB API 2 value type once defined
# TODO: See #1037
class RowProxy(Mapping[str, Any]): ...
class ResultProxy(Iterator[RowProxy]):
def keys(self) -> List[str]: ...
def close(self) -> None: ...
@Stiivi
Stiivi / cubes-non-intuitive-data-types.py
Last active Mar 19, 2017
Cubes non-intuitive data types
View cubes-non-intuitive-data-types.py
# The following data types were discovered in Cubes while type-annotating the source code.
# Sometimes it might seemed a good idea to permit people pass whatever they want, however opens
# way too many possibilities for unchecked errors.
#
# Type that can be passed as drilldown to the browser's `aggregate()` function:
#
_DrilldownType = Union[
Drilldown,
Dict[str, Union[Dimension, str]],
@Stiivi
Stiivi / thing.py
Last active Feb 20, 2017
Entigen example
View thing.py
from typing import Any, List, cast, Optional
class Thing:
# Name
name: str
"""Name of a thing"""
# Type
type: str
"""Type of a thing"""
View gist:1c9e0ae03a7e2e8a0c37cc6cc8961b49
### Keybase proof
I hereby claim:
* I am stiivi on github.
* I am stiivi (https://keybase.io/stiivi) on keybase.
* I have a public key ASBLM9Aydkaxn4ImB5736izffGiLrFrR5p16_2j4XSsbvQo
To claim this, I am signing this object:
View snowflake.vim
if version < 600
syntax clear
elseif exists("b:current_syntax")
finish
endif
syn case ignore
syn keyword cubesStatement dimension fact hierarchy repr nextgroup=cubesModelObject skipwhite
"" Experimental
View snowflake.snowflake
# -----------------------
DIMENSION city REFERENCES country
DIMENSION country REFERENCES region, market
DIMENSION region
DIMENSION market
DIMENSION agent REFERENCES market
DIMENSION company
REFERENCES
agent,
View tree.sepro
# Self-organizing trees
#
CONCEPT node
TAG free
SLOT left, right
CONCEPT head
TAG open, node
SLOT left, right
You can’t perform that action at this time.