DbSchema Blog

Categories

DbSchema Blog

What Is an ER Diagram? Beginner's Guide

Beginner’s guide to ER diagrams (ERD): what a db diagram is, how to read a database schema diagram, primary vs foreign keys, and one library example with SQL.

• 24-Sep-2025

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.

• 17-Sep-2025

DbSchema Blog

How to Handle Large PostgreSQL Schemas with a GUI Tool

Learn how to manage large PostgreSQL schemas with a visual database tool: split diagrams, compare changes, document tables, and handle 10,000+ tables.

• 09-Sep-2025

DbSchema Blog

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.

• 08-Sep-2025

DbSchema Blog

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.

• 28-Aug-2025

DbSchema Blog

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.

• 27-Aug-2025

DbSchema Blog

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.

• 26-Aug-2025

DbSchema Blog

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.

• 23-Aug-2025

DbSchema Blog

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.

• 21-Aug-2025

DbSchema Blog

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.

• 21-Aug-2025

first   next   last