Reading further on, I see that you're looking at end-user. This changes things a bit. Now you're looking at trying to make things user-proof, maintain data integrity (Who said 1<>one?), validate data, so on and so on. You're probably looking at custom code now.
But, if you can trust the user(s), I'd STILL say don't reinvent, but just use a something that is already written. On Sun, Mar 24, 2013 at 8:17 PM, Stephen Chrzanowski <[email protected]>wrote: > SQLite Expert (http://www.sqliteexpert.com/) is free for basic use. > Reading over your original post, 'smells' like you're using Linux. This > should run in WINE, but I've not tried. > > Load up the database, select the table, click the DATA tab, and poof, you > have your data which you can edit in-line either by double-clicking on the > row, or, selecting the cell and hitting F2 or slow-double-click-cell. > There is also column based filtering in the data tab as well, but it isn't > overly complex. Basically "Filter for these characters". But there is a > SQL tab you can use to create SQL statements, and depending on the type of > query, you can edit in-line again. The rest of the stuff SQLite Expert > would be gravy. > > I know you said you didn't want a DBMS, but really, when you're saying > you're willing to write an application to manage the data, you're writing a > DBMS. Save time, don't reinvent the wheel unless you're going on a > learning adventure. > > > > On Sat, Mar 23, 2013 at 11:53 AM, <[email protected]> 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. >> >> > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
