Hi Girvin,
The same as you I have used MySQL/MariaDB with OO/LO for at least a
decade. Before that
I looked after DB2 (Mainframe...) as an IBM-Systems Engineer. I also
cave been using the
JDBC-connector happily. One of the problems I encountered with the
"native" connector
was the absence of a capability to reconnect to my remote server after
an activity timeout
occurred (the server would allow me to increase the timeout specified).
In any case - I feel that a connection to an external database server
should continue to be
available. One reason - databases in enterprises tend to be used by more
than just ONE
application system...
Just my two cents worth...
Regards from Salzburg
H. Stoellinger
On 2018-05-26 21:15, Girvin Herr wrote:
On 05/26/2018 02:59 AM, Tom Davies wrote:
Hi :)
Snip
Base is supposed to MUCH better when using an external back-end -
it's what
Base was originally designed for and it's where Base beats Access.
Annoyingly that seems to be a little known fact that doesn't get
picked up
on by people marketing LO. Oddly hsqldb as an external back-end (ie
installing the most recent version into the OS and getting it from the
hsqldb project themselves, instead of using the old twisted version
hard-coded into LO) tends to be quite fantastic - but it is totally
dependent on Java and Java is a nightmare. So the move away from the
twisted old version of hsqldb to firebird is great news.
Snip
Hi Tom,
History lesson as I remember it: I suppose OO/AOO/LO wanted a built-in
database engine to better compete with Access, which had the Jet
engine built-in. Choosing hsqldb must have had its reasons back then.
Going back before OO, StarOffice had its own built-in database engine,
Adabase D, but I never could get it to work. (Granted, I was a
database newbie back then and my problems may not have been
StarOffice's fault.) I was glad to get OO (back then) working with
MySQL about 2005. BTW: I think there was a crude and circuitous way to
get Access 1.1 to talk to an external database server via a
"connector" system. But I never tried to do it before I converted my
databases to MySQL and never looked back.
My experience: I have always used LO with MySQL as my backend (aka
server) with the Java connector between them. Actually, I am now using
Mariadb, as this is what Slackware Linux distributes now. I have not
had any problems with my database system, after the initial
configuration learning curve. It works. Therefore, hsqldb and now the
proposed switch to the firebird backend are a non-issue for me, as
long as LO will continue to support the external server paradigm. But
that is me. Others may require the built-in engine paradigm.
For years, LO, has been reporting an imminent built-in (aka "native")
support for MySQL so that the Java connector is no longer needed.
However, that functionality seems to be another myth.
Girvin Herr
--
Gruesse aus Fuerstenbrunn
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy