Hi Damjan, Am 08.12.20 um 03:06 schrieb Damjan Jovanovic: > 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.
H2 has several compatibility modes icl. HSQLDB: https://www.h2database.com/html/features.html#feature_list Regards, Matthias > > 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 >
smime.p7s
Description: S/MIME Cryptographic Signature
