Re: [libreoffice-users] Re: Where to store a simple database?

Whilst your answer is no doubt rigorous it lacks a little in the
helpfulness class!

You have explained many times before that base is not a database and
embedded hsql is evil. You haven't really explained why in either case, but
then I am much the same in declaiming Apple as the evil empire.

You focussed on "cloud" as if I had my head in it, I don't. Let me state it
again in less inflammatory ways - I want the database held in a single file
with no need for an engine - hence SQLite seemed ideal. So that is the way
I am pursuing but I am hitting snags (like ODBCConfig resolutely refusing
to install) so I was rather hoping somebody might come up with an
alternative or some help.

In the meantime, unless somebody can really convince me that embedded HSQL
is a disastrous approach I shall have to stick with that.

Incidentally stand alone HSQL seems to rely on java, and most of the
cognoscenti suggest avoiding java, so I shall!


On 14 September 2012 16:27, Andreas Säger <villeroy@t-online.de> wrote:

> Am 14.09.2012 16:41, John Clegg wrote:
>
> > where I wouldn't be able to get at it without Internet access? (Dropbox of
> > course keeps local copies which it synchronises). Or is this one use use
> > where embedded HSQL really is the right answer??
> >
> > All views appreciated!
> Of course you can not access cloud content without internet access. This
> office suite is a most conservative *desktop* application and Base is NOT a
> database program. Just like MS Access it lets you connect to various types
> of databases so you can access your data in this office suite. The whole
> thing does not know anything about a so called "cloud".
> No, the *embedded* HSQLDB is not an option. It is even much worse than the
> JET database embedded in MS Access.
> A stand-alone HSQLDB server may be a very good database solution if it
> fits your needs. You can run the same tiny Java program on all platforms as
> server, as client and in cached mode. But again, all this has nothing to do
> with any cloud computing. It just works with client-server connections or
> with plain single-user file access. If you are able to backup your files,
> the medium should not matter.
> If you need to access the same database from various places, it is about
> nothing but database servers.
>
>
> --
> For unsubscribe instructions e-mail to: users+help@global.libreoffice.**
> org <users%2Bhelp@global.libreoffice.org>
> Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-**
> unsubscribe/<http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/>
> Posting guidelines + more: http://wiki.**documentfoundation.org/**
> Netiquette <http://wiki.documentfoundation.org/Netiquette>
> List archive: 
> http://listarchives.**libreoffice.org/global/users/<http://listarchives.libreoffice.org/global/users/>
> All messages sent to this list will be publicly archived and cannot be
> deleted

-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted