The last few weeks I’ve been working with MonetDb on a SCADA project. Just like the last version (that I used a few years back) – with the SQL interface, it is still stable, simple and extremely fast at certain types of querys (it really can be an order of magnitude faster than Ora, DB2, MySQL and other traditional RDBMS for retrieving singe records or aggregate values from huge but simple datasets).
Then there is the XML interface with the same blinding speed and a completely different optimum application…
So why does it remain relatively unknown?
Is it the altruistic hardcore open source commitment (didn’t stop Apache)? Lack of a pretty package and slick admin tool (doesn’t seem to be a roadblock for SQLite)? Or perhaps a lack of acceptance of column-oriented databases (but Infobright and Vertica are far less mature, far more complex and are shit-hot right now)?
Go figure … (or comment on what I’m missing)
