DbSchema Snappydata Client and Diagram Designer

Snappydata Interactive Diagrams

Manage Snappydata 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.

Schema Synchronization

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.

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 Snappydata 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 Snappydata applications for space, permission and activity management.