DbSchema Database Designer

DbSchema | SQLDays 2022 Germany

SQLDays 2022

DbSchema & Wise Coders GmbH will be present at SQLDays 2022 as presenter with the following session:

Databases for Teams: Design, Documentation & Deployment

Database design is the key factor for the success of an IT project. Its structure is reflecting in the complete software architecture.
As writing code we talk about ‘clean code’, in database design we talk about ‘clean design’.
Different techniques like HTML5 documentation, virtual foreign keys, visual relational data explorer, logical design and others can help to improve the schema clean design,
and the awareness about the database structure inside the company.

In the development cycle, the database schema is handled by architects, developers, testers and then gets into production.
The schema has to be deployed on different databases, migration scripts has to be generated.
We will learn together how we can implement this inside our organization.

About Dragos Pruteanu

Dragos Pruteanu is the founder of Wise Coders GmbH, the company who wrote the DbSchema Database Designer.
Dragos is licensed master computer engineer, Java and Oracle Certified Professional, and worked by eCircle and Mapp Munchen.

Visually Manage Databases using DbSchema

DbSchema is a databases client and visual designer. DbSchema has a free Community Edition, which can be downloaded here.
DbSchema main features include:

DbSchema Designer alt >

Interactive Diagrams

Design tables, column and foreign keys directly in diagrams.

Connection Dialog alt >

Simple Connection Dialog

Choose the database location, the user and password, and simply get connected.

Relational Data Explorer alt >

Relational Data Explorer

Explore data from multiple tables simultaneously, using foreign keys or virtual foreign keys.

Query Builder alt >

Query Builder

Create SQL Queries using the mouse.

SQL Query Editor alt >

SQL Query Editor

Edit and execute SQL Queries

Schema Synchronization alt >

Design Schema in Team & Schema Deployment

DbSchema is using the design model, a copy of the schema structure, independent of the database.
The design model can be saved to file and shared in a team.
Connecting to another database you may compare the design model with the database, commit the differences or merge them in the design model.

Dark Theme alt >

Dark Theme

Configurable styles & dark theme.

Many features are available in the free Community edition.
The Pro edition adds capabilities to save the design to the model file, design schema in team and deploy the schema on multiple databases.

DbSchema can be downloaded for free. No registration is required.