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


Le 04/08/2014 18:59, dave boland a écrit :

I'm getting a little confused.  My understanding is that there are
really two issues here.  One is that LO Base is RAM resident - all
updates are held in RAM until saved by the user, or the program is
closed.  Correct?  If so, this situation will expose the user to data
loss between saves.  

There are two components here: the DB engine (eg HSQLDB) and the
front-end (ie LO-Base).
In embedded mode, running Base stats the DB engine and opens the wanted
database. In this situation, yes, database updates are set to ram until
the database is saved, either voluntarily or when Base is shut down.

And yes, any flaw in *any* piece of software running while Base and the
DB also run, can create DB loss.


The other issue is that LO Base uses an embedded database, which means
that the data files and the GUI, reports, etc. are combined into one
file that can be corrupted.  The suggestion is to use a split system
where the data files are separate from the other files.  Correct?  If
so, at best, the data may be a little safer, but forms, queries, etc.
can still be corrupted.

Yes, this is what "split-mode" is all about.


A database like MySQL and mariadb cache the updates and then write them
to disk every 1/2 to full second (or however configured).  Seems like a
good idea.

So I come back to my suggestion earlier today - LO Base needs to give
the user the opportunity to specify what they want - RAM or file based,
single file or multiple files.  Would that be difficult to do?

WRT HSQL it's just a couple settings away:

(1) in LO global settings (Tools/Options, Advanced page) specify where
the external HSQLDB engine is stored (Class Path button)
   -> Add archive: points to the hsqldb.jar
   -> Add Folder: points to the directory where hsqldb.jar is stored
(lib dir)

   Then make sure to check the test button

   These setings are stored in the user profile /config directory.

(2) in Base, DB creation wizard
   -> at step 1 : select JDBC database
   -> at step 2 : specify the DB address settings
      Datasource URL :
hsqldb:file:d:/somedir/mybase/basetest;default_schema=true;shutdown=true;hsqldb.default_table_type=cached;get_column_name=false
      JDBC Driver class: org.hsqldb.jdbcDriver

   Test with the Test Class button.

   These settings are stored in the RegistryModifications.xcu file.


To me, the main difficulty lies in the backup of these settings (config
dir and RegistryModifications.xcu and the .odb file), so that you may
change PC without hassle. Unless I'm missing the obvious, it is not the
case currently.

-- 
Jean-Francois Nifenecker, Bordeaux

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