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.
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.
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.
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.