On Sat, Feb 06, 2016 at 09:12:56AM +0000, Chris Walker wrote:
On Fri, 5 Feb 2016 17:05:29 +0000 Chris Green cl@isbd.net wrote:
Open Office base just doesn't quite manage it. It either needs an ODBC driver or uses its own wierd database. I really want to work with existing sqlite databases.
Have you looked at the SQLite browser that's offered in some distros? I've been using it for some years on a couple of databases of my own and one which came as part of an Android app.
Yes, I have it installed on my systems. It's the best of a bad bunch. The grid editing isn't too bad, in fact it's pretty much exactly what I'm after. The only issues with it are:-
It takes four clicks to get to a specific table after opening, I'm having discussions on GitHub for sqlitebrowser about this, there are some other users who'd also like some command line options to take one to browsing a specific table.
There's no form design ability, not to be expected in a program like this of course, but it means one can only edit a table's values and not have anything update automatically.
I want to be able to design something that allows me to simply run a command (menu or coomand line) which will open up a window with my database table ready to edit.
You do need to run SQL commands but you do that in a window in the app.
Yes.
I'm really after a better Glom, or Kexi, or LibreOffice base. The trouble with all of these is that they have effectively made their databases proprietary which rather spoils their 'open source'ness.
Glom uses postgresql only which, in itself, isn't a disaster though I'd prefer sqllte. However the real killer is (from the Glom web site) :- "Glom uses the PostgreSQL database backend but it can not edit databases that it did not create, because it uses only a simple subset of Postgres functionality. "
Kexi has a similar limitation - "Currently you can not "open" (i.e. connect to) databases created outside of Kexi. You can only import the tables and data. "
LibreOffice by default uses its own internal database engine. It can connect to external ones but it really isn't particularly easy to do it and, as far as I can see, the sqlite connector isn't stable.