Hi :) Is anyone here in the MariaDb or MySql communities? Is there any chance of attracting some of their devs to work on an Open Source connector or better yet to work with our devs to create native support?
I tried asking the MariaDb people around the time they forked off from the Oracle overlords but I'm really bad with people and they were quite busy. Someone in the Postgresql community did a fantastic job of getting their devs and our devs working together a few years ago and so LibreOffice apparently connects to LO really neatly. Regads from a Tom :) On Sat, 26 May 2018 20:58 H. Stoellinger, <hc.stoellin...@aon.at> wrote: > 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 > -- 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
