DEV Community

Database

Posts on building, using, and learning about databases.

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
The charity had the proof. It just couldn't show anyone.

DEV Weekend Challenge: Generosity Edition Submission 💜

The charity had the proof. It just couldn't show anyone.

8
Comments
9 min read
Understanding Relationship Schemas and Joins in Power BI

Understanding Relationship Schemas and Joins in Power BI

Comments
5 min read
Connecting Power BI to SQL Databases

Connecting Power BI to SQL Databases

Comments
10 min read
Mastering SQL Joins and Window Functions: A Comprehensive Guide

Mastering SQL Joins and Window Functions: A Comprehensive Guide

Comments
4 min read
LIKE in SQL, Explained for Beginners

LIKE in SQL, Explained for Beginners

Comments
7 min read
How to Sync Multiple Xero Organisations into One Database

How to Sync Multiple Xero Organisations into One Database

Comments
9 min read
How We Made Audit Logs Immutable at the Storage Layer

How We Made Audit Logs Immutable at the Storage Layer

1
Comments
4 min read
How Cobrainer built graph-based agent memory on one engine

How Cobrainer built graph-based agent memory on one engine

12
Comments
4 min read
Aurora DSQL now supports foreign keys. What else?

Aurora DSQL now supports foreign keys. What else?

Comments
7 min read
I benchmarked Dragonfly vs Redis vs Valkey. First, let me show you how I kept it honest.

I benchmarked Dragonfly vs Redis vs Valkey. First, let me show you how I kept it honest.

Comments
6 min read
Why You Shouldn’t Store Large Files in Your Database: Database vs. Amazon S3

Why You Shouldn’t Store Large Files in Your Database: Database vs. Amazon S3

Comments
3 min read
SQL vs. NoSQL — stop asking the wrong question

SQL vs. NoSQL — stop asking the wrong question

1
Comments
4 min read
Rank Your Database Tables by Importance with SchemaCrawler

Rank Your Database Tables by Importance with SchemaCrawler

2
Comments
5 min read
Why Adding an Index Won't Fix Your Slow COUNT(*) in PostgreSQL

Why Adding an Index Won't Fix Your Slow COUNT(*) in PostgreSQL

Comments
5 min read
Open-source tool: Practical experience in converting large quantities of SQL code syntax : 'PIVOT' function rewrite (Case 2)

Open-source tool: Practical experience in converting large quantities of SQL code syntax : 'PIVOT' function rewrite (Case 2)

Comments
6 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.