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: [email protected]
ReportedBy: [email protected]
CC: [email protected], [email protected],
[email protected], [email protected], [email protected],
[email protected], [email protected],
[email protected], [email protected],
[email protected]
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.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
