![]() ![]() Currently available for MySql and PostgreSql. We started building permission, space and activity database managers for all databases using the forms designer. Fast development through wizards and the intuitive interface. Load Excel, text, XML or comma separated files into the database.Ĭreate small applications or multiple master-details reports and execute them under JavaFx or Web. All query conditions are represented graphically. Graphic query editor with different join types, filters and group by. Moving the mouse over columns and tables in the web browser may read the schema comments. Graphical explain query execution plan included.Įxport the diagram as interactive HTML5 vector image. SQL editor with syntax highlighting and code completion can execute queries, SQL or groovy scripts. If your schema misses foreign keys, create virtual foreign keys: they will be saved to DbSchema project file and can be used in Relational Data Browse, Query Builder or for documentation purposes. The project design file is in XML format and can be stored in GIT or SVN. You may work on a development schema and later deploy it on the production databases. Schema will be saved together with the diagrams to project file.ĭbSchema holds its own image of the schema which can be compared and synchronized against any database. Data can be edited directly here, filters and sorting can be applied.Ĭonnect to any relational database or one of the supported noSql databases, reverse engineer the schema and view it as ER diagrams. The editor is persisted and will be reopen next time when you start the application. ![]() Start exploring data from one table and cascade into further tables based on foreign keys. Visual alternative to SQL language, the editor offers simultaneous views of the data from multiple tables. ![]() For a better understanding of the schema create multiple layouts (diagrams), one for each module of the schema, with the same or different tables.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |