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.
Why WHERE phone = NULL Returns Nothing in SQL
dechive profile

Why WHERE phone = NULL Returns Nothing in SQL

#beginners #database #sql #tutorial
Comments
4 min read
OLAP vs OLTP: What's the Difference and Why Does It Matter?
robert_njuguna profile

OLAP vs OLTP: What's the Difference and Why Does It Matter?

#luxdev #database #dataengineering
1
Comments
3 min read
I Built an API That Replaces Hours of FDA Drug Safety Analysis With One Call
pharmasignal profile

I Built an API That Replaces Hours of FDA Drug Safety Analysis With One Call

#ai #python #database #opensource
Comments
2 min read
Zero-Downtime PostgreSQL Major Version Upgrades in Containers: The Problem Nobody Talks About
abhsss96 profile

Zero-Downtime PostgreSQL Major Version Upgrades in Containers: The Problem Nobody Talks About

#database #docker #postgres #tooling
Comments 1
11 min read
Why your LLM knows more about ancient Rome than your own database
mads_hansen_27b33ebfee4c9 profile

Why your LLM knows more about ancient Rome than your own database

#ai #database #mcp #postgres
1
Comments
3 min read
1.2.3 Query Tree Node Types: Query, RangeTblEntry, TargetEntry
joonghyukshin profile

1.2.3 Query Tree Node Types: Query, RangeTblEntry, TargetEntry

#postgres #database #internals #query
Comments
7 min read
Why Polars is Faster Than Pandas (10Million Row Study)
rakshath profile

Why Polars is Faster Than Pandas (10Million Row Study)

#python #datascience #performance #database
Comments
6 min read
Why Adding a Unique SKU Field Broke My Django Migration
mnyawade profile

Why Adding a Unique SKU Field Broke My Django Migration

#backend #database #django #python
Comments
4 min read
What Game Engines Know About Data That Databases Forgot
nockawa profile

What Game Engines Know About Data That Databases Forgot

#csharp #database #ecs #gamedev
Comments
9 min read
Why PostgreSQL Kept Saying “No space left on device” with 20TB Still Free
neil_min profile

Why PostgreSQL Kept Saying “No space left on device” with 20TB Still Free

#postgres #linux #database #devops
Comments
6 min read
Do you need foreign keys and surrogate keys because you broke your relationships ?
franckpachot profile

Do you need foreign keys and surrogate keys because you broke your relationships ?

#architecture #database #sql #document
3
Comments
9 min read
How to Store Code Intelligence Graphs Efficiently
opprajwal profile

How to Store Code Intelligence Graphs Efficiently

#computerscience #database #performance #systemdesign
1
Comments 1
3 min read
How to Stop Nuking Your Postgres Data When Testing Schema Changes
alanwest profile

How to Stop Nuking Your Postgres Data When Testing Schema Changes

#postgres #database #devops #opensource
Comments
5 min read
Cloud Embeddings vs. Local Sovereign Memory: AI Agent Memory Layer Compared (2026)
vektor_memory_43f51a32376 profile

Cloud Embeddings vs. Local Sovereign Memory: AI Agent Memory Layer Compared (2026)

#ai #vectordatabase #opensource #database
2
Comments 4
12 min read
B-Trees, Clustered Indexes, and the OLAP Revolution (Part 2) đź“Š
piyush6348 profile

B-Trees, Clustered Indexes, and the OLAP Revolution (Part 2) đź“Š

#database #sql #bigdata #systemdesign
Comments
3 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.