DbSchema Blog

Categories

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

SQL Views Explained with Practical Examples | DbSchema

Learn what SQL views are, how to create and update them, and how to manage views visually in DbSchema.

Design • 05-Sep-2026

DbSchema vs DbVisualizer

DbSchema vs DbVisualizer compared side by side in 2026: engine support, diagramming, query tooling, data editing, documentation and current pricing.

Design • 05-Sep-2026

Database Design Errors to Avoid & How To Fix Them

Six database design mistakes that cost you later: foreign keys, indexes, JSON columns, normalization, naming and documentation, with the fix for each.

Design • 05-Sep-2026

Interactive Database Documentation with DbSchema

Learn how to generate interactive HTML5 database documentation with vector diagrams, comments, zoom, and pan in DbSchema.

Design • 05-Sep-2026

DbSchema vs Navicat, DbForge

DbSchema, Navicat and dbForge compared on database modeling features, schema documentation, synchronization and price, for a team choosing one tool.

Design • 05-Sep-2026

Database Design Best Practices: Principles, Normalization and Keys

Database design best practices in one page: the five design principles, the four-step process, 1NF to 3NF with worked examples, and primary, foreign and secondary keys in SQL.

Design • 05-Sep-2026

Building a Query Across Joined Tables Visually

Skip the raw SQL syntax and build queries across joined tables visually in DbSchema. Browse related data across an unlimited number of joined tables.

Design • 05-Sep-2026

DbVisualizer Alternative in 2026: DbSchema for Database Design

DbVisualizer alternative in 2026: DbSchema adds visual modeling, editable ER diagrams, Git versioning, schema sync and interactive HTML5 documentation.

Design • 05-Sep-2026

Team Collaboration in Schema Design with Git

How a team shares one DbSchema model through Git: commit the .dbs file, branch per change, review the diff, resolve a conflicted table.

Design • 05-Sep-2026

DbSchema vs Navicat: Full Feature Comparison for Teams in 2026 | DbSchema

DbSchema 10.5 vs Navicat Premium 17.3.11, compared job by job: ER modelling, offline design, schema sync, Git, NoSQL, documentation and automation.

Design • 05-Sep-2026