DbSchema Blog

Categories

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

Generating MongoDB Validation Rules From a Design

Learn how to model collections, explore virtual relations, and generate MongoDB validation rules from a visual design to enforce data structure.

Mongodb • 31-Aug-2026

Documenting a PostgreSQL Database

Learn how to document a PostgreSQL database using the COMMENT ON command, catalog queries, psql output, and visual ER diagrams to keep your schema clear.

Postgresql • 31-Aug-2026

A Visual Query Builder for PostgreSQL

How DbSchema builds PostgreSQL SELECTs and joins from the diagram, where the recursive CTE actually goes, and what it will not do to production.

Postgresql • 31-Aug-2026

How to Run MySQL in Docker Step by Step | DbSchema

Run MySQL in Docker with one docker run command, persist data in a named volume, connect from the host and from DbSchema, and fix common startup errors.

Mysql • 31-Aug-2026

Exploring Master-Detail Data Across Foreign Keys

Explore master-detail data across foreign keys. Understand relational database connections and browse multiple child tables visually without writing SQL.

Design • 30-Aug-2026

PostgreSQL Schema Migration: Deploying Changes Safely

Learn how backend developers can safely manage PostgreSQL schema migrations using lock timeouts, the expand-and-contract pattern, and visual schema sync.

Postgresql • 30-Aug-2026

Working Across a Mixed Database Estate: Architect's Guide

Learn how database architects manage mixed database estates across SQL and NoSQL engines. Unify schema design, documentation, and versioning with DbSchema.

Databases • 30-Aug-2026

SQL NULL Functions Explained with Examples | DbSchema

Learn SQL NULL-handling functions like IFNULL, ISNULL, COALESCE, and NVL, with examples, pitfalls, and practice exercises.

Tutorials • 29-Aug-2026

Database Design Errors to Avoid & How To Fix Them

Six database design mistakes that cost you later — foreign keys, indexes, JSON columns, normalization, naming, documentation — with the fix for each.

Design • 29-Aug-2026

PostgreSQL Transactions Guide with COMMIT and ROLLBACK | DbSchema

BEGIN, COMMIT, ROLLBACK, SAVEPOINT and ROLLBACK TO in one reference, plus isolation levels and the commands PostgreSQL will not run in a transaction.

Postgresql • 29-Aug-2026