On Tue, Mar 08, 2016 at 02:06:07AM +1100, Chris Sherlock wrote: > Is HSQLDB out of the question?
HSQLDB2 and H2 are good choices if we decide to stay with a Java-based one (which brings performance problems because of the slowness of crossing the C++-to-Java barrier). > > 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
