UPDATE: This version is now obsolete. A new version is available here.
I put together this SQL Admin application to help me manipulate my SQLite databases when working with AIR.
The application is based on the SQL Admin for Google Gears I posted recently.
This is an early version and is not fully functional. For example, because in this beta of AIR we don’t expose system tables, I cannot display a list of all tables in the database (In SQLite, this is normally done using SELECT * FROM SQLITE_MASTER). However, you can use the application to create a new database or open an existing one, and execute any type of SQL statement: You can create, alter and drop tables, select, insert, update, delete data, etc…
To create a new database:
- Click New Database
- Navigate to a directory of your choice
- Specify a file name for the database. For example test.db
To open an existing database:
- Click Open Database
- Navigate to the database directory, select the database file, and click Open
To add a table, click New Query and type a create statement (or drag “CREATE” from the list of syntax hints in the lower left corner of the screen), and drop it in the Query window.
To insert, update, or delete data, type the corresponding statements in a query window, or drag-and-drop syntax hints from the lower left corner of the screen.
Click here to install the application.
Click here to download the source code.