[libreoffice-users] Re: export sql to odb?

Am 15.08.2011 10:33, Dave Sergeant wrote:
> Perhaps drifting off thread a little. I have a DBF database which dates
> back many years - in fact to Lotus Works in MS DOS days. It works well
> via LO Base, once one has worked out how to do it, which is far from
> obvious. I have often wondered whether it is worth converting this to a
> native LO database, ie on the lines of your mentioned HyperSQL. I guess
> it is not, and in fact I would guess that most users only use Base as
> an interface to other database formats.

Do yourself a favour, and abstain from the "native" embedded HSQLDB.
It has a bad reputation to destroy all user data. They should never have 
implemented a native database in this way.
In fact it behaves like an extension. Every time you "open the database 
document" the HSQLDB is extracted to the temporary directory and then it 
is connected just like an external database for one allmighty user.
Every time you "close the database document" the whole thing gets 
repackaged. With growing size the packaging time becomes longer and 
longer. Sometimes an input form may crash, sometimes any other office 
component may hickup. If this happens during the packaging process, your 
entire database will be lost.
Embedded HSQLDB is insecure, unsafe, slow and not connectable with 
anything but this office suite. It is a caricature of a database, still 
good enough for some drafts and unproductive demos in a single file.
I have very good experience with HSQLDB and with H2 as a stand-alone 
databases, others use the MySQL or PostgreSQL they are familiar with.


--
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