DbSchema isn't for everyone, but if you work with or want to learn to work with relational databases or MongoDb, today's deal is especially for you!
DbSchema is an efficient and productive universal database tool that facilitates an intuitive perception of the schema using graphical layouts, relational data browsing, a query builder, a SQL editor, schema synchronization and migration tools, and much, much more. DbScema includes all the major features you would expect from a sophisticated database tool, and then some!
The database schema is represented in DbSchema using graphical layouts. This representation is the best way of understanding the relationality between tables, and is also the key factor in designing a high-quality database schema. Multiple layouts can be created for a single schema, each offering a unique perspective. And you can easily add comments for each table, column or layout. For MongoDb the database structure will be discovered and presented as diagrams as well.
Relational Data Browse -- one of the primary tools in DbSchema -- is an amazingly simple and efficient relational data explorer that offers simultaneous views of data from multiple tables. Relational Data Browse features numerous filters, data sorting mechanisms, and much more. Using it you can explore the database data in a fast and intuitive way, without writing a single query!
The Query Builder can build complex queries, with 'Group By' clauses or differing 'Join' types. The Query Builder is integrated in the DbSchema layouts, so editing queries can be done starting from the graphical representation of the schema. Even better -- during query editing the SQL text is displayed in a preview. The query builder is working for MongoDb as well.
The SQL Editor features text auto-completion, query and scripts execution, graphical explain plan and offers the option of saving large results to file.
Schema synchronization feature for relational databases and the DbSchema project file allow the design of the schema to be followed by the deploy of the schema over multiple databases. This is useful in development teams where the production database schema needs to be upgraded to the development one. In addition, DbSchema can convert schemas between different databases.
Database Forms and Reports - the newest of this kind in the market - can generate interactive and responsive HTML forms or reports, with custom scripting logic and multiple master-details sections. This feature is working for MongoDb too.
DbSchema can also create high quality print-outs. HTML5 images can be generated out of the layout graphical representation of the schema. The HTML5 images are about 100 times smaller then the same GIF image, a perfect choice for documenting the database schema. Each table or column in the layout can be commented and the comments will be included in the documentation.
Prices are subject to vendor's pricing and may change
The Fine Print