Learn SQL in your browser
A free SQL tutorial in short lessons on one shop database. Every example runs on real PostgreSQL in your browser, and the page checks your answers.
DbSchema Blog
Database design, migrations, SQL and everyday database work — explained with practical examples.
Why Version a Schema at All
Learn why database schema versioning is essential for engineering managers to eliminate deployment bottlenecks and automate migration scripts safely.
Comparing Production and Staging Schemas
Learn how to compare production and staging database schemas, identify hidden schema drift, and use DbSchema to generate precise visual migration scripts.
Comparing Two Database Schemas
How to compare two database schemas and generate safe DDL migration scripts, with DbSchema Pro, Microsoft SSDT and Redgate SQL Compare for SQL Server.
Putting a Database Schema in Git
Put your database schema in Git: state-based vs migration workflows, Git best practices, and automated migration scripts from a plain-XML model.
Liquibase, Flyway or a Visual Schema Compare
Compare Liquibase and Flyway for database DevOps, and discover how a visual schema compare uses Git-versioned XML files to generate migration scripts.
Reviewing a Schema Change in a Pull Request
Learn how to review a database schema change in a pull request. Uncover the exact SQL statements and engine lock levels that a plain text diff hides.
Turning a Schema Diff Into a Safe Migration Script
How database administrators turn a schema diff into a migration script: version the XML design model in Git, generate the DDL, review it before it runs.
Finding Schema Drift Between Database Environments
Learn what database schema drift is, why it breaks data engineering pipelines, and how to detect and synchronize schema changes across environments.
Schema Versioning Without a Migration Framework
Version your database schema without a migration framework. Save the design as an XML file in Git and generate SQL migration scripts automatically.
Open-Source Schema Migration Tools
Discover how open-source schema migration tools help backend developers manage database changes safely. Compare DbSchema, Liquibase, and Flyway.