dbdiagram Blog

Learn everything about database design and management - Powered by dbdiagram.io - A free, simple tool to draw ER diagrams by just writing code.

Mastering Crow's Foot Notation: A Comprehensive Guide for Database Design

Crow's Foot Notation is a critical aspect of database design, and its proper understanding can make database modeling much more efficient. In response to common questions found in Reddit posts, here's an enhanced guide that provides a more in-depth, SEO-friendly explanation, aimed to outperform community-sourced content. The goal is to

Database Design

How to Create Database Documentation Using dbdocs with DBML

Database documentation plays a crucial role in maintaining and scaling systems. Clear and well-organized documentation can significantly improve communication between team members and enhance project longevity. One of the most efficient ways to document a database is through dbdocs and DBML - an open sourced Database Markup Language. In this

Database Design

MongoDB or SQL Databases: Which One Should You Use?

Analytics on MongoDB is a completely different beast from typical business intelligence setups that you’re familiar with. This article explains why.

How To Combine Data from Multiple Databases Into One Table

Question: if I have different customers, each with their own Databases with similar structure, how do I combine/append them into a single data-warehouse table? C1-T1 C2-T1 C3-T1 All goes into DW-T1, with additional customer_id column Approach: multiple data imports, and a transform/view We suggest to create multiple

What Is A Data Modeling Layer?

This article was originally written by Cedric Chin for Holistics.io Most fields have trends. Some of these trends turn out to be fads, while others stick around. As a field, data analytics is no different. A thinker or a company or a practitioner introduces a new approach to an

ER Diagram

Top 5 free ER diagram design tools

In software engineering, ER diagram design is an essential process during the project planning phase. ER diagram design helps you analyze data requirements systematically to produce a well-designed database. A decent tool guarantees you to produce high-quality database design to use in database creation, management, and maintenance. An ER diagram

dbdiagram.io - A Database Diagram Designer Built for Developers and Analysts

Starting as a feature developed by our interns to help our customers visualize their database schemas on holistics.io (Business Intelligence Platform), we found an opportunity to release dbdiagram.io as a standalone tool to support and contribute to the data community. That’s how dbdiagram.io was built, as