Good Free sqlite tools ??

Firefox + SQLite Manager

 

Wirelessly posted (Mozilla/5.0 (iPhone; U; CPU iPhone OS 3_0 like Mac OS X; en-us) AppleWebKit/528.18 (KHTML, like Gecko) Version/4.0 Mobile/7A341 Safari/528.16)

100% agree.

 

The answer to the question is a little more involved.

I have a couple of Apps that use a sqlite database, and I use both FireFox + SQlite manager, and also SQL Database Browser. If you want to open up and import a table of data that's fine. But there are a few things neither of them do.

For instance, one app has about 1000 entries with an ID, name and description. Adding a new entry that should, alphabetically, fall between 100 and 101 is a pain, because neither software allows you to reserialise the ID column. The table view in the app has to sort the data, but working in the datafile can get confusing pretty quickly when the rows are all over the place. This is compounded, in my case anyway, with the fact that the description field has returns in it, which I can't import from anything because the returns and a lot of special characters are lost.

So the real question is: Are there any good Free SQL tools that are worth bothering with, or should I buy one that actually helps me?