Forem

Database

Posts on building, using, and learning about databases.

Posts

đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.
Prisma vs Drizzle vs ZenStack: Choosing a TypeScript ORM in 2026
Cover image for Prisma vs Drizzle vs ZenStack: Choosing a TypeScript ORM in 2026

Prisma vs Drizzle vs ZenStack: Choosing a TypeScript ORM in 2026

27
Comments
12 min read
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
Cover image for 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
Understanding Joins and Window Functions in SQL
Cover image for Understanding Joins and Window Functions in SQL

Understanding Joins and Window Functions in SQL

2
Comments
5 min read
Next.js 16 SaaS Database Schema with Prisma: Users, Subscriptions, and AI Chat

Next.js 16 SaaS Database Schema with Prisma: Users, Subscriptions, and AI Chat

1
Comments
3 min read
Day 31 of #100DaysOfCode — SQL + NoSQL Basics
Cover image for Day 31 of #100DaysOfCode — SQL + NoSQL Basics

Day 31 of #100DaysOfCode — SQL + NoSQL Basics

3
Comments
3 min read
Clustered vs Non-Clustered Index in SQL(Complete Guide with Examples)
Cover image for Clustered vs Non-Clustered Index in SQL(Complete Guide with Examples)

Clustered vs Non-Clustered Index in SQL(Complete Guide with Examples)

2
Comments
5 min read
How to Explore and Work with MongoDB Data Visually
Cover image for 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 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 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
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
Cover image for 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
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.