Blog Category design

DbSchema Blog

Beginner’s Guide to Designing a Relational Database Schema

A step-by-step introduction to relational database schema design for beginners, featuring clear explanations, tables, and visual diagrams.

Read

• 11-Jun-2025

DbSchema Blog

How to Design a Relational Database Schema in 2025

Learn how to design a relational database schema from scratch using a real-world example. Understand entities, relationships, normalization, and best practices.

Read

• 10-Jun-2025

DbSchema Blog

MySQL vs MongoDB - Visual Design with Real Data Models

Learn the key differences between MySQL and MongoDB using visual modeling. Compare tables and collections with real-world examples in DbSchema.

Read

• 02-Jun-2025

DbSchema Blog

Design Better Databases - From Theory to Tools with DbSchema

Explore core database design principles, normalization, and keys - plus how tools like DbSchema support visual modeling, Git collaboration, and documentation.

Read

• 30-May-2025

DbSchema Blog

DbSchema Nominated for Best Data Modeling Solution

DbSchema has been nominated for Best Data Modeling Solution in the 2025 DBTA Readers' Choice Awards! Show your support by voting and help us bring this award home.

Read

• 27-May-2025

DbSchema Blog

The Best Tools to Design Database Schemas Visually in 2025

Compare the top 10 visual database design tools in 2025. See screenshots, key features, and which tool fits your team, docs, testing, and Git workflows.

Read

• 23-May-2025

DbSchema Blog

SQL vs. NoSQL | Schema Design Differences Explained Visually

Learn how SQL and NoSQL databases handle schema design. Simple visuals, examples, and pros and cons to help you choose the right approach.

Read

• 21-May-2025

DbSchema Blog

DbSchema at Magdeburg DevDays | Germany 2025

DbSchema joins Magdeburg DevDays 2025 with team sessions on MongoDB design, Git collaboration, and writing clean, maintainable tests.

Read

• 01-May-2025

DbSchema Blog

Top 7 Logical Database Design Tools in 2025

Discover the best logical database design tools in 2025 for creating database-independent models with entities, relationships, and metadata.

Read

• 24-Apr-2025

DbSchema Blog

Create a Logical Database Design with DbSchema

Learn how to create a logical database design in few steps: map entities to tables, define keys, normalize data, and establish relationships using DbSchema.

Read

• 04-Apr-2025

DbSchema Blog

Top 5 Database GUI Clients with Git Integration in 2025

Learn how Git integration in database tools helps teams track changes, prevent conflicts, and collaborate efficiently on database projects.

Read

• 13-Feb-2025

DbSchema Blog

Top 8 Free Database Design Tools for 2025

In this article, we will highlight 8 of the most popular free tools for database design, focusing on their SQL editing capabilities, visual diagramming features, and overall usability.

Read

• 04-Dec-2024

DbSchema Blog

Best Tools for Database Documentation

In this article, we will explore various tools available for database documentation, highlighting their unique features and capabilities to help you choose the best one for your needs.

Read

• 01-Nov-2024

DbSchema Blog

Logical Design Documentation - A Comprehensive Guide for Database Development

In this article, we will explore how DbSchema can help you create powerful logical and physical database documentation, using comments, tags, and advanced features like Conversion Dictionary and Naming Dictionary, and exporting it all to interactive HTML5 documentation.

Read

• 21-Oct-2024

DbSchema Blog

Best Database Tools with Git for Collaborative Design in 2025

Discover collaborative database design tools with Git integration. Compare top options for schema versioning, teamwork, and offline modeling.

Read

• 15-Oct-2024

DbSchema Blog

DbSchema | SQLDays 2022 Germany

DbSchema will be presenter at SQLDays Germany 2022

Read

• 13-Sep-2022

DbSchema Blog

DbSchema | Window Functions in SQL - Use in Data Analysis

Learn about Window Functions in SQL 2022 through practical examples.

Read

• 26-Apr-2022

DbSchema Blog

DbSchema | CSV Editor for Large Files

Release of a large file CSV Editor

Read

• 11-Nov-2021

DbSchema Blog

DbSchema | Interactive Database Documentation

Generate Database Schema Documentation with Vector Image

Read

• 10-Nov-2021

DbSchema Blog

DbSchema Designer | Tool Presentation

A quick tour of DbSchema main features

Read

• 21-Apr-2021

DbSchema Blog

DbSchema | How to Automate Database Tasks

Learn how to automate database tasks, like schema deployment on multiple databases or generate HTML5 documentation

Read

• 10-Mar-2021

DbSchema Blog

DbSchema | Interview - MacLaurin

A technical interview with MacLaurin Group

Read

• 20-Jan-2021

DbSchema Blog

DbSchema | How to import a CSV file in MySql

Learn how to easily import a csv file to your MySQL database with a simple query.

Read

• 05-May-2020

DbSchema Blog

DbSchema | SQL Server - How to return Date Only from GETDATE

In this article, you will learn two ways that will help you return only the date from GETDATE.

Read

• 13-Apr-2020

DbSchema Blog

DbSchema vs Navicat, DbForge

This article compares the features, price, strengths & weaknesses of 3 database modeling tools: Navicat, DbForge and DbSchema

Read

• 10-Apr-2020

DbSchema Blog

DbSchema vs DbVisualizer

In this article, we compare the main features of DbSchema & DbVisualizer.

Read

• 09-Apr-2020

DbSchema Blog

DbSchema | How to Enable Remote Connections in SQL Server

Step-by-step guide on how to enable remote connections in SQL Server and set the Port

Read

• 07-Apr-2020

DbSchema Blog

DbSchema | Diagram Design Tips - The Secrets of Indexes & Fks

In this article, I will present how to use Indexes & Foreign Keys to improve the performance of your database.

Read

• 31-Mar-2020

DbSchema Blog

DbSchema Designer | Relational Data Editor

Learn how to explore databases visually with Relational Data Editor.

Read

• 30-Mar-2020

DbSchema Blog

DbSchema | SQL Views Explained

SQL Views are virtual tables with data derived from one or more base tables. They are not physically stored in the database.

Read

• 29-Feb-2020

DbSchema Blog

DbSchema | SQL Interview Questions

SQL Interview Questions for Developers and Database Administrators

Read

• 15-Apr-2019

DbSchema Blog

DbSchema | SQL Server - Insert multiple rows in a query

In this article, we are going to see how to insert multiple rows in a single SQL query.

Read

• 12-Apr-2019

DbSchema Blog

DbSchema | SQL Server - Use MERGE to update tables

Learn how you can update data to a table based on values matched from another table

Read

• 11-Apr-2019