dbdiagram Blog
All posts 27
AdventureWorks Database Schema: Introduction, Examples, Installation, SQL Practice, and More
Learn about the AdventureWorks database schema, its structure, key tables, relationships, and how to use it for SQL practice and database management. Perfect for beginners and SQL enthusiasts.
Top 3 Enterprise Data Catalog Tools: Current Demands and Top 3 Tools
Explore the latest trends in enterprise data catalog tools for 2025. Understand market demands, challenges, and why dbdocs.io, Alation, and Informatica stand out for different business needs.
Top 3 Healthcare Data Management Tools You Should Know
Explore the top 3 healthcare data management tools—dbdocs, dbdiagram, and RunSQL. Learn how these tools streamline schema design, metadata documentation, and SQL testing for hospitals and providers.
What is a Data Dictionary in Healthcare? Real Examples, Use Cases & Tools Explained
Discover what a data dictionary in healthcare is, why it matters, and how to build one using real-world examples and tools like dbdocs and dbdiagram. Perfect for healthcare professionals and data teams.
.jpg)
dbdocs vs Talend: Best Data Management Tools in 2025
Discover how dbdocs and Talend address the biggest data management pain points, from data quality to cost and integration. Compare tools, features, and real-world impact to choose the best fit for your team.
Top 3 Dataedo Alternatives in 2025: Why DBDocs stands out
Explore the best alternatives to Dataedo in 2025, including the developer-friendly DBDocs, enterprise-grade Alation, and automated metadata platform Atlan. Compare features, pricing, and ideal use cases.
.jpg)
Top 6 Data Catalog Tools Ranked in 2025 (With a Developer-Friendly Surprise!)
Explore the top data catalog tools of 2025, including AWS Glue, Azure Purview, Atlan, Google Dataplex, Oracle OEMM, and the developer-friendly dbdocs. Learn how these tools can enhance data governance, metadata management, and database documentation.
How to Write Complex SQL Queries: Best Practices & Optimization Tips
Learn how to tackle complex SQL queries with techniques like CTEs, proper indexing, and query modularization. Discover best practices for improving performance, readability, and maintainability across different database platforms.
SQLPlayground.app Alternatives: Top SQL Playgrounds Compared
Looking for SQLPlayground.app alternatives? Discover the best SQL playgrounds with better performance, visual schema builders, and collaboration features for all your SQL testing needs.
Best db-fiddle.com Alternatives: Top Online SQL Playgrounds
Looking for a db-fiddle.com alternative? Discover the best online SQL editors with better performance, multi-database support, and collaboration features.
Best dbfiddle.uk Alternatives: A Comprehensive Comparison
Looking for a dbfiddle.uk alternative? This guide explores the best online SQL editors, comparing features, performance, and collaboration options to help you find the right SQL playground for your needs.
Best SQL Fiddle Alternatives: A Comprehensive Comparison
Looking for a SQL Fiddle alternative? This guide explores the best online SQL editors, comparing features, performance, and collaboration options to help you find the right SQL playground for your needs.
Year-Over-Year (YOY) Growth in SQL: The Ultimate Guide with Examples
Master Year-over-Year (YOY) growth calculations in SQL with practical examples, common use cases, and best practices. Learn how to track business performance metrics effectively using SQL window functions.
COALESCE in SQL – The Ultimate Guide to Handling NULLs and Fallback Values
COALESCE is a powerful SQL function for handling NULL values by returning the first non-null value in a list. This guide explores its syntax, use cases, database-specific implementations, performance considerations, and best practices.
How to rename a column in SQL - Guide for PostgreSQL, MySQL, SQL Server, and Oracle
Renaming a column in SQL is a common task for database management, but the process differs across databases like PostgreSQL, MySQL, SQL Server, and Oracle. This guide will walk you through how to do it for each, using clear examples and addressing potential challenges.
Top 10 SQL Playground Tools: Compare SQL Online Compilers for Developers
A detailed comparison of the top SQL playground tools and online SQL compilers, highlighting the features, performance, and collaboration capabilities of each. Find out why RunSQL is the best choice.
RunSQL vs. DB Fiddle: A Comprehensive Comparison of SQL Playgrounds
A detailed analysis of RunSQL and DB Fiddle, comparing features, usability, and collaboration tools to help developers choose the right SQL playground.
RunSQL vs. dbfiddle.uk: Which one is the Best SQL Playground for Developers?
A detailed comparison between RunSQL and db<>fiddle, focusing on their effectiveness as an SQL playground, and why RunSQL is the superior choice for modern SQL testing and collaboration.
RunSQL vs. SQLFiddle: Which SQL Query Testing Tool is Right for You?
A comprehensive comparison of RunSQL and SQLFiddle, highlighting features, use cases, and why RunSQL is the smarter choice for modern SQL testing and collaboration.
Introducing RunSQL: A Simple SQL Testing Environment for dbdiagram Users
A natural extension of dbdiagram that lets you test SQL queries and share results effortlessly
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.
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.
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?
What Is A Data Modeling Layer?
This article was originally written by Cedric Chin for Holistics.io
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. Don't expect to just fire up your existing BI tool, click at MongoDB, and let it run. It's far more complicated than that. This article explains why MongoDB has essentially a different approach, which is necessary to understand before exploring your options.
Top 5 free ER diagram design tools
In software engineering, ER diagram design is an essential process during the project planning phase.
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.