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 <[email protected]> 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: [email protected].** > org <users%[email protected]> > 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: [email protected] 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
