DbSchema Blog

Categories

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

Schema Design in SQL vs NoSQL - A Visual Comparison

Learn how schema design changes between SQL and NoSQL databases. See real visual examples, normalization tips, and when to use each model.

Design • 20-Aug-2026

MySQL CREATE TABLE Guide with Examples | DbSchema

Learn how to create tables in MySQL with SQL commands, prerequisites, and visual design steps in DbSchema.

Mysql • 20-Aug-2026

MySQL Workbench Alternatives for Multi-Engine Teams

Compare the top MySQL Workbench alternatives for 2026, including DbSchema, DBeaver, and dbForge Studio, with detailed pricing and feature trade-offs.

Tools • 20-Aug-2026

Data Dictionary Tools Compared: An Architect Guide

Compare the top data dictionary tools, including DbSchema, Dataedo, and Alation, to find the right metadata repository for your stack.

Tools • 20-Aug-2026

SQL COUNT, AVG, and SUM with GROUP BY: Syntax and Examples | DbSchema

COUNT(*) counts every row including NULLs, COUNT(column) skips them, and SUM and AVG ignore NULL. SQL COUNT, AVG, SUM syntax with GROUP BY and HAVING.

Tutorials • 19-Aug-2026

SQL TOP, LIMIT, FETCH FIRST, and ROWNUM Explained | DbSchema

SQL TOP, LIMIT, FETCH FIRST n ROWS ONLY and ROWNUM compared engine by engine: syntax, worked examples and the pagination form for each.

Tutorials • 19-Aug-2026

MongoDB Create Database – mongosh, Atlas, Compass, Docker, and DbSchema | DbSchema

Create a MongoDB database with use and a first insert in mongosh, or through Atlas, Compass, Docker and DbSchema. Why an empty database does not persist.

Mongodb • 19-Aug-2026

Comparing Production and Staging Schemas

Learn how to compare production and staging database schemas, identify hidden schema drift, and use DbSchema to generate precise visual migration scripts.

Migrations • 19-Aug-2026

Comparing Two Database Schemas

How to compare two database schemas and generate safe DDL migration scripts, with DbSchema Pro, Microsoft SSDT and Redgate SQL Compare for SQL Server.

Migrations • 19-Aug-2026

Turning a Schema Diff Into a Safe Migration Script

How database administrators turn a schema diff into a migration script: version the XML design model in Git, generate the DDL, review it before it runs.

Migrations • 19-Aug-2026