DbSchema Blog

How to Handle Large PostgreSQL Schemas with a GUI Tool

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 • 09-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

DbSchema 9.8.3 Release Notes – New Features and Updates

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

Release notes • 28-Aug-2025

MongoDB $lookup Explained - How to Join Collections

Learn how to use MongoDB's $lookup stage to combine documents from different collections, similar to SQL joins.

Mongodb • 27-Aug-2025

Create ER Diagrams for MySQL with a Free GUI Tool

Learn how to design and manage MySQL databases visually with ER diagrams. Reverse engineer existing schemas or create new ones from scratch.

Mysql • 26-Aug-2025

SQL UPDATE Statement Explained with Examples

The UPDATE statement in SQL is used to modify the data of an existing record in a database table. We can update single or multiple columns. Is part of DML.

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

DbVisualizer Alternative in 2025 - DbSchema for Database Design

Best DbVisualizer alternative in 2025: DbSchema offers visual modeling, diagrams, Git integration, schema sync, and interactive documentation.

Design • 20-Aug-2025

DBeaver Alternative in 2025 - DbSchema for Database Design

Best DBeaver alternative in 2025: DbSchema offers visual database design, ER diagrams, Git integration, schema sync, and HTML5 documentation..

Design • 19-Aug-2025

DbSchema Blog

Categories