DbSchema Blog

Categories

• Cassandra
• Databases
• Dbschema features
• Design
• Firebird
• Migrations
• Mongodb
• Mysql
• Oracle
• Postgresql
• Release notes
• Snowflake
• Sql server
• Sqlite
• Tool comparisons
• Tools
• Tutorials

Rolling Back a Database Schema Change

When a database schema change goes wrong, decide quickly if it can be reversed. Learn how PostgreSQL, SQL Server, and MySQL handle DDL rollbacks.

Migrations • 04-Sep-2026

MySQL CREATE DATABASE Guide for Beginners | DbSchema

Learn how to create a MySQL database from the command line, verify it, and manage it visually in DbSchema.

Mysql • 04-Sep-2026

DataGrip Alternatives: Tools for Visual Schema Design

Looking for a DataGrip alternative? Compare top visual database schema design tools, including DbSchema, Oracle Data Modeler, and Aqua Data Studio.

Tools • 04-Sep-2026

The latest order per customer in PostgreSQL with DISTINCT ON | DbSchema

One row per group in PostgreSQL with DISTINCT ON: the ORDER BY it requires, the tie that picks a random row, and when ROW_NUMBER or LEFT JOIN LATERAL is the better tool.

Postgresql • 02-Sep-2026

Catching a table without a primary key before the schema ships | DbSchema

Write the rules your schema must follow, run them against the DbSchema model, and get a list of every table, column, index, or foreign key that breaks one, before anything reaches the database.

Dbschema features • 02-Sep-2026

DbSchema Tool Presentation and Feature Overview

Get a quick tour of DbSchema features, including schema modeling, synchronization, documentation, and visual query tools.

Design • 18-Aug-2026

DbSchema Nominated for Best Data Modeling Solution

DbSchema has been nominated for Best Data Modeling Solution in the 2026 DBTA Readers' Choice Awards! Show your support by voting and help us bring this award home.

Design • 17-Mar-2026

DbSchema at Magdeburg DevDays | Germany 2025

DbSchema joins Magdeburg DevDays 2025 with team sessions on MongoDB design, Git collaboration, and writing clean, maintainable tests.

Design • 01-Mar-2026

DbSchema 9.9.4 Release Notes – New Features and Updates

Explore the DbSchema release notes, featuring the latest updates, new features, and improvements for database design and management.

Release notes • 11-Jan-2026

DbSchema at SQLDays Germany 2022

DbSchema presented at SQLDays Germany 2022 with a session on team database design, documentation, and deployment workflows.

Design • 13-Sep-2022