Re: [libreoffice-users] LO Base/MySQL questions

On 02/07/2014 10:29 AM, Lens Paul wrote:
> Hello,
>
> This instability of HSQL is worrying when using the same database year 
> after year, e.g. an address or a bibliographic database.
>
> For my part, all my data remain in separate external tables in dbf 
> format, linked to Base.
>
> Reasons are:
> - compatibility with many programmes and readability of old archives, 
> even in case of change of database program ;
> - stability in the long run;
> - format compatible with GIS software;
> - when the tables are not merged in one file, the loss is limited when 
> one of the tables gets corrupted.
>
> The main drawback is the impossibility to make a relational database.
>
>
> In fact, the good integration of the office suite with a database was 
> one of the main reason's why I began to use OO in 2007 or 2008.
>
> To my great satisfaction indeed: it works very well, except for two 
> instances, several years ago, where the dbf file got corrupted 
> (luckily, recovery from backups was easy).
> Since then it works fine without any failure (except, rarely, for some 
> data in memo fields, which can lose the right connection with other 
> data (dbt file connection to dbf file)).
>
> Nevertheless, the impossibility of making relations between tables is 
> rather frustrating.
> One solution is to migrate to a mySQL/Base or preferably Postgresql 
> (because of PostGIS). It's my intention but I fear to waste a lot of 
> time in migrating.
>
> What is the best combination for a single user, relational database, 
> stable in the long run, using Base as the front end?
>
>
> Paul Lens
Paul

PostgreSQL and MySQL/MariaDB are good alternatives. MariaDB is a fork of 
MySQL and many Linux distros install it instead of MySQL. Both can be 
used as a single user database. IMHO MariaDB is easier to use in a 
single user environment. With both you can use Base or database specific 
GUI (pgAdmin, MySQL Workbench).

If the data can be exported to csv files migrating should not be 
difficult, only time consuming.

Jay
> Le 7/02/2014 15:07, Ian Whitfield a écrit :
> > Sorry All
> >
> > I'm running PClinuxOS (latest) and LO 4.1.2.3 and MySQL 5.1.55
> >
> > A MySQL 'expert' was telling me recently that HSQL is only meant to 
> > be a prototyping utility and should *NEVER* be used for any "proper" 
> > work - - interesting!!??
> >
> > I can confirm that when it crashes it takes everything with it so you 
> > have to backup every time you make change. This is what forced me to 
> > MySQL.
> >
> > Thanks again

--
Jay Lozier
jslozier@gmail.com


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