By Steve Saemmang
Open iTunes to buy and download apps.
DB Designer for iPad is a visual editor for creating databases for MS SQL Server, MySQL, PostgreSQL or SQLite. By offering a simply handling it makes it possible to create data structures fast and efficient. In addition to maintaining multiple projects it's also possible to export data models to work with them in other tools.
The key features are:
- Managing multiple projects
- Support for MS SQL, MySQL, PostgreSQL and SQLite syntax
- Autocomplete data types
- Create, edit, and remove tables and fields
- Support fot optional schemas
- Color codes for your tables
- Support for primary, foreign and unique keys
- Support for indexes (MS SQL: non-clustered and clustered)
- Easily create relations between tables
- Creating mandatory or default fields
- Export as SQL script or PDF
- Export by email or open with other apps (i.e. DropBox)
With this tool you create easy an fast small and also complex data models and save yourself a lot of time.
DB Designer for iPad has been used worldwide by many developers. Some user voices:
"The only app of its kind in the app store." - Canada
"I've been waiting for something like this to come to the iPad." - Canada
"This app has a very fast to learn interface that allows rapid development" - U.S.
"Really Amazing. I am really impressed." - U. S.
"I like you effort in making this great tool." - United Kingdom
What's New in Version 1.3
- finally ready for ios 7
Not Bad, But...
Pros: it's simple to use, nicely portable on iPad, and supports color-coding of entities. Relation key propagation works well (exception noted below). Export to PDF for printing and sharing static models with others. A good, but bare-bones ER diagramming and DDL generation tool.
Cons: lack of support for relation cardinality, the lowest-common-denominator datatype support (for example, not being able to use all standard current SQL Server types from the pop-up list), no comments/descriptions on entities & attributes, no foreign or alternate key flags, inability to export/import native models to others for collaborative work, limited layout control over relations. None of these are show-stoppers but I would pay significantly more for an iPad tool that handled these details.
I was very skeptical at first about this program but after I fiddled around with it, I really like it. This program allows me to travel with my iPad and still be productive. There are a few quirks with the program but overall it's great. I exported the tables to a script and it ran perfectly.
Best and only
Steve has done a wonderful job with this app. Simple enough to be usable by even novices but feature rich enough to make it a contender against desktop design software. Strong props.