I'm looking for a simple to use **data entry** tool to use with (mostly) sqlite3 databases.
There are several quite good database management programs available (e.g. sqlitebrowser) and anyway the sqlite3 command line program is quite adequate for most of my dataase management needs. What I can't find anywhere is a good way to enter data into tables. A GUI tool is probably better but I'm prepared to try anything. Programs like sqlitebrowser have ways to enter data but they aren't that easy to use and they are buried down in the menu system. I want a program where I can just say 'sqledit <database> <tablename>' and be presented with a data grid where I can edit the data. The program visidata is the nearest thing to what I want that I have found so far. However it's quite complex to learn, partly because it's a command line program and partly because it works with lots of different data formats. If I can't find anything else I may persevere with visidata. Another possible approach is to use a spreadsheet (e.g. libreoffice calc) as they provide **exactly** what I want for data entry and editing. The trouble is that it isn't entirely straightforward getting data from a sqlite3 database into and out of the spreadsheet. Can anyone suggest anything that might provide what I want? It doesn't absolutely **have** to work with sqlite3, I'm prepared to move to mariadb or postgresql if necessary (though I'd prefer not to). I don't mind either a desktop program or a web application. -- Chris Green ·
