I'm looking for a straightforward way to edit the *data* in sqlite
tables, or at least a simple GUI for creating forms to edit sqlite
tables.
I don't need *any* database management and I don't want it in this
application either because I want to be able simply to issue a command
like:-
app <database> <table>
which will pop up a window with the editor ready to go, preferably in a
grid format so I can see the existing data.
The tables to be edited only have a few columns so the app can show all
the columns with no problem.
What I'm after is simplicity when using the editor, no complex series of
menus to navigate to reach the point where one is editing data, no reams
of icons etc. in the GUI, just a line of boxes to enter the data.
I'm quite happy to design it myself given a few tools, even a non-GUI
approach would be acceptable if it's reasonably simple.
What I have tried so far (with some comments) are:-
kexi - it's almost there but you can't create a data entry form
with a datagrid on it and you can't get it to edit sqlite3 tables
created outside of kexi.
sqledit/sqlkit - it looks almost ideal but it seems to me that it's
just a bit too buggy. I've tried both plain sqledit (ready made
app) and creating my own using sqlkit.
wxglade - a python GUI toolkit, this has been closest to success so
far and I may eventually get to a good solution but it feels as if
I'm having to reinvent the wheel in programming lots of things that
someone must have done before.
Surely there must be something close to what I want out there! (By the
way while I'm basically after a desktop application a web one would be
acceptable as I run a full LAMP setup on my desktop machinee).
--
Chris Green
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
