DbSchema Blog

PostgreSQL JSONB – Operators, GIN Indexes, and Query Examples | DbSchema

Learn PostgreSQL JSONB operators, GIN indexes, path queries, and update patterns. Explore and document JSONB structures visually in DbSchema.

Postgresql • 07-Jul-2025

How to Document SQL Server Schemas Visually in 2025

Visualize and document your SQL Server schema with ER diagrams, clickable HTML docs, and change tracking. Perfect for teams, audits, and onboarding in 2025.

Sql server • 19-Jun-2025

What Is an Index in MongoDB? Beginner Guide with Examples

Learn what an index is in MongoDB, why it matters, and how to use it. This beginner tutorial explains single-field, compound, and text indexes with examples in MongoDB shell and DbSchema.

Mongodb • 17-Jun-2025

How to Document a PostgreSQL Schema in 2025

Learn how to create diagrams, add comments, track changes, and export HTML5 docs to fully document your PostgreSQL schema using DbSchema in 2025.

Postgresql • 16-Jun-2025

How to Design a Relational Database Schema – Step-by-Step Guide for 2026 | DbSchema

Learn how to design a relational database schema step by step: capture requirements, normalize data, define keys, and model it visually in DbSchema.

Design • 10-Jun-2025

Design Database Schemas Offline & Synchronize with DbSchema

Design database schemas offline in DbSchema. Save ideas anytime, then sync and update your live database when you're back online.

Dbschema features • 19-May-2025

MongoDB Relationships – Embed vs Reference and Visualize in DbSchema | DbSchema

Learn how to visualize MongoDB relationships with embedding, references, one-to-many patterns, and DbSchema diagrams. Decide when to embed vs reference.

Mongodb • 08-May-2025

MongoDb Validation Rules Explained with Examples

Learn how to keep your MongoDB collections clean, structured, and error-free using validation rules - both from the shell and visually in DbSchema.

Mongodb • 14-Apr-2025

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-Apr-2025

Embedded Documents and Arrays | MongoDB Tutorial 2025

Discover how to use embedded documents and arrays in MongoDB for efficient and flexible data modeling in your database design.

Mongodb • 04-Apr-2025

DbSchema Blog

Categories