DbSchema Blog

Categories

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

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

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

Learn SQL COUNT, AVG, and SUM with syntax and examples, including NULL handling, COUNT(*) vs COUNT(column), GROUP BY, HAVING, DISTINCT, and conditional aggregation.

Tutorials • 26-Aug-2025

SQL MIN() and MAX() Functions Explained with Examples | DbSchema

Learn SQL MIN() and MAX() with practical examples, GROUP BY usage, subqueries, HAVING filters, and common mistakes.

Tutorials • 25-Aug-2025

SQL UPDATE Statement: Syntax, Examples, and Safe Patterns (2026) | DbSchema

Learn SQL UPDATE syntax with practical examples, WHERE safety checks, JOIN-based updates, and transaction-safe patterns for MySQL, PostgreSQL, and SQL Server.

Tutorials • 23-Aug-2025

SQL GROUP BY Explained with Examples | DbSchema

Learn SQL GROUP BY with clear examples for COUNT, SUM, AVG, HAVING, and JOIN-based reporting queries.

Tutorials • 21-Aug-2025