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: [email protected]
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
