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

A Visual Query Builder for MySQL: The Data Analyst Guide

Learn how a visual query builder for MySQL helps data analysts explore unlimited tables, build complex queries, and analyze data without writing raw SQL.

Mysql • 05-Sep-2026

ERD Diagrams | MySQL Database Design and Docs with DbSchema

Design MySQL ER diagrams in DbSchema, edit the schema visually, and generate interactive HTML5 documentation from the model.

Mysql • 05-Sep-2026

Reverse Engineering a MySQL Database: A Developer's Guide

Learn how to reverse-engineer a MySQL database to extract its structure, handle missing MyISAM foreign keys, and build an interactive ER diagram offline.

Mysql • 05-Sep-2026

MySQL INSERT INTO Guide with Practical Examples | DbSchema

Learn how to insert data into MySQL tables with SQL examples and visual data import workflows in DbSchema.

Mysql • 05-Sep-2026

How to Document a MySQL Database Schema in 2026

Learn how to document your MySQL database schema in 2026 using modern tools for diagrams, data dictionaries, and interactive HTML documentation.

Mysql • 05-Sep-2026

How to Import CSV into MySQL with SQL and DbSchema | DbSchema

Learn how to import CSV files into MySQL using LOAD DATA and the DbSchema Data Importer, with practical steps and verification tips.

Design • 05-Sep-2026

MySQL Schema Version Control: Git Workflows and Diffs

Learn how to implement MySQL schema version control by saving your design model as an XML file in Git, reviewing diffs, and generating migration scripts.

Mysql • 05-Sep-2026

MySQL Create User CREATE USER, GRANT, Roles, and Host Examples | DbSchema

Learn MySQL CREATE USER and GRANT syntax for 5.7, 8.0, and 8.4, including localhost, wildcard hosts, roles, and secure privilege examples.

Mysql • 05-Sep-2026