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 slowest requests on our API were the ones that found nothing

The slowest requests on our API were the ones that found nothing

Comments
14 min read
One Missing WHERE Clause Can Expose Another Customer’s Data

One Missing WHERE Clause Can Expose Another Customer’s Data

Comments
10 min read
Your seed data is lying to you — the case for foreign-key-consistent test data

Your seed data is lying to you — the case for foreign-key-consistent test data

1
Comments 1
2 min read
Open-source tool: Cross-database universal "field-level" data lineage analysis and visualization(Part 3 of 3)

Open-source tool: Cross-database universal "field-level" data lineage analysis and visualization(Part 3 of 3)

Comments
2 min read
Why Legal Research Shouldn’t Be Expensive: Building AdvoHQ’s Own Case-Law Database

Why Legal Research Shouldn’t Be Expensive: Building AdvoHQ’s Own Case-Law Database

Comments
1 min read
Army vs Hibernate

Army vs Hibernate

Comments
14 min read
Database index on generated column to speed up selection on date (for daily stats)

Database index on generated column to speed up selection on date (for daily stats)

Comments
1 min read
Redis 8.4's digest-based SET option cuts a 1MB compare-and-set from 4.3ms to 1.6ms

Redis 8.4's digest-based SET option cuts a 1MB compare-and-set from 4.3ms to 1.6ms

11
Comments 2
7 min read
RDS vs DynamoDB: How I Think About Choosing an AWS Database

RDS vs DynamoDB: How I Think About Choosing an AWS Database

Comments
4 min read
A nightly pg_dump that fails with the reason, not with "Network is unreachable"

A nightly pg_dump that fails with the reason, not with "Network is unreachable"

Comments
4 min read
Why Did Supabase Pause My Project? How to Restore It and Stop It Happening Again

Why Did Supabase Pause My Project? How to Restore It and Stop It Happening Again

1
Comments 2
4 min read
Read Replicas Do Not Fix a Bad Query Plan

Read Replicas Do Not Fix a Bad Query Plan

Comments
4 min read
We announced read only mode and could not even sign in

We announced read only mode and could not even sign in

Comments
2 min read
Your Supabase free-tier database has no backups. Here is how I fixed that in 15 minutes.

Your Supabase free-tier database has no backups. Here is how I fixed that in 15 minutes.

Comments
5 min read
I thought Text-to-SQL was just a translation layer. I was completely wrong. 🤯

I thought Text-to-SQL was just a translation layer. I was completely wrong. 🤯

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