TE
TechEcho
Home24h TopNewestBestAskShowJobs
GitHubTwitter
Home

TechEcho

A tech news platform built with Next.js, providing global tech news and discussions.

GitHubTwitter

Home

HomeNewestBestAskShowJobs

Resources

HackerNews APIOriginal HackerNewsNext.js

© 2025 TechEcho. All rights reserved.

Cubes - Python Lightweight OLAP - 0.9 released

29 pointsby stefanuabout 13 years ago

4 comments

stefanuabout 13 years ago
Author here. Just a small explanation: target audience are mostly those who would like to add OLAP to their apps with simple multi-dimensional reporting needs (see trivial hello-world example [1]). This release brings new star/snowflake aggregation browser which can be (roughly) considered to your analytical data as ORM framework is to your transactional data - some magic happens between your code and the database that makes your life easier.<p>Visualisation is not yet included and will be added in modular form of "presenters" [2]. If anyone with web/JS skills would like to help, he is welcome, as my skills in this area is little bit weak. There is unmaintained and unfinished prototype of JavaScript front-end as well [3]. Flask based example of simple dimension browsing is included in the source [4].<p>If you need any help with model creation, you encounter any issues, have a suggestion let me know.<p>[1] <a href="https://github.com/Stiivi/cubes/blob/master/examples/hello_world/aggregate.py" rel="nofollow">https://github.com/Stiivi/cubes/blob/master/examples/hello_w...</a><p>[2] <a href="https://github.com/Stiivi/cubes/issues/53" rel="nofollow">https://github.com/Stiivi/cubes/issues/53</a><p>[3] <a href="https://github.com/stiivi/cubes.js" rel="nofollow">https://github.com/stiivi/cubes.js</a><p>[4] <a href="https://github.com/Stiivi/cubes/tree/master/examples/sandbox/flask_dimension_browser" rel="nofollow">https://github.com/Stiivi/cubes/tree/master/examples/sandbox...</a>
sgtabout 13 years ago
Interesting idea. Ofcourse, OLAP isn't just about the underlying cubes and dimensions, in the end it's about how the information is being presented to the user. There's a reason why Microsoft is so good at data warehousing, because their product is one of the best, and also extremely feature-rich from the "front end" to the back end.
评论 #3973298 未加载
评论 #3973221 未加载
slantyyzabout 13 years ago
I haven't encountered a lot of BI nerds who are Pythonistas, but this is a great contribution nonetheless.<p>The more open source tools we can get that can begin displacing products like Cognos and BO, the better.
评论 #3973779 未加载
dbeckerabout 13 years ago
Is this going to integrate with the broader python ecosystem? I'm specifically wondering about packages like pyTables, pandas and larry.
评论 #3993346 未加载