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.
Your audit log is probably lying to you. Postgres 18 fixes it in one statement.
remdore profile

Your audit log is probably lying to you. Postgres 18 fixes it in one statement.

#postgres #sql #database #webdev
10
Comments
5 min read
The charity had the proof. It just couldn't show anyone.

DEV Weekend Challenge: Generosity Edition Submission 💜
arqamwd profile

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

#showdev #weekendchallenge #devchallenge #database
8
Comments
9 min read
Hybrid Search in Postgres with pgvector: Field Notes on HNSW, tsvector, and Why Pure Vector Search Missed Exact Matches
ahmed_mahmoud360 profile

Hybrid Search in Postgres with pgvector: Field Notes on HNSW, tsvector, and Why Pure Vector Search Missed Exact Matches

#postgres #ai #database #webdev
Comments
7 min read
A Straightforward Guide for MVCC in Postgres
eyochen profile
Eyo

A Straightforward Guide for MVCC in Postgres

#postgres #database #backend #learning
Comments
14 min read
Behind the Button: How Online Payments Work — and Why They’re Hard to Scale
mreza_kari_dbde0ed2c50b09 profile

Behind the Button: How Online Payments Work — and Why They’re Hard to Scale

#architecture #database #systemdesign #fintech
Comments
5 min read
We Deleted Our Vector Database. Postgres Was Faster.
infoinlet1 profile

We Deleted Our Vector Database. Postgres Was Faster.

#ai #postgres #database #rag
7
Comments
9 min read
NoSQL Injection in APIs: From Auth Bypass to JavaScript Execution via MongoDB Operators
roxdavirox profile
Davi

NoSQL Injection in APIs: From Auth Bypass to JavaScript Execution via MongoDB Operators

#api #cybersecurity #database #security
Comments
5 min read
Framework Binding Gap: How the ORM Accepts Fields You Never Documented
roxdavirox profile
Davi

Framework Binding Gap: How the ORM Accepts Fields You Never Documented

#backend #cybersecurity #database #security
Comments
6 min read
Why Redis in Front of Postgres is Slowing You Down
nainikmehta profile

Why Redis in Front of Postgres is Slowing You Down

#database #redis #postgres #performance
Comments
3 min read
Claims, Not Facts: Building an Auditable Multi-Author Record for a House
salparvez profile

Claims, Not Facts: Building an Auditable Multi-Author Record for a House

#architecture #ai #softwareengineering #database
Comments
5 min read
How I approached multi-tenancy in Next.js with PostgreSQL RLS
wendel_andrady profile

How I approached multi-tenancy in Next.js with PostgreSQL RLS

#architecture #database #nextjs #security
Comments
1 min read
Advanced SQL: Mastering CTEs and Window Functions
rahmanfrr profile
Rahman

Advanced SQL: Mastering CTEs and Window Functions

#sql #database #programming #tutorial
Comments
3 min read
pg_anon caught 1 of my 8 PII columns. My schema isn't in English.
efraingaray profile

pg_anon caught 1 of my 8 PII columns. My schema isn't in English.

#postgres #database #security #programming
Comments
3 min read
What actually happens in a database index (and why half of them do nothing)
vladut02 profile
VLAD

What actually happens in a database index (and why half of them do nothing)

#database #sql #postgres #performance
2
Comments 1
4 min read
Detecting Ceph LARGE_OMAP_OBJECTS Before Deep Scrub Finds It
vexsx profile

Detecting Ceph LARGE_OMAP_OBJECTS Before Deep Scrub Finds It

#database #devops #infrastructure #sre
Comments
19 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.