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.
Data Cleaning and Analysis with SQL

Data Cleaning and Analysis with SQL

1
Comments
5 min read
Why I Chose SQLite Over Postgres

Why I Chose SQLite Over Postgres

1
Comments
4 min read
Plataforma gratuita para practicar SQL en español

Plataforma gratuita para practicar SQL en español

1
Comments
1 min read
The Dual-Write Problem and How to Actually Fix It

The Dual-Write Problem and How to Actually Fix It

Comments
5 min read
Your Index Only Scan Is Lying: Covering Indexes and the Visibility Map

Your Index Only Scan Is Lying: Covering Indexes and the Visibility Map

Comments
4 min read
Composite Indexes Explained: Why Column Order Is the Whole Game

Composite Indexes Explained: Why Column Order Is the Whole Game

Comments
4 min read
How to Query CSV Files with Natural Language Locally (No Cloud Uploads)

How to Query CSV Files with Natural Language Locally (No Cloud Uploads)

Comments
2 min read
The Silent Killer of ASP.NET Core Performance: The N+1 Query Problem

The Silent Killer of ASP.NET Core Performance: The N+1 Query Problem

Comments 1
2 min read
QUERY_HISTORY has no PARENT_QUERY_ID. Here's how I traced which statement inside a Snowflake procedure regressed anyway.

QUERY_HISTORY has no PARENT_QUERY_ID. Here's how I traced which statement inside a Snowflake procedure regressed anyway.

2
Comments 2
4 min read
73% of the Software Versions We Track Are Already End of Life

73% of the Software Versions We Track Are Already End of Life

Comments
5 min read
How Database Indexes Work (And Why Yours Might Be Useless)

How Database Indexes Work (And Why Yours Might Be Useless)

Comments
6 min read
Virtual threads didn't scale your app. They just moved the crash to your database.

Virtual threads didn't scale your app. They just moved the crash to your database.

3
Comments 1
3 min read
🧑‍💻 5 Tools Every Beginner Developer Should Understand

🧑‍💻 5 Tools Every Beginner Developer Should Understand

Comments
2 min read
One GET Method, Not Ten: The Architecture Lesson That Rewired How I Think

One GET Method, Not Ten: The Architecture Lesson That Rewired How I Think

Comments
3 min read
T for Tanuj, T for Timestream: Exploring Amazon Timestream

T for Tanuj, T for Timestream: Exploring Amazon Timestream

1
Comments 1
6 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.