[libreoffice-users] Re: Tell me it's not true

Am 01.03.2012 23:02, Mark Stanton wrote:
> Hi Andrew,
>
> Was that instability with an "internal" HSQL database?
>
> Mark Stanton
> One small step for mankind...

The .odb file claims to be a document but in fact it is an extension. 
When you open the file and then open one of its objects, the embedded 
HSQLDB will be extracted to the temporary office directory so it works 
exactly like an external database in cached mode.
If your form/report/other office component crashes during this 
installation process, the whole backend database is lost. Similar 
problem when you close the "document" and something weird happens during 
the repackaging. Sometimes you can reconstruct the backend from the 
temporary files.
According to the forums, the total loss of an embedded HSQLDB happens 
quite often. This flaw is the total knock out for any program that 
claims to be a database.

I used to use one fairly complex embedded HSQLDB for a period of 18 
months. The development time was a full weekend for the backend and 
simple forms plus another weekend for the advanced forms. I worked with 
it one hour per work day beeing the one and only operator of that thing. 
 It grew up to a document size of 5 MB. I made a backup before every 
session but this particular file always worked reliably and never 
crashed. I did not need any macros at all since I know some SQL tricks 
and I am not miffed because of one click more than necessary.

So yes, I made my own positive experience with that "embedded HSQL". 
Nevertheless setting up a database server in order to work with "the 
real thing" is such a tiny effort and it can give so much more safety, 
security and performance that I do not recommend the embedded version.


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