DbSchema Blog

Categories

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

Show Tables in PostgreSQL: psql, SQL Queries, and Schema Filters | DbSchema

Show tables in PostgreSQL with \dt, \dt+, and SQL queries against information_schema or pg_catalog. Filter by schema, include sizes, and list all objects.

Postgresql • 09-Sep-2026

SQLite JOINs: INNER, LEFT, CROSS, and FULL JOIN Workarounds | DbSchema

Learn SQLite JOIN syntax with INNER, LEFT, CROSS, RIGHT, and FULL JOIN guidance, plus version caveats, performance tips, Python examples, and DbSchema.

Sqlite • 09-Sep-2026

Reverse Engineering a SQLite Database

Learn how to reverse-engineer an unfamiliar SQLite database file into an ER diagram, extract its schema, and add the missing virtual foreign keys.

Sqlite • 09-Sep-2026

SQLite Constraints: PRIMARY KEY, FOREIGN KEY, UNIQUE, CHECK, NOT NULL | DbSchema

Learn SQLite constraints with PRIMARY KEY, FOREIGN KEY, UNIQUE, CHECK, NOT NULL, DEFAULT, Python examples, edge cases, and DbSchema tooling.

Sqlite • 09-Sep-2026

How to Create ER Diagrams for SQLite with a Free Tool

Turn a SQLite database into an ER diagram with DbSchema: connect to the .db file, reverse-engineer it, arrange the diagram, and document what it shows.

Sqlite • 09-Sep-2026

SQLite CREATE TABLE: Syntax, Data Types, Constraints, and Examples | DbSchema

Learn SQLite CREATE TABLE syntax, data types, IF NOT EXISTS, constraints, AUTOINCREMENT, temp tables, and visual table design in DbSchema.

Sqlite • 09-Sep-2026

MySQL DROP CONSTRAINT Foreign Key, Unique, Check, and Primary Key Syntax | DbSchema

Learn MySQL DROP CONSTRAINT patterns for 5.7, 8.0, and 8.4. Remove foreign keys, unique indexes, checks, and primary keys safely in DbSchema.

Mysql • 09-Sep-2026

MySQL ER Diagram, Reverse Engineer and Design Schemas Visually | DbSchema

Create a MySQL ER diagram from an existing database or design one from scratch. See version-aware examples, docs links, and DbSchema workflow tips.

Mysql • 09-Sep-2026

MySQL CREATE TRIGGER Syntax, BEFORE/AFTER Examples, and Audit Patterns | DbSchema

Learn MySQL CREATE TRIGGER syntax for 5.7, 8.0, and 8.4 with BEFORE/AFTER examples, audit trail patterns, validation logic, and DbSchema tips.

Mysql • 09-Sep-2026

Best MySQL Database Design Tools in 2026: Buyer's Comparison

Seven MySQL design tools compared on engines, reverse engineering, offline use, documentation, Git and prices, with what each one does that DbSchema does not.

Mysql • 09-Sep-2026