Good Free sqlite tools ??

Discussion in 'iOS Programming' started by oceandrive, Jul 22, 2009.

  1. oceandrive macrumors newbie

    Joined:
    Nov 17, 2008
    #1
    Anyone has recommendation for a good tool for sqlite.

    Thanks for the tip.
     
  2. ChOas macrumors regular

    Joined:
    Nov 24, 2006
    Location:
    The Netherlands
    #2
    Firefox + SQLite Manager
     
  3. fishkorp macrumors 68020

    fishkorp

    Joined:
    Apr 10, 2006
    Location:
    Ellicott City, MD
    #3
    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.
     
  4. boyplunder macrumors regular

    boyplunder

    Joined:
    Sep 8, 2008
    Location:
    UK
    #4
    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?
     

Share This Page