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.
Back up MySQL and MariaDB to S3: from mysqldump to a verified restore

Back up MySQL and MariaDB to S3: from mysqldump to a verified restore

Comments
6 min read
Building a State-Level Rollup From OpenStreetMap Surveillance Tags

Building a State-Level Rollup From OpenStreetMap Surveillance Tags

Comments
4 min read
I built an AI memory that says “not found” instead of guessing

I built an AI memory that says “not found” instead of guessing

Comments
1 min read
How to Build High-Concurrency Ticketing Systems Without Melting Your Database

How to Build High-Concurrency Ticketing Systems Without Melting Your Database

Comments
9 min read
How fast is PostgreSQL LISTEN/NOTIFY? I ran some benchmarks to find out.

How fast is PostgreSQL LISTEN/NOTIFY? I ran some benchmarks to find out.

Comments
1 min read
A memory comparison that did not survive its own scoring rules

A memory comparison that did not survive its own scoring rules

Comments
5 min read
SQL for absolute beginners: a map of CRUD

SQL for absolute beginners: a map of CRUD

5
Comments
7 min read
PostgREST .or() Breaks Silently on a Comma

PostgREST .or() Breaks Silently on a Comma

Comments
3 min read
Access control belongs in the database, not the UI

Access control belongs in the database, not the UI

Comments
2 min read
A LangGraph SQL agent that only sees the tables it needs

A LangGraph SQL agent that only sees the tables it needs

Comments
1 min read
# Week 09 – Task 2: PostgreSQL Transactions and Basic Indexing

# Week 09 – Task 2: PostgreSQL Transactions and Basic Indexing

5
Comments
8 min read
SQL Challenge: Extract the Year and Month From a Date

SQL Challenge: Extract the Year and Month From a Date

Comments
2 min read
What 18M rows of A-share daily bars taught me about "clean data"

What 18M rows of A-share daily bars taught me about "clean data"

Comments
4 min read
What Happens When Your Team Adds Azure to AWS and GCP

What Happens When Your Team Adds Azure to AWS and GCP

Comments
6 min read
European SaaS Apps: Private Uploaded Images and Signed Thumbnail Delivery

European SaaS Apps: Private Uploaded Images and Signed Thumbnail Delivery

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