iPad Screenshots

Description

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

Version 1.3.1

- ready for 64 bit
- required changes for future major release

Ratings and Reviews

Impressive development tool

Touchofnature

Having used DB Designer for Windows and Rational Rose for many years, including the current Db Designer version offered by Oracle, I felt right at home with DB Designer for the iPad. Once you get accustomed to the user interface and the features provided for assigning relationships, creating schemas is very intuitive. The use of user interface widgets and animation is excellent and the author has managed to eliminate the annoying use of animation in all respects.

I'm giving five stars because it seems reasonable to assume where the author is heading with this product. I do wish there was a way of increasing the size of the canvas, although it may provide this feature and I was unable to discover it. It would also be nice to be able to move columns (fields) within a table (e.g. Moving secondary keys to the top of column list or for generally moving columns to new locations. Again, this feature may exist and I was unable to find out how being new to the user interface.

For MySQL in particular, it would be nice to be able to set field size for the TinyInt data type.

Excellent example of creating an application for a developer audience who need to work quickly with a minimum amount of gestures and keystrokes.

Not Bad, But...

dwk-987

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.

Works great and does what I needed

Bowmiester2

I wanted to design some database models while mobile, and this works great. Once you get the interface down, you find a groove and it's pretty easy to use. Being able to export SQL scripts to generate the database is awesome.
I was surprised that there aren't many options for this kind of thing in the App Store, but would recommend this one others.

Information

Seller
Steve Saemmang
Size
1.1 MB
Category
Productivity
Compatibility
Requires iOS 8.0 or later. Compatible with iPad.
Languages
English, German
Age Rating
Rated 4+
Copyright
© simplic | software and innovation
Price
$1.99

Supports

  • Family Sharing

    With Family Sharing set up, up to six family members can use this app.

You May Also Like