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


That's a huge help, thanks.  I suppose this raises the question, why does Base default to file 
mode?  Simplicity?

merci,
              tod

On May 3, 2011, at 11:03 AM, Alexander Thurgood wrote:

Le 03/05/11 16:17, Tod Hopkins a écrit :

Hi Tod,

Thanks for the advice.  By "mixed-mode" you mean the use of HSQLDB front end with MySQL (or 
other) backend?

Sorry, I should have made myself clearer. By mixed-mode of HSQLDB, I
meant that the hsqldb.jar (which is provided with LibO and OOo as the
built-in database engine) can be used in client (aka file) and server
mode depending on the parameters given to it on start-up, providing
certain tweaks are carried out beforehand. In file mode, only one user
can access the db at any given time. However, in server mode, you can
have concurrent multiple user access.


An explanation of how to set this up is provided in a tutorial available
on the openoffice.org forum :

http://www.oooforum.org/forum/viewtopic.phtml?p=396523#396523

If you really want to stick with hsqldb as the database engine, then you
should go and read through this material.



I've been trying to read what documentation there is.  Not much.  I find that as soon as I get 
beyond what I already understand, there is a presumption that I that I have a working knowledge 
of SQL, which I don't.  

So, since my goal is multi-user database, for which I now see that I need MySQL anyway, I figure 
I should turn to learning MySQL. 


Well, mysql as a backend is but one alternative, and as I mention above,
not the only one that you can use if you want multiple user, concurrent
access to the db. Your base file (ODB file) then becomes a front-end
"container" for the backend server. I suppose the main advantage of
using mysql as a back end with LibO is that the native mysql connector
provided as an installable extension enables fairly comprehensive
management of the different data types supported by mysql and actually
pretty good performance without having to tweak cache memory settings
and whatnot. It still has its "gotchas" though, in fact all of the
available connectors (ODBC/JDBC) for mysql do. Unfortunately, these are
not widely documented, and often can only be found by trawling through
bug reports on multiple sites.


Alex


-- 
Unsubscribe instructions: E-mail to users+help@libreoffice.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/www/users/
All messages sent to this list will be publicly archived and cannot be deleted



Tod Hopkins
Hillmann & Carr Inc.
todhopkins@hillmanncarr.com




-- 
Unsubscribe instructions: E-mail to users+help@libreoffice.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/www/users/
All messages sent to this list will be publicly archived and cannot be deleted

Context


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.