I found the visual query builder to be useful for quickly putting together simple queries, however it is obvious that it was not intended to be used for select statements where common table expressions or subqueries could be needed.Ī common operation I often need to perform is comparing two versions of the same schema and updating one or both of them to a common version. The visual query builder will also allow you to use a WHERE and an ORDER BY clause, as well as aggregate functions like MAX, COUNT etc. Joins are automatically made by taking advantage of the defined foreign keys, but additional join conditions can also be specified. Visual Query BuilderĭbSchema has a built in support for a visual query builder that allows you to select the tables and columns that you would like to use in a select statement. In addition, while zooming in and out can be done by using the mouse scroll while holding the CTRL button, I was unable to find intuitively a keyboard-only shortcut for the same operation. What I did not like with the ER diagram was that, unlike the vertical scroll, the horizontal scroll did now work on a laptop touchpad. This is especially handy when working with larger databases since it allows developers to think in terms of modules and submodules, and in that way tackle complex models more easily. A small window in the sidebar shows the query history and allows you to stop the execution of queries that are still running.Īn important feature of the ER diagram is that it allows you to group tables into layouts, with the option of having one table in multiple different layouts. In addition to the main diagram, a sidebar on the left contains a minimap of the entire model, presenting a general view of all entities and enabling an easier navigation when working with larger models.īesides to generating an ER model, DbSchema allows you to run queries against the database you are connected to. Dragging entities works with no stutter and foreign key constraints can be created by pulling lines between entities which is a good feature to have. Double clicking an entity brings out a modal form used for editing the columns, indexes, foreign keys and other constraints. The generated entities were spread out nicely to minimize the number of relationship lines that cross each other. I found the process to be fluent and intuitive and considering the database I used (~50 tables), the diagram was generated quickly in a matter of seconds. Reverse engineering a schemaĭbSchema offers the functionality of creating an ER diagram from an existing database. Finally, when you are finished with the overview wizard, you will be shown the start page containing shortcuts for common tasks, like connecting to a database, creating an ER diagram, opening the documentation, etc.
#Dbschema lines software#
On the first launch, you will be shown a modal dialog describing the major features which can be useful if you would like to get a quick introduction to the capabilities of the software package, and decide whether it can be useful to you.
#Dbschema lines download#
Installation is straightforward, and the steps are described on the download page. The package can be acquired from the download page which contains installers for three major platforms.
#Dbschema lines trial#
Getting startedĭbSchema is available as a free trial version for 15 days, which should be enough to try it out and see if it fits your needs.
#Dbschema lines full#
In addition to all this, the full package is available for all three major platforms, Windows, Linux and MacOS, which makes it a good potential candidate for a complete database management tool. Besides the traditional support for relational databases, including Oracle, SqlServer, MySQL, PostgreSQL and many other, DbSchema has been recently extended to also support MongoDB, a popular open-source document database. It is the flagship product of Wise Coders Solution, a European company specialized in writing software for databases. DbSchema is a database designer, equipped with powerful features like an ER diagram modeler, visual query builder, schema synchronization and several other.
0 kommentar(er)
