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
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
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
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
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
Learn how to use MongoDB's $lookup stage to combine documents from different collections, similar to SQL joins.
Mongodb • 27-Aug-2025
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
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
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
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