DbSchema Blog

Categories

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

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

What Is a Primary Key in SQL? Definition and Examples (2026) | DbSchema

Learn what a primary key in SQL is, with syntax and examples for MySQL, PostgreSQL, and SQL Server, plus composite keys and primary key vs unique vs foreign key.

Tutorials • 06-Aug-2025

Free SQL Tool to Understand Your Database Visually

Learn SQL faster with a free SQL client that shows your database visually in an ER diagram. See tables, relationships, query results, and edit data easily.

Dbschema features • 05-Aug-2025

What Is a Foreign Key in SQL? Syntax, Rules, and Examples (2026) | DbSchema

Learn SQL foreign key syntax with examples, ON DELETE and ON UPDATE actions, composite keys, and how to add or drop constraints in MySQL, PostgreSQL, and SQL Server.

Tutorials • 31-Jul-2025

Visual Database Management & Design Tool for IBM Db2

Discover an ER diagram tool for IBM Db2 that simplifies schema modeling, database management, querying, Git integration, and documentation. Try it free for 30 days.

Databases • 25-Jul-2025

How to Design and Manage Apache Derby Databases Visually

Visual guide for Apache Derby: create diagrams, edit schema, sync changes, generate docs, and explore data. No SQL required. Try DbSchema free.

Databases • 24-Jul-2025