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
Context
Privacy Policy |
Impressum (Legal Info) |
Copyright information: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License.
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (
MPLv2).
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our
trademark policy.