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+h...@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.
todhopk...@hillmanncarr.com
--
Unsubscribe instructions: E-mail to users+h...@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
