On Mon, Dec 7, 2020 at 8:38 PM Peter Kovacs <pe...@apache.org> wrote:
> Hi all, > > I would like to know how you guys feel we should move on with our base > Database. Our current strategy is a small sized embedded DB using HSQLDB > (BSD). There are 2 other options in the same weight class, that is H2 > (EPL1 or MPL2) and Apache Derby (AL2). > > Something like SQLLite (PublicDomain) could be technical interesting, > but I think their licensing is not so appealing. > > We could also consider firebird (MPL) like LO, but I have the impression > that this is not a lightweight DB, but featurerich. And I wonder if this > is really something we should provide. I would rather develop a way to > make it easy to switch the DB when a Project grows. > > What are your thoughts? > > Whatever we do, we have to provide backward compatibility for HSQLDB. I am more interested in something like Apache Calcite, which would let us do SQL queries spanning multiple database backends, than in yet another database backend. SQLite is interesting because it's very widely used, runs on iPhone and Android, is a single file, performs well, and is lightweight. The hard part is getting the database to write into .ODB files instead of what it natively uses? Damjan
