New version 2.2 just released.
New version allows you to create database from your Google Docs Spreadsheets account.
All you have to do is fill Spredsheets in your Google account and click button in SqlTool.
Spreadsheet becomes new database and each Worksheet in it
becomes new Tables. Table columns can have 3 types (TEXT,INTEGER,REAL)
See tutorial how to use this feature here:
Play/Work/Learn SQL language, prepare for IT interview by running Sql commands right on your iPhone/iPod.
Export Schema and/or Data in Sql, HTML, CSV format
Allows to transfer content your Address Book to pre-created AddressBook.db database so you can play with this info using SQL. These are AddressBook.db tables:
(Address, Email, Groups, Person, Phone, URL)
Uses Sqlite database engine.
Lookup SQL info in provided HTML reference
In version 2.1
Improved Help Section
SQL command history is now separate for each database
Improved SwitchDB Section, added Delete DB
In version 2 added Multithreaded Web Server
This mean somebody can be uploading large database file to your device, other running query and you working with device directly
Using Web you can now do following:
Upload Database files, which can be large (>100Mb), to iPhone/iPod
Download Database files from iPhone/iPod
Get Information about Database file (size, tables, count, ddl)
Delete Database file
Run SQL for Database in browser
Wizard to build SQL commands