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.
LioranDB TypeScript Series #8: Authentication, Users, Roles and Sessions

LioranDB TypeScript Series #8: Authentication, Users, Roles and Sessions

1
Comments
2 min read
LioranDB TypeScript Series #3: Connection Strings, Transports and Client Lifecycle

LioranDB TypeScript Series #3: Connection Strings, Transports and Client Lifecycle

1
Comments
2 min read
Adding Speech Therapy to a Live Directory: The Read-Path Allowlist Pattern at Special Needs Care Network

Adding Speech Therapy to a Live Directory: The Read-Path Allowlist Pattern at Special Needs Care Network

Comments
3 min read
Run AI-Written Migrations on a Throwaway Database Before They Touch Yours

Run AI-Written Migrations on a Throwaway Database Before They Touch Yours

Comments 1
4 min read
Your XenForo Forum Is Slow: A Measurement-First PHP-FPM and MySQL Runbook

Your XenForo Forum Is Slow: A Measurement-First PHP-FPM and MySQL Runbook

Comments
5 min read
Incremental Backup Using pg_basebackup in PostgreSQL 18

Incremental Backup Using pg_basebackup in PostgreSQL 18

1
Comments
7 min read
I Reverse-Engineered a Restaurant ERP With No Documentation. Here's What It Taught Me About Being a Self-Taught Developer.

I Reverse-Engineered a Restaurant ERP With No Documentation. Here's What It Taught Me About Being a Self-Taught Developer.

Comments
4 min read
Postgres RLS multi-tenancy: two leaks that survive correct policies

Postgres RLS multi-tenancy: two leaks that survive correct policies

Comments 2
8 min read
Database Indexing Explained: How Indexes Make SQL Queries Faster

Database Indexing Explained: How Indexes Make SQL Queries Faster

2
Comments
7 min read
Cloudflare D1 has no BEGIN TRANSACTION, so I tested its limits and batch API

Cloudflare D1 has no BEGIN TRANSACTION, so I tested its limits and batch API

1
Comments
3 min read
Your acquisitions table needs a status field, not a boolean

Your acquisitions table needs a status field, not a boolean

Comments
2 min read
SQL Functions — A Friendly Guide With Real Examples

SQL Functions — A Friendly Guide With Real Examples

1
Comments
5 min read
Replace the Heuristic With a Boundary: Rebuilding a Leave Table as an Append-Only Ledger

Replace the Heuristic With a Boundary: Rebuilding a Leave Table as an Append-Only Ledger

Comments
9 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

1
Comments
7 min read
What is Information Schema in PostgreSQL?

What is Information Schema in PostgreSQL?

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