DbSchema Blog

Categories

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

Logical Database Design: Keys and Normalization | DbSchema

How logical design differs from conceptual and physical, how entities become tables, the relationship decisions to make early, and normalization.

Design • 09-Sep-2026

Best Database Schema Design Tools in 2026: Visual Comparison | DbSchema

Compare the top 10 visual database design tools for 2026: ER diagrams, Git integration, documentation, schema sync, and multi-database support. With screenshots.

Design • 09-Sep-2026

Relational Database Schema Design Procedure | DbSchema

The procedure for designing a relational database schema: seven steps, each ending in a decision, from business rules to per-engine types and indexes.

Design • 09-Sep-2026

Create ER Diagrams for PostgreSQL with a Free Design Tool

Design and manage PostgreSQL schemas with a visual ERD tool. Track table relationships, export diagrams, and sync your schema model with Git.

Postgresql • 09-Sep-2026

PostgreSQL List All Schemas: psql, information_schema, pg_namespace, and search_path | DbSchema

List PostgreSQL schemas with psql, information_schema, and pg_namespace. Filter system schemas, inspect search_path, and browse them in DbSchema.

Postgresql • 09-Sep-2026

Best PostgreSQL Database Tools in 2026: 6 GUIs Compared

DbSchema, pgAdmin, Navicat, DbVisualizer, DBeaver and dbForge compared on engines, free tier, price and team features. Prices checked September 2026.

Postgresql • 09-Sep-2026

PostgreSQL CREATE PROCEDURE: IN/OUT Parameters, CALL, Transactions, and Errors | DbSchema

Learn PostgreSQL CREATE PROCEDURE with IN/OUT parameters, CALL syntax, transactions, and EXCEPTION handling. Compare procedures vs functions in DbSchema.

Postgresql • 09-Sep-2026

Drop All Tables in PostgreSQL: Safe Methods, CASCADE, and TRUNCATE | DbSchema

Learn how to drop all tables in PostgreSQL safely. Compare DROP SCHEMA, generated DROP TABLE scripts, TRUNCATE, and DbSchema workflows.

Postgresql • 09-Sep-2026

Essential PostgreSQL Commands Reference | DbSchema

psql commands for PostgreSQL 18: connect and switch databases, list schemas and tables, read privileges, dump and restore, find the session holding a lock.

Postgresql • 09-Sep-2026

Top Free PostgreSQL ER Diagram Tools (2026): Compared | DbSchema

Compare top free PostgreSQL ER diagram tools for 2026 with reverse engineering, documentation, and collaboration features to choose the right fit.

Postgresql • 09-Sep-2026