Re: alternatives to Firebird: HSQLDB2, H2, ...

On Tue, Mar 08, 2016 at 09:59:18AM +1100, Chris Sherlock wrote:
> I understand, but the situation with Firebird seems less than ideal,
> at least in terms of Windows builds at any rate.

> Are the tests really that much slower? Obviously we are relying on
> having a Java installation to test out Base.

The performance issues were not limited to tests, but also to actual
usage by humans. There were quite some complaints about performance,
user-noticeable and user-annoying, when on GNU/Linux, starting with
Java version XXX, things got slower. (There were also other
performance issues.)

Various hacks to work around that were discussed, but never really
implemented.

> > On 8 Mar 2016, at 2:11 AM, Lionel Elie Mamane <lionel@mamane.lu> wrote:
> >
> > 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 <noelgrandin@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