I want a simple, straightforward way to enter data into a sqlite3 database, by this I mean:-
I want to be presented with the existing table contents with rows across the page (it will fit across the screen, the database will have only five or six columns).
It would be nice if I can customise the sort order.
I want to be able to add data at the bottom where there will be an empty row by simply typing the data in and tabbing to the next field, no pop-up boxes or other hoops to jump through.
None of the applications that I can find provide anything remotely as easy as this, both sqlitebrowser and sqliteman are very painful to use for entering data.
The application can run on the local PC or as a web application. I already have a plugin for my Wiki that does most of what I want with the database but it can only do data entry with a single row of the database shown (i.e. what Access calls 'columnar'), what I want is what Access calles 'tabular'.
If there's nothing suitable for sqlite3 I could use mySql instead.