DbSchema Blog

Categories

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

Reverse Engineering a PostgreSQL Database

Learn how to reverse-engineer an existing PostgreSQL database into an offline ER diagram, extract the pg_catalog schema, and map undeclared relations.

Postgresql • 05-Sep-2026

PostgreSQL Schema Version Control: Methods and Tools

Discover how to manage PostgreSQL schema version control using Git workflows. Learn to diff XML models and generate automated migration scripts safely.

Postgresql • 05-Sep-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 • 05-Sep-2026

Improve Performance with Range Partitioning in PostgreSQL

Discover how PostgreSQL range partitioning splits large tables into smaller parts based on values like dates or numbers, making queries faster and maintenance easier.

Postgresql • 05-Sep-2026

PostgreSQL CREATE INDEX Guide with psql and DbSchema | DbSchema

Learn how to create indexes in PostgreSQL using psql and DbSchema, including index options, limitations, and practical examples.

Postgresql • 05-Sep-2026

PostgreSQL Database Design Tools: Visual Comparison

DbSchema, pgModeler, SqlDBM, dbdiagram.io and ChartDB compared as PostgreSQL design tools: reverse-engineering, offline modelling and current pricing.

Postgresql • 05-Sep-2026

How to Handle Large PostgreSQL Schemas with a GUI Tool

Learn how to manage large PostgreSQL schemas with a visual database tool: split diagrams, compare changes, document tables, and handle 10,000+ tables.

Postgresql • 05-Sep-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 • 05-Sep-2026

PostgreSQL Schema Migration: Deploying Changes Safely

Deploy PostgreSQL schema changes without blocking traffic: lock_timeout, constant defaults, NOT VALID constraints and CREATE INDEX CONCURRENTLY.

Postgresql • 05-Sep-2026

SQLite UNION vs UNION ALL Explained with Examples | DbSchema

Learn how to use SQLite UNION and UNION ALL with examples in sqlite3 and DbSchema, including differences, limits, and practical use cases.

Sqlite • 05-Sep-2026