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 • 21-Jan-2026

MySQL Default Username and Password | DbSchema

Find the real MySQL default root login behavior for 5.7, 8.0, and 8.4, reset passwords safely, and secure access faster with DbSchema.

Mysql • 21-Jan-2026

Database Design Errors to Avoid & How To Fix Them

Avoid common database design mistakes in 2026, like missing foreign keys, poor indexing, and bad JSON use. Learn simple fixes with practical examples.

Design • 15-Jan-2026

Visual DynamoDB Design and Documentation with DbSchema

Reverse engineer existing DynamoDB tables, create new tables, and edit data visually in DbSchema - no JSON or console needed.

Design • 12-Jan-2026

DbSchema 9.9.4 Release Notes – New Features and Updates

Explore the DbSchema release notes, featuring the latest updates, new features, and improvements for database design and management.

Release notes • 11-Jan-2026

The All-in-One Database Design & Management Tool | DbSchema 2026

Learn how to simplify your database design and data management in 2026 with DbSchema - a visual database design tool built to make work faster and easier.

Design • 01-Jan-2026

MongoDB Schema Design Best Practices for 2026

Learn the best MongoDB schema design practices for 2026, common mistakes to avoid, and how DbSchema helps visualize, document, and optimize your collections.

Mongodb • 16-Oct-2025

How to Create Custom Data Types in DbSchema

Create custom data types in DbSchema’s Logical Design to standardize columns; on deployment they convert to native DBMS types like VARCHAR.

Tutorials • 17-Sep-2025

Improve Performance with Range Partitioning in PostgreSQL

Discover how PostgreSQL range partitioning splits large tables into smaller parts based on values like dates or numbers, making queries faster and maintenance easier.

Postgresql • 08-Sep-2025

MongoDB $lookup – Join Collections with Examples, Pipelines, and $unwind | DbSchema

Learn MongoDB $lookup with simple joins, pipeline lookups, $unwind, indexing, and performance tips. Build and inspect joins visually in DbSchema.

Mongodb • 27-Aug-2025