DbSchema Blog

Categories

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

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

How to Create ER Diagrams for SQLite with a Free Tool

Turn a SQLite database into an ER diagram with DbSchema: reverse-engineer the file, design a new schema, document it, and keep the model in Git.

Sqlite • 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

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

SQLite Database Design Tools Compared in 2026

DbSchema, DB Browser for SQLite and Letos compared as SQLite database design tools: what each one does, where it fits, and what it costs.

Sqlite • 05-Sep-2026

SQLite CREATE TRIGGER: BEFORE/AFTER, WHEN Clause, OLD and NEW Examples | DbSchema

Learn SQLite CREATE TRIGGER with BEFORE/AFTER INSERT, UPDATE, DELETE, WHEN clauses, OLD/NEW references, and practical trigger examples.

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

SQLite Expressions Explained with Examples

A taxonomy of SQLite expression types with runnable examples, where SQLite allows one, and how to write one in sqlite3 or DbSchema's SQL Editor.

Sqlite • 05-Sep-2026