Hi,
Le 6/06/19 à 00:00, Drew Jensen a écrit :
I think that if the project really wants to be aggressive on ditching
HSQL, as with 6.4, then right now and thru to the 6.4 release there
should be a TDF emphasize on getting people to make the migration from
HSQL odb files. Either to Firebird embedded or an external data base.
The concept of "embedded" database is - at most - a nice-to-have feature.
A Base application embedding in the same single file both the logic and
the data is 1. unmaintainable (a. You cannot prepare a new version. b.
You cannot use 3rd party database design or database management or
database ... migration tools), 2. "undistributable" to other users and
3. definitively limited to serving a single user.
In fact, it is a nice toy but it is also nonsense to build real
(data)Base applications, the data being embedded.
Many LO Base users have made the choice already for years to extract
their embedded HSQLDB databases and run their apps on a newer version (>
2.X). Search on "https://forum.openoffice.org"; words like extract
embedded hsqldb, freehsqldb, split databases. You will find there tons
of tools and advices. It is as easy as (roughly) unzipping the odb file,
storing the database files in one directory, replacing the hsqldb.jar
driver with a newer version and adjusting the connection string.
IMO the focus should be to teach users how to migrate to external
databases. The Firebird embedded model should not be the preference. It
will in no way improve the user experience.
Thanks.
Jean-Pierre Ledure
PS: MSAccess has a one-click menu item "Split database" (i.e. between
front-end = logic and back-end = data) since its version 97 (yes, 1997 !).
_______________________________________________
LibreOffice mailing list
LibreOffice@xxxxxxxxxxxxxxxxxxxxx
https://lists.freedesktop.org/mailman/listinfo/libreoffice
