DbSchema Blog

Categories

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

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 UPDATE Statement – Syntax, Examples, and Best Practices | DbSchema

Learn the SQL UPDATE statement syntax with examples: update single or multiple columns, use WHERE conditions, JOIN other tables, and avoid common mistakes.

Tutorials • 23-Aug-2025

SQL GROUP BY Explained with Examples

Learn how to use SQL GROUP BY with clear examples. Understand SUM, COUNT, AVG, and HAVING step by step. Beginner-friendly and easy to follow.

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

SQL Joins Explained – INNER, LEFT, RIGHT, and FULL JOIN Diagrams | DbSchema

Learn SQL JOINs with clear INNER, LEFT, RIGHT, FULL, CROSS, and SELF JOIN diagrams, examples, and FAQs. Build and test joins visually in DbSchema.

Tutorials • 08-Aug-2025

SQL Aggregate Functions – COUNT, SUM, AVG, MIN, MAX, and GROUP BY | DbSchema

Learn SQL aggregate functions with COUNT, SUM, AVG, MIN, MAX, GROUP BY, HAVING, and ROLLUP examples. Build reporting queries faster in DbSchema.

Tutorials • 07-Aug-2025