Is HSQLDB out of the question? Chris
Sent from my iPhone > On 7 Mar 2016, at 11:32 PM, Noel Grandin <noelgran...@gmail.com> wrote: > > > >> On 2016/03/07 2:11 PM, Lionel Elie Mamane wrote: >> On Mon, Mar 07, 2016 at 08:23:53AM +0200, Noel Grandin wrote: >> A few examples of how SQLite differs from the SQL standard (be it de facto >> or de jure standard) in quite deep, fundamental ways: >> >> * lack of other datatypes than "integer", "real" (float), "string of >> characaters" >> and "string of bytes": the basic ones are dates, times, timestamps. >> >> * lack of datatype checking; one can insert "noel" in a column of >> type "integer" >> >> * type attached to value, not to column > > > That is true, but we could implement basic checking of our own on top of > that, or just ignore it, and rely on the user getting it right most of the > time (which they normally do). And when they don't, it is a rather soft > failure mode in SQLite. > > >> >> Also annoying, but can be worked around: > > Yeah, that's what I mean - there are other issues, but they can be worked > around. > > I suppose we can just keep limping along with our current state of affairs, > it's not like Base is that widely used, or particularly vital to our future. > > But it would be nice to upgrade to something a little more modern, and > Firebird is not really working out for us, and what other options do we > really have? > > At least SQLite is widely used and moving forward at a reasonable rate. > > Regards, Noel. > > _______________________________________________ > LibreOffice mailing list > LibreOffice@lists.freedesktop.org > https://lists.freedesktop.org/mailman/listinfo/libreoffice _______________________________________________ LibreOffice mailing list LibreOffice@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice
