DbSchema Blog

Categories

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

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 • 09-Sep-2026

SQL TOP, LIMIT, FETCH FIRST, and ROWNUM Explained | DbSchema

SQL TOP, LIMIT, FETCH FIRST n ROWS ONLY and ROWNUM compared engine by engine: syntax, worked examples and the pagination form for each.

Tutorials • 09-Sep-2026

MongoDB CRUD Operations: Create, Read, Update, Delete in mongosh and DbSchema | DbSchema

Learn MongoDB CRUD operations with mongosh and DbSchema examples: insert, find, update, delete, bulk writes, projections, sorting, and filters.

Mongodb • 09-Sep-2026

MongoDB Database Design: Schema Visualization with Diagrams

Visualize a MongoDB database as a diagram in DbSchema: reverse-engineer collections, draw virtual relations, edit validation rules, export HTML5 documentation.

Mongodb • 09-Sep-2026

Best MongoDB Tools (2026): GUI Clients, Schema Design, and Query Builders | DbSchema

Compare the best MongoDB tools for 2026, including GUI clients, schema design, query builders, pricing, and team workflows for real projects.

Mongodb • 09-Sep-2026

MongoDB Create Database: mongosh, Atlas, Compass, Docker, and DbSchema | DbSchema

Create a MongoDB database with use and a first insert in mongosh, or through Atlas, Compass, Docker and DbSchema. Why an empty database does not persist.

Mongodb • 09-Sep-2026

Entity Relationship Diagram (ERD): Symbols, Examples, and How to Create One | DbSchema

Learn entity relationship diagram (ERD) symbols, cardinality, and practical examples, then create, validate, and document database models faster with DbSchema.

Design • 09-Sep-2026

Normal Forms Without the Theory

Learn to spot repeating groups and dependencies in your database tables. See how to normalize schemas practically using DbSchema Community Edition.

Design • 09-Sep-2026

Best Database Documentation Tools in 2026: Compared and Reviewed

Seven database documentation tools compared on output formats, live refresh, comments, offline use and real prices. Only three actually generate documentation.

Design • 09-Sep-2026

Free Database Design Tools 2026: Free Tiers Compared | DbSchema

Seven database design tools compared on free tiers only: what each plan includes, where it stops, which engines it covers, and whether it works offline.

Design • 09-Sep-2026