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 Perfect Prisma Schema for a SaaS App (Next.js 16 + PostgreSQL)

The Perfect Prisma Schema for a SaaS App (Next.js 16 + PostgreSQL)

1
Comments
3 min read
Why I Built a Multi-Paradigm Database in Rust — And Deployed It on 50+ Raspberry Pis

Why I Built a Multi-Paradigm Database in Rust — And Deployed It on 50+ Raspberry Pis

1
Comments
15 min read
How I Passed the DP-300 Exam by Improving My Preparation Approach

How I Passed the DP-300 Exam by Improving My Preparation Approach

1
Comments 3
12 min read
How to Explore and Work with MongoDB Data Visually

How to Explore and Work with MongoDB Data Visually

6
Comments
4 min read
How I Took Down Prod With a 400ms Migration (And The Playbook I Use Now)

How I Took Down Prod With a 400ms Migration (And The Playbook I Use Now)

Comments
8 min read
ACID Properties in DBMS with Examples (Complete Guide)

ACID Properties in DBMS with Examples (Complete Guide)

Comments
13 min read
pgvector Distance Functions: Cosine vs L2 vs Inner Product

pgvector Distance Functions: Cosine vs L2 vs Inner Product

1
Comments 1
3 min read
Text-to-SQL Finally Gets Real: DySQL-Bench, BibSQL, DLBench Fix the 'Perfect Query' Myth

Text-to-SQL Finally Gets Real: DySQL-Bench, BibSQL, DLBench Fix the 'Perfect Query' Myth

1
Comments
3 min read
PostgreSQL XID Wraparound: What It Is and How to Prevent It

PostgreSQL XID Wraparound: What It Is and How to Prevent It

1
Comments
4 min read
# Understanding Joins and Window Functions in SQL

# Understanding Joins and Window Functions in SQL

2
Comments
7 min read
How to Optimise Backend Performance: A Practical Playbook

How to Optimise Backend Performance: A Practical Playbook

Comments
20 min read
Data Modeling for Agriculture: Combining Cash Flow and Average Daily Gain (ADG) in the Same Database

Data Modeling for Agriculture: Combining Cash Flow and Average Daily Gain (ADG) in the Same Database

1
Comments
7 min read
The Open-Source Alternative to Oracle 26ai: Why PostgreSQL is All You Need

The Open-Source Alternative to Oracle 26ai: Why PostgreSQL is All You Need

5
Comments
5 min read
Firestore's New Query Engine

Firestore's New Query Engine

2
Comments
8 min read
What if SQL could search by meaning? Meet VelesQL

What if SQL could search by meaning? Meet VelesQL

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