DbSchema Blog

Categories

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

Reviewing an AI-Proposed Schema Change

An ai schema generator accelerates design but requires expert review. Learn how database architects validate and deploy AI-proposed schema changes safely.

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

Designing a Schema for a Collaborative Task App

Learn how to design a collaborative task app schema using a Git-based workflow. Discover how backend teams branch, diff, and sync XML models safely.

Design • 05-Sep-2026

Documenting a PostgreSQL Database

Document a PostgreSQL database with COMMENT ON, read the text back from pg_description and psql, and export the diagram and data dictionary as one HTML5 file.

Postgresql • 05-Sep-2026

How to Document a Postgres Database

Document a Postgres database with SQL COMMENT statements applied via psql -f, then export the comments and diagram as one interactive HTML5 file with DbSchema.

Postgresql • 05-Sep-2026

How to Generate Random Data in PostgreSQL | DbSchema

Learn how to generate realistic random data for PostgreSQL tables using DbSchema Data Generator patterns, seeds, and preview tools.

Postgresql • 05-Sep-2026

PostgreSQL JOINs Explained with Examples | DbSchema

Learn how to use PostgreSQL JOIN types with practical examples in psql and DbSchema, including INNER, LEFT, RIGHT, FULL, CROSS, NATURAL, and SELF JOIN.

Postgresql • 05-Sep-2026

Improve Your PostgreSQL Database Design and Management with DbSchema

Connect DbSchema to PostgreSQL, reverse-engineer the schema into diagrams, build queries, edit related rows, and export HTML5 documentation.

Postgresql • 05-Sep-2026

How to Copy a PostgreSQL Database Safely | DbSchema

Learn how to copy a PostgreSQL database using SQL and command-line tools, including connection cleanup and template-based cloning.

Postgresql • 05-Sep-2026

ER Postgres Design with DbSchema: Visual PostgreSQL Schema Workflow | DbSchema

Design PostgreSQL schemas visually with DbSchema. Build ER diagrams, edit tables, sync changes, version schema files with Git, and publish docs.

Postgresql • 05-Sep-2026