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.
A future revision should not change yesterday's data selection

A future revision should not change yesterday's data selection

Comments
2 min read
What Really Happens When Your App Queries a Database: CPU, Memory, the OS, Async, and Locks Explained

What Really Happens When Your App Queries a Database: CPU, Memory, the OS, Async, and Locks Explained

Comments
42 min read
Freeze the Comparison, Not the Working Document

Freeze the Comparison, Not the Working Document

Comments
3 min read
Go 1.27 Ships a uuid Package. Dropping google/uuid Takes 4 Steps and One NULL Catch

Go 1.27 Ships a uuid Package. Dropping google/uuid Takes 4 Steps and One NULL Catch

Comments
7 min read
SQL: Find the Customers Who Stopped Ordering With a LEFT JOIN (and Why a Plain JOIN Hides the One You Most Need to Call)

SQL: Find the Customers Who Stopped Ordering With a LEFT JOIN (and Why a Plain JOIN Hides the One You Most Need to Call)

Comments
4 min read
SQL: The Monthly Revenue Report in Five Lines (GROUP BY Month Instead of a Spreadsheet Every Month-End)

SQL: The Monthly Revenue Report in Five Lines (GROUP BY Month Instead of a Spreadsheet Every Month-End)

Comments
3 min read
My Supabase keepalive was working. The project paused anyway.

My Supabase keepalive was working. The project paused anyway.

Comments
4 min read
The Bug Behind Double Bookings

The Bug Behind Double Bookings

Comments
8 min read
# From Punch Cards to the Cloud:The Evolution of DBMS (And When You Actually Don't Need One)

# From Punch Cards to the Cloud:The Evolution of DBMS (And When You Actually Don't Need One)

Comments
3 min read
How I Built a Weekly Comfortable Region Ranking Using Weather Data

How I Built a Weekly Comfortable Region Ranking Using Weather Data

Comments
2 min read
The Django ORM Can Do Way More Than .filter()

The Django ORM Can Do Way More Than .filter()

1
Comments
8 min read
Backup and restore for an Android launcher with Room: debounced snapshots and an empty-database gate

Backup and restore for an Android launcher with Room: debounced snapshots and an empty-database gate

2
Comments 2
8 min read
I Copied a Live SQLite Database and the Copy Had No Tables: WAL Mode Keeps Commits in a Second File

I Copied a Live SQLite Database and the Copy Had No Tables: WAL Mode Keeps Commits in a Second File

Comments
10 min read
Your Postgres Get-or-Create Has a Race. Postgres 19's ON CONFLICT DO SELECT Closes It

Your Postgres Get-or-Create Has a Race. Postgres 19's ON CONFLICT DO SELECT Closes It

5
Comments
8 min read
Rizzbase v1.2.0 — local-first encrypted database that never downloads the engine for you

Rizzbase v1.2.0 — local-first encrypted database that never downloads the engine for you

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