I was used to execute simple queries in my AIR applications, ie with only one INSERT, UPDATE or DELETE statement. But, recently, I had to execute queries including several statements (database creation or mass-insertion of data). I thought that would be easy but actually it requires a “workaround”.
UPDATED (8th of Apr 2009) : SQLite Administrator is a great tool but now you can try the SQLite Sorcerer, which became my favorite tool as I developed it by myself.
When I started working on AIR and its SQLite database API, I immediately searched a tool to manage my databases : create, modify, view data, create queries, test… After a bunch of tries, I’ve found what I think the best free one : SQLite Administrator.







