I am using LO 3.5.6 on Windows 7 and also recently on Ubuntu 12.04
I have been eagerly migrating all my usage from Microsoft Office to LO, and
I would appreciate some advice on converting from Access.
I have one project which consists of a fairly modest flat file (896 records
of 33 fields), but I have a number of well established queries that I use
with it and once a year I link the data to an imported direct debit
accounts table and export a CSV file which I convert to XML (using a python
script) for sending to the direct debit company. So SQL access to the data
is vital. The data is stored in Dropbox so it can be accessed from Windows
or Ubuntu easily - but never simultaneously. I do have access to a MySQL
server as part of my web hosting but I would rather not bother with setting
one up locally for just this application.
My original approach was to just use embedded HSQL, but I have got the
message that this is a BAD IDEA, although it does work well with storing
the data in Dropbox.
I tried storing the data as an ods file (in Dropbox) and attaching my Base
file to that, but the SQL functionality is too restricted.
So, where should I store the data? Can I use SQLite to store the data in
Dropbox? Or should I bite the bullet and store it in the SQL server
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!
For unsubscribe instructions e-mail to: email@example.com
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
- [libreoffice-users] Where to store a simple database? · John Clegg
Impressum (Legal Info)
: 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