SQLite DB editor

[bgowland]

I've got SQLiteSpy which suggests it should be capable of editing (there is a Read Only option so I presume the default is to allow edits???). Whatever I do, I can't seem to change anything. If I select a field, the data is shown in a little pane at the bottom of the app and I can edit that but can't find a way of saving that change.

Anyone know if this is possible or can anybody suggest a SQLite DB editor?

Cheers,
Brian

[cginzel]

I reccomend SQLite Administrator. http://sqliteadmin.orbmu2k.de/

[bgowland]

Thanks - I'll give it a try. I found Visual SQLite but the trial only lasts 30 days and it's US$40 to buy. I'm not going to be doing that much editing to warrant a purchased product.

Cheers,
Brian

[ubu]

I came across SQLite Database Browser which, in addition to cosmetic stuff like having a tabbed interface with a toolbar and wizards for common tasks, offers some handy features:

• A floating Find window in data view, enabling you to search table columns for a string (similar to equivalent feature in MS Access - essential if you are snorkling through lots of rows).
  
• Import/Export to CSV files (allowing data to be manipulated in Excel or whatever).
  
• A SQL Logging capablity to keep track of what you did.

It's free too!