I got a question: Can anyone tell me the disadvantages of HSQLDB compared to e.g. MySQL. I know it is a stand alone, very small database, which just consists of some files. But can it also handle huge databases?
I asked this because it comes with the open source business intelligence tool pentaho. Is it possible for a small company to have to have its data warehouse based on HSQLDB or might there be problems to handle big databases?
It is designed for use as a data store for standalone applications, and not as the database behind a multi-user distributed client system. In addition, it is reported to has some issues with transaction isolation. Per wikipedia, "HSQLDB version 1.8.1 supports transaction isolation level 0 (read uncommitted) only. It means a SQL query in one session might occasionally fetch uncommitted data from another session."
IMO, if you don't care about the data, put it wherever you like. If you DO care about it, if data has some value, make it secure - put it in a database server, and build your application atop a solid database foundation.
"Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
"I have my standards. They may be low, but I have them!" - Bette Middler
"It's a book about a Spanish guy named Manual. You should read it." - Dilbert