Database Modeling Assistant: Well Forgotten Old

Inspired by a recent post.

As a matter of fact, the theme of desktop DB designers is hardly touched upon, although probably not a single sane person will design his project directly in a DBMS.

I want to write a mini-review about a completely new, but true assistant - SQL Power Architect 'e. Open-source cross-platform application written in java, with support for various databases.

')
I use Architecture not the first year and I love it for simplicity. Platform - Ubuntu (version 10.04-12.04) with Gnome2
Before starting, do not forget to throw in ~ / architect-1.0.6 / jdbc / the JDBC driver you need for your database.

So, about the pros :

• First: the minimalism and intuitiveness of the interface + the easy handling / customizability of hot keys
• Secondly: a pleasant opportunity to connect the existing base and drag the necessary structures into a new project
• And also all sorts of buns, such as
  - correct SQL generator
  - the ability to compare different models (for compliance) - convenient for non-one-man work
  - export to csv, xml, sql, pdf, html
  - OLAP support (not using)

Of the minuses should be noted:

• Insufficient data type support. Alas, neither you serial'a nor enum, nor the more custom types
• Absence of concept of entity schema. Therefore, different schemes have to do different models

Several screenshots to attract attention :)

01 Creating a connection to an existing database

02 Creating a table and column

03 Index Creation

04 Relationship Type (fkey)

05 Details of the foreign key (ratios)

06 Upload to SQL and XML

Salute to all! Suddenly someone come in handy.

* Waiting for questions / suggestions from excessive confusion *