On Friday, November 01, 2013 4:27 PM Paul Tansom wrote
Interesting, I've not made massive use of LibreOffice Base yet, so I am
surprised that it cannot import from .csv or run update queries. I'm going
to
have to explore now, if only I could install it on my machine.
Unfortunately it
seems that LibreOffice Base is at a different version in my repositories
than
the rest of LibreOffice so I can't install it!
I have been using Open Office Base, which I think is much the same. On my
Linux laptop the other components of Libre Office were installed but not
Base.
I think I've been put off desktop databases by MS Access where I've had
several
battles to get it to do what I want it to. Generally I've wanted to
interact
with the SQL it generates, only to find that either it isn't really SQL or
it
is actually doing more behind the scenes than the SQL it presents actually
tells it to - very nasty! It is going back a bit so it may have improved.
I found MS Access fine for single user, but it could not cope properly with
multi user - locking inadequate I think.
Oddly, when it comes to desktop databases I've found that the MS Works one
has
been the one I've got on best with (OK, now everybody gets ready to hurl
abuse
at me!). I think the main reason for this is that the database is little
more
than a single table for storing data that I can merge into a document.
Since
this is a long time ago and that is exactly what I wanted to do it was
easy.
There doesn't seem to be much around that works well for exceptionally
basic
stuff like that these days. I've been battling LibreOffice Base a bit on
Windows to do something simple like that just recently and not got on well.
It
is no wonder so many simplistic databases are done in spreadsheets!
I need to do Joins and grouping of records etc. Spreadsheets not good for
that.
I cannot understand the Firebird documentation. SQlite seems fine. It seems
that sequences of SQL statements can be executed from Linux shell scripts.
This will avoid having to write C or C++ programs.
--
Next meeting: Bournemouth, Tuesday, 2013-11-05 20:00
Meets, Mailing list, IRC, LinkedIn, ... http://dorset.lug.org.uk/
New thread on mailing list: mailto:[email protected]
How to Report Bugs Effectively: http://goo.gl/4Xue
