Forem

Database

Posts on building, using, and learning about databases.

Posts

đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.
Kysely Has a Free Type-Safe SQL Query Builder With Zero Magic

Kysely Has a Free Type-Safe SQL Query Builder With Zero Magic

Comments
2 min read
Building a Safe Money Transfer System in PostgreSQL — Transactions, Rollbacks, and What Happens When Things Break

Building a Safe Money Transfer System in PostgreSQL — Transactions, Rollbacks, and What Happens When Things Break

Comments
3 min read
Understanding SQL Basics: DDL, DML, Filtering, and Data Transformation
Cover image for Understanding SQL Basics: DDL, DML, Filtering, and Data Transformation

Understanding SQL Basics: DDL, DML, Filtering, and Data Transformation

1
Comments
2 min read
SQL Simplified: DDL, DML, and Essential Commands.
Cover image for SQL Simplified: DDL, DML, and Essential Commands.

SQL Simplified: DDL, DML, and Essential Commands.

3
Comments
4 min read
Your Database Is Fine. Stop Migrating.

Your Database Is Fine. Stop Migrating.

Comments
3 min read
I was tired of manual SQL introspection, so I built Legacy Lens (MCP Server)
Cover image for I was tired of manual SQL introspection, so I built Legacy Lens (MCP Server)

I was tired of manual SQL introspection, so I built Legacy Lens (MCP Server)

Comments
2 min read
HumanExodus: Why I'm Building Measurement Infrastructure for the Largest Labour Transition in History

HumanExodus: Why I'm Building Measurement Infrastructure for the Largest Labour Transition in History

Comments
2 min read
I built a free desktop SQL client with a live database health dashboard

I built a free desktop SQL client with a live database health dashboard

Comments
1 min read
How to manage PostgreSQL roles and permissions — a practical guide
Cover image for How to manage PostgreSQL roles and permissions — a practical guide

How to manage PostgreSQL roles and permissions — a practical guide

Comments
8 min read
Mock What Prisma Returns, Not What Your API Returns
Cover image for Mock What Prisma Returns, Not What Your API Returns

Mock What Prisma Returns, Not What Your API Returns

2
Comments 2
3 min read
Node.js Database Migrations in Production: Zero-Downtime Strategies That Actually Work

Node.js Database Migrations in Production: Zero-Downtime Strategies That Actually Work

Comments
7 min read
Meet Your New AI-Powered Senior DBA: Bridging the Gap Between Metadata and Architectural Excellence
Cover image for Meet Your New AI-Powered Senior DBA: Bridging the Gap Between Metadata and Architectural Excellence

Meet Your New AI-Powered Senior DBA: Bridging the Gap Between Metadata and Architectural Excellence

Comments
2 min read
Behind the Scenes: How Database Traffic Control Works

Behind the Scenes: How Database Traffic Control Works

5
Comments 1
10 min read
Modifying Tables Safely in PostgreSQL — ALTER TABLE, Constraints, and Defaults

Modifying Tables Safely in PostgreSQL — ALTER TABLE, Constraints, and Defaults

Comments
4 min read
Beyond the Hype: Building a Practical AI Memory Layer with Vector Databases

Beyond the Hype: Building a Practical AI Memory Layer with Vector Databases

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