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


Hi :)
I think it's worth avoiding using the internal back-end.

Until very recently the internal one was an ancient and heavily
tweaked version of Hsqldb.  I think the devs have been working at
replacing it with a more straight-forward Firebird and hopefully that
will be updated in some sort of reasonably automatic way with an
opt-out clause.

The old internal Hsqldb one was a bit warped and the new Firebird one
is a bit new.

If you get a reasonably recent version of Hsqldb to use as an external
database then apparently it's extremely good and exceedingly fast, for
small databases (such as address-books) but when using the internal
tweaked version people have had some fairly serious problems.  It's
entirely written in Java apparently but even so it's allegedly quite
good.

Regards from
Tom :)







On 11 March 2014 22:41, jomali <jomali3945@gmail.com> wrote:
Thanks, Alex, for the clarification. Since I have never used the internal
hsqldb database, I was unaware that it kept its data in the .odb file. The
last internal database I used was Adabas D in Staroffice. I quickly went to
JDBC or ODBC connectors to other external datbase engines (e.g., MySQL).
John


On Tue, Mar 11, 2014 at 12:57 PM, Alex Thurgood <alex.thurgood@gmail.com>wrote:

On 11/03/2014 13:23, jomali wrote:

Hi John,

I think your confusion lies in equating an .odb file with an Access
database. The .odb file never contains the data. It is a sort of registry
that points to wherever the data is. Thus, Base is the front end, a real
database is the back end, and the .odb file serves as the intermediary
(to
oversimplify).

I agree with everything you have written, except that, by default, if
you use the wizard to create a "standard" (and I use that term very
loosely) ODB file, LO creates an ODB file which embeds its own
hsqldb-compatible data into the file and then uses the LO-shipped
hsqldb.jar to be the db engine. This is where it gets confusing for
people wanting to split out their data from their forms, queries,
reports, etc.

Alex



--
To unsubscribe e-mail to: users+unsubscribe@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



--
To unsubscribe e-mail to: users+unsubscribe@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


-- 
To unsubscribe e-mail to: users+unsubscribe@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.