DbSchema Blog

How to Work Better with Foreign Keys and Virtual Keys

Understand foreign keys and learn how to recreate missing relationships using Virtual Foreign Keys in DbSchema for clear, consistent database design.

Design • 13-Oct-2025

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 • 10-Oct-2025

Team Collaboration in Schema Design with Git

Learn how teams can use Git with DbSchema’s schema design projects to track, share, and collaborate on database changes.

Design • 03-Oct-2025

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.

Design • 24-Sep-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

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.

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

DbSchema Blog

Categories