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

Hi :)
Apparently another great database program to use as a back-end is
Postgresql.  Some of the Postgresql people worked with the LibreOffice
people to make a really good connector and then got that connector into
LibreOffice main trunk.

So, Postgresql has an advantage over MySql in not needing a connector,
apparently.  I dunno how it gets updated though!

Also MariaDb is a drop-in replacement for MySql and i think a few places
use it but continue to claim they are using MySql.  Apparently all the
MySql connectors work just the same but i've only heard from a very small
number of people about that and the person who makes/builds the MySql
connector wasn't certain they would work.

I think those are all the larger database back-ends but HSqlDb is
supposedly faster and more efficient with small databases such as almost
all address books.  There are tons to choose from though so you might find
that whatever is being used somewhere already can probably be viewed and
edited through Base.  I think the way Base makes it so easy to connect to
external back-ends is one of the huge advantages that Base offers.  Instead
we try to cripple it by giving it an internal back-end to make it as broken
as Access.
Regards from
Tom :)


On 2 March 2015 at 19:04, Andreas Säger <villeroy@t-online.de> wrote:

> 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

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