Re: [libreoffice-users] Re: Where is Base?

Andreas ,

i must strongly confirm your vision.
We must see Base  as a connector and a front end for any possible 
database server

We have 100 users, using LO as a front end  to a MySQL server without 
any problems to use the MySQL data in Writer and Calc.
The front end itself is writen with LO basic mainly using Dialogs to 
view the data and to feed the server with new and modified data.
Greetz

Fernand
> Am 02.03.2015 um 19:33 schrieb Florian Reisinger:
> > Just a short note: Base can connect to a MySql database using a connector.
> > I even think, knowing not much about Base, that an external database for storage is a very good way to 
> > go...Am 02.03.2015 16:54 schrieb Peter Goggin <petergoggin@bigpond.com>:
> External is the one and only way to go. The embedded HSQL 1.8 simply
> does not work well enough. There are far too many reports of total data
> losses which is inacceptable for a database product.
> You can connect MySQL via ODBC, JDBC and the SDBC driver built into the
> office suite.
> I prefer external HSQL 2.3 via JDBC because the office frontend is
> tailored around HSQL, because HSQL 2 converts formerly embedded HSQL 1.8
> on the fly and because any connection to an external HSQLDB requires
> only one file hsqldb.jar anywhere on the system. In server mode it takes
> this file plus self made start/stop scripts and a backup script.
> I just opened my oldest HSQL 2 database running in server mode on a
> Windows machine, accessed during 12 hours a day by means of Writer forms
> and Calc reports from 7 client machines. The first record is of
> 2011-Apr-28. This database never caused lost a single byte of data. Of
> course we run nightly backups anyway.


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