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 charity had the proof. It just couldn't show anyone.

DEV Weekend Challenge: Generosity Edition Submission 💜

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

8
Comments
9 min read
Why You Shouldn’t Store Large Files in Your Database: Database vs. Amazon S3

Why You Shouldn’t Store Large Files in Your Database: Database vs. Amazon S3

Comments
3 min read
SQL vs. NoSQL — stop asking the wrong question

SQL vs. NoSQL — stop asking the wrong question

1
Comments
4 min read
Why Adding an Index Won't Fix Your Slow COUNT(*) in PostgreSQL

Why Adding an Index Won't Fix Your Slow COUNT(*) in PostgreSQL

Comments
5 min read
Rank Your Database Tables by Importance with SchemaCrawler

Rank Your Database Tables by Importance with SchemaCrawler

2
Comments
5 min read
Open-source tool: Practical experience in converting large quantities of SQL code syntax : 'PIVOT' function rewrite (Case 2)

Open-source tool: Practical experience in converting large quantities of SQL code syntax : 'PIVOT' function rewrite (Case 2)

Comments
6 min read
SchemaCrawler Has Three Programmatic Models - Here Is When to Use Each One

SchemaCrawler Has Three Programmatic Models - Here Is When to Use Each One

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

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

Comments
7 min read
NoSQL Injection in APIs: From Auth Bypass to JavaScript Execution via MongoDB Operators

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

Comments
5 min read
Framework Binding Gap: How the ORM Accepts Fields You Never Documented

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

Comments
6 min read
Why Redis in Front of Postgres is Slowing You Down

Why Redis in Front of Postgres is Slowing You Down

Comments
3 min read
Claims, Not Facts: Building an Auditable Multi-Author Record for a House

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

Comments
5 min read
How I approached multi-tenancy in Next.js with PostgreSQL RLS

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

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

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

Comments
5 min read
Advanced SQL: Mastering CTEs and Window Functions

Advanced SQL: Mastering CTEs and Window Functions

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