We are running LucidDB in a production environment and are very happy with
Like with any product, it takes a bit of time to get hold of the reins and
use it effectively.
The speed increases we get and the relaxed feeling we have not being tied in
to a reoccurring license fee is unmatched.
Also we have accurate answers and have not lost data.
Lucid's built in mechanisms for pulling data into itself and allowing
joining on tables within itself that exist through connections to other
databases is really cool.
For our setup, we use another great software called Pentaho Data Integration
for most of our ETL that streams into Lucid.
Both companies are great to work with supportwise and so are the communities
that follow them. You'll be amazed at the concentration of smart people
around these products.