Date: prev next · Thread: first prev next last
2011 Archives by date, by thread · List index


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.