[Libreoffice-bugs] [Bug 51781] New: Select a good replacement for embedded HSQLDB 1.8

[bugzilla-daemon at freedesktop.org]

https://bugs.freedesktop.org/show_bug.cgi?id=51781

             Bug #: 51781
           Summary: Select a good replacement for embedded HSQLDB 1.8
    Classification: Unclassified
           Product: LibreOffice
           Version: unspecified
          Platform: Other
        OS/Version: All
            Status: UNCONFIRMED
          Severity: enhancement
          Priority: medium
         Component: Database
        AssignedTo: libreoffice-bugs at lists.freedesktop.org
        ReportedBy: lionel at mamane.lu
                CC: afriza.na at gmail.com, bjoern.michaelsen at canonical.com,
                    dtardon at redhat.com, gleppert at gmx.de, lionel at mamane.lu,
                    mark at foresightlinux.org, michael.meeks at novell.com,
                    pwillener at gmail.com, serval2412 at yahoo.fr,
                    zreizinger at hdsnet.hu


We need to select a good replacement for our embedded HSQLDB 1.8, which is
holding us back in terms of features, not supported upstream anymore (we have
to maintain it ourselves, see e.g. bug 36824).

The current ideas:

 * update to HSQLDB 2.2:
   + little programming job on LibO side, it is already there, only version
bump
   + easy "ascending compatibility" migration (opening old files with new LibO)
   - problems with descending compatibility (opening new files with old LibO)
   - do we have to keep 1.8 *and* 2.2 in LibO to solve descending
compatibility?
   - keeps a hard Java dependency

 * Firebird
   - more programming job on LibO side: write SDBC(X) driver, hooks for
embedded mode
   - will have to keep HSQLDB 1.8 in LibO anyway for ascending/descending
compatibility
   + gets rid (for new files) of one Java dependency

Add the "enhancement" bug for any other runner-up as depending on this bug.

Non-solutions:

 * sqlite: too far from SQL standards, no decent date/time support; see
   https://bugs.freedesktop.org/show_bug.cgi?id=38811#c19
   and following comments.

 * MySQL/MariaDB/... : can be embedded, but GPL

 * CSQL: GPL

 * MonetDB: introduced embedded mode in 2004, but dropped it as of 2011
   (source says it was not a true embedded mode anyway, only a single client
server)

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.