SqlTool app for iPhone and iPad


4.8 ( 18 ratings )
Utilities Education
Developer: andrei goumilevski
2.99 USD
Current version: 2.2, last update: 7 years ago
First release : 26 Mar 2009
App size: 468.77 Kb

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:
http://sites.google.com/site/goog2sqltooldatabase/

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


Future
Wizard to build SQL commands