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

Greetings Tom,

I can attest that Base works well with MySQL/Mariadb (M/M). I understand that Base still requires the Java Connector (mysql-connector-java) to talk M/M to the server (aka "Back End"). At least that is how I still have Base configured. There was talk of a "native" Base driver for MySQL, but to my knowledge, that has not been deployed to date.


On 04/06/2017 10:27 AM, Tom Davies wrote:
Hi :)
Ok, so is it just SQLite that is an odd exception or was the general 'rule'
i gave completely wrong?

I'm under the impression that Base works well with Postgresql,
MySQL/MariaDb, Hsqldb (as an external back-end), Firebird and many/most(??)
others? Also that the kinda default way iof using Base is to use some
external back-end - despite an internal one being hastily thrown on years
ago in order to downgrade Base to be more like Access?

Regards from
Tom :)

On 6 April 2017 at 17:48, toki <> wrote:

On 04/06/2017 07:05 AM, Alexander Thurgood wrote:

the main problem with SQLite in relation to its use in LO is its lack of
strong data typing

Data typing and SQLite are mutually exclusive concepts.

in SQLite, which doesn't bode well when trying to determine whether the
string is a date, a timestamp, a large number, or some other kind of
As far as SQLite is concerned, there is no difference between an
integer, and an mp4 video file.

For those who don't pay attention to what they are doing, such things
can have unexpected, and occasionally undesirable results.

There is that fringe minority, that sees such data ambiguity as a virtue.


To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


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.