Am 12.04.2012 01:17, avamk wrote:
Hello,
As a new user, the new HSQL looks very interesting, but I am still a little
confused:
Does this mean if I setup HSQL 2.2.8 per your instructions in the original
post, I will have a database service/server running on my machine that
LibreOffice acts as frontend for? I.e. will my databse become more similar
to a MySQL or PostgreSQL server/client model, and not an embedded file
anymore? Also, is there a way to migrate existing databases created with
"vanilla" LibreOffice Base to this new HSQL?
Thanks!
Hi,
This is how the database connectivity was designed in OpenOffice.org 1
before there was any component called Base and it still works in this
manner. A "Base document" (*.odb) is just a package container for a set
of frontend tools and an _optional_ HyperSQL backend. Base "installs"
(extracts) the backend databaes every time you open such an .odb file
and it repackages the modified database when you close the file. Keeping
the database out of the Base container is far more safe and efficient.
The embedded HSQLDB deserves its merits for educational purposes. It
makes it easy to exchange relational database demos on the internet.
The database can be anything connectable via ODBC or JDBC.
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
