DbSchema Blog

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

DbSchema Design Model - The .dbs Project File Explained

Learn how DbSchema saves your design model in a .dbs project file. Based on XML, easy to version in Git, and editable in any text editor.

Dbschema features • 21-Aug-2025

DBeaver Alternative for 2026 – Why DbSchema Fits Database Design Better | DbSchema

Looking for a DBeaver alternative? Compare DbSchema vs DBeaver for ER diagrams, schema sync, Git, HTML docs, and visual database design.

Design • 19-Aug-2025

How to Design a PostgreSQL Schema Visually (Step-by-Step)

PostgreSQL schema design tutorial. Learn visual database modeling with ER diagrams, create tables, set foreign keys, and generate documentation with a GUI tool.

Postgresql • 12-Aug-2025

DbSchema Blog

Categories