DbSchema Blog

Categories

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

Choosing an ER Notation Your Team Can Read

Compare Chen, crow's foot, Barker, IDEF1X and UML class diagrams and pick the ER notation your readers can read, then render one model in it.

Design • 10-Sep-2026

DBeaver Alternative for 2026: Why DbSchema Fits Database Design Better | DbSchema

DbSchema vs DBeaver for schema design, edition by edition, and what Navicat, dbForge, DataGrip, DbVisualizer and Beekeeper Studio offer for the same work.

Design • 10-Sep-2026

PostgreSQL JSONB: Operators, GIN Indexes, and Query Examples | DbSchema

Learn PostgreSQL JSONB operators, GIN indexes, path queries, and update patterns. Explore and document JSONB structures visually in DbSchema.

Postgresql • 10-Sep-2026

Create Table in PostgreSQL: Syntax, Data Types, Constraints, and Examples | DbSchema

Create tables in PostgreSQL with practical syntax, data types, keys, defaults, and IF NOT EXISTS examples. Design and sync tables with DbSchema.

Postgresql • 10-Sep-2026

How to Design a PostgreSQL Schema Visually (Step-by-Step)

PostgreSQL schema design with ER diagrams: create a schema, add tables and columns, set foreign keys, and generate documentation in DbSchema.

Postgresql • 10-Sep-2026

PostgreSQL Foreign Key: ALTER TABLE, CASCADE Rules, and Indexing | DbSchema

Learn PostgreSQL foreign key syntax, ALTER TABLE, NOT VALID, CASCADE rules, and indexing. Model and document table relationships in DbSchema.

Postgresql • 10-Sep-2026

Describe Table in PostgreSQL: psql, SQL Metadata, and Examples | DbSchema

Describe a PostgreSQL table with psql and SQL metadata queries. See columns, defaults, constraints, indexes, and inspect structure in DbSchema.

Postgresql • 10-Sep-2026

SQLite Create Database: CLI, Python, GUI, and DbSchema Setup | DbSchema

Learn how to create a SQLite database with sqlite3, Python, GUI tools, and DbSchema. See file-based setup, first schema steps, and best practices.

Sqlite • 10-Sep-2026

SQLite Indexes: CREATE INDEX, EXPLAIN QUERY PLAN, and Tuning Tips | DbSchema

Learn SQLite indexes with CREATE INDEX, composite and partial indexes, EXPLAIN QUERY PLAN, write tradeoffs, and visual tuning in DbSchema.

Sqlite • 10-Sep-2026

SQLite Functions Explained with Examples | DbSchema

Learn how SQLite functions work with practical COUNT, SUM, AVG, and string examples in sqlite3 and DbSchema.

Sqlite • 10-Sep-2026