On Sat, 23 Mar 2013 15:53:14 +0000, cl-RxdKpHOThMg wrote: > 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).
Try SQLWorkbench/J. Use the JDBC driver from: https://bitbucket.org/xerial/sqlite-jdbc _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users