Got a tip for us?
Let us know
Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.
iOS Good Free sqlite tools ??
- Thread starter oceandrive
- Start date
- Sort by reaction score
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.
ChOas said:
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?
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?