[libreoffice-users] Re: [Announce] HyperSQL 2.2.8 Released

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+help@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