Informix Interactive Diagrams
As always, your mileage will vary depending on your scenario and preferences. Read on to find out which is the best MongoDB GUI for you, updated for 2016. MongoDB Compass. Mac OS X, Windows. Pricing: Free for development purposes; contact MongoDB for Commercial/Advanced Licenses. Look for DbSchema tool, is great for the diagrams they. The best best free DB schema design tool are: A blank paper and a pencil. Draw and design your DB schema on the paper using the pencil. Have a peripheral computer image scanner.
Manage Informix schema via interactive diagrams. Create new tables, columns and indexes directly in the diagram. The diagrams can be exported as HTML vector images.
- Schema can be edited directly in the layouts (diagrams).
- The layouts are saved to project file and reopen next time you access the application
- HTML5 documentation with interactive vector image can be exported. Sample here.
- Foreign keys can be drawn using different notations, with lines pointing to tables or to columns.
Relational Data Browse
Relational Data Browse is a visual data explorer from multiple tables simultaneously. View one table data and then open further tables having foreign keys or virtual foreign keys and view related records.
Data can be edited, filters can be set.
The editor will be saved to file and reopen next time you access the application. In this way you can build different perspectives over the data and reuse them whenever you need.Video IntroductionRead more »
Dbschema For Mac Is The Best Db Client For Mac
DbSchema use its own project with schema structure and diagrams, which will be saved to project file. This makes possible to design schema independent from the database and deploy it on multiple databases.
The project file is in XML format. The project file can be stored in GIT and shared in a team.
Restarting DbSchema will open the last saved project file. To ensure the project schema is the same as in the database press 'Refresh schema from database' from the menu. Next you can refresh complete schema or take an action for each difference : merge in DbSchema or in the database.Video IntroductionRead more »
Visual Query Builder, Query Editor and Random Data Generator
- Visually create SQL queries using the query builder. Multiple JOIN clauses can be used, including LEFT OUTER JOIN, EXISTS, etc. or group by clauses. The joins are using the foreign keys or virtual foreign keys.
- The Query editor with text-autocompletion, script execution and graphical explain plan.
- Random data generator using reverse regular expressions and predefined patterns.
Database Forms and Reports Database Manager
DbSchema Informix forms and reports can be used to build applications or reports and run them as JavaFx or Web applications. Based on the forms designer we started building Informix applications for space, permission and activity management.Read more »