DbSchema Blog

Categories

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

Best Database Documentation Tools (2026): Compared and Reviewed | DbSchema

Compare the best database documentation tools for 2026. Review ER diagrams, HTML docs, schema comments, and team workflows before choosing.

Design • 01-Nov-2024

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 • 28-Oct-2024

Logical Design Documentation for Database Development

In this article, we will explore how DbSchema can help you create powerful logical and physical database documentation, using comments, tags, and advanced features like Conversion Dictionary and Naming Dictionary, and exporting it all to interactive HTML5 documentation.

Design • 21-Oct-2024

Best Database Tools with Git for Team Design in 2026

Discover collaborative database design tools with Git integration. Compare top options for schema versioning, teamwork, and offline modeling.

Design • 15-Oct-2024

PostgreSQL - Best Database Management Tools in 2025

Find the PostgreSQL best management tools in 2025.

Postgresql • 10-Oct-2024

SQL NULL Functions Explained with Examples | DbSchema

Learn SQL NULL-handling functions like IFNULL, ISNULL, COALESCE, and NVL, with examples, pitfalls, and practice exercises.

Tutorials • 15-Oct-2023

SQL CASE Expression Explained with Practical Examples | DbSchema

Learn SQL CASE expressions with examples for SELECT, ORDER BY, GROUP BY, updates, conditional aggregates, and common mistakes.

Tutorials • 13-Oct-2023

SQL INSERT INTO SELECT: Syntax, Examples, and Safe Data Copy | DbSchema

Learn SQL INSERT INTO SELECT with JOINs, filters, duplicate prevention, and transaction-safe data copy patterns for MySQL, PostgreSQL, and SQL Server.

Tutorials • 12-Oct-2023

SQL SELECT INTO Statement Explained with Examples | DbSchema

Learn SQL SELECT INTO syntax, examples, table-copy patterns, common mistakes, and safe practices for creating new tables from query results.

Tutorials • 11-Oct-2023

SQL ANY and ALL Operators Explained with Examples | DbSchema

Understand SQL ANY and ALL with clear examples, subquery patterns, operator differences, common mistakes, and practice questions.

Tutorials • 10-Oct-2023