The current open-source release (0.9.3) of LucidDB is available for download. It is packed with advanced features; there are also some limitations you should be aware of:
- support for correlated subqueries is still under development (uncorrelated subqueries are now fully optimized via constant reduction)
- security features remain incomplete
- writers never block readers, but writers block other writers on the same table
- all transactions are autocommit
- any join condition is supported for LEFT/RIGHT OUTER JOIN, but FULL OUTER JOIN support is limited to equijoins
- one single database-wide auto-extend tablespace
- FOREIGN KEY and CHECK constraints are not supported
- a limited number of system views and management procedures are available
- collation is always case-sensitive
- no support for timezones and time intervals
- the only client API provided out-of-the-box is JDBC; however, integrations for other client/language environments are available
- external user-defined routines are written in Java





Roadmap