Hacker News new | ask | show | jobs
by yangyang 3651 days ago
We used this in production at my previous role and it was fantastic. There are a few rough edges but it became markedly more reliable over the 2 years or so we used it. It handled huge (well over 100KB) queries generated by SQLAlchemy with ease and was lightening fast.

We were using it as part of a custom BI tool for portfolio risk analysis. The data was mastered in postgresql and loaded into MonetDB for OLAP stuff.

The developers are pretty responsive to questions and bug reports.
2 comments
greggyb 3651 days ago
Do you know if it's possible to expose an MDX or similar interface to MonetDB for a BI purpose?

I see many references to being able to define your own language, so I wonder if this has been done. I don't see anything explicit when looking through the site.

I ask because many popular visualization and reporting tools can natively generate MDX queries.

link
jazzido 3651 days ago
It can be done through Mondrian OLAP. See mondrian-rest [0] for an example implementation.

[0] https://github.com/jazzido/mondrian-rest-demo

link
greggyb 3651 days ago
Cool! Thanks.

I had heard of Mondrian, but didn't think to check from that end if it could use MonetDB as a back end.

link
gijzelaerr 3651 days ago
SQLAlchemy dialect maintainer here. I'm happy to hear somebody is using it, I've been working on it for a while but in the last 2 years I only received one bug report. And I don't think that is because the code is flawless.
link