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.
On benchmarking

On benchmarking

Comments
11 min read
How to safely remove a Rails column: finding every real reference before you delete

How to safely remove a Rails column: finding every real reference before you delete

Comments
12 min read
Discovering PII Inside InterSystems IRIS

Discovering PII Inside InterSystems IRIS

Comments
12 min read
Don't parse SQL to make a query runner read-only

Don't parse SQL to make a query runner read-only

Comments
3 min read
Your AI Agent Can Run DROP TABLE on Production

Your AI Agent Can Run DROP TABLE on Production

Comments
3 min read
Room-Inspired Local Persistence in Swift: A Production GRDB Architecture

Room-Inspired Local Persistence in Swift: A Production GRDB Architecture

Comments
11 min read
One FLUSHALL Away From Losing Everything

One FLUSHALL Away From Losing Everything

Comments
3 min read
Why Audit Trails Matter in ClickHouse®: Building Accountability, Compliance, and Security

Why Audit Trails Matter in ClickHouse®: Building Accountability, Compliance, and Security

2
Comments 1
4 min read
SQLite Backup Strategy for Production SaaS: WAL, Litestream, Recovery Tests

SQLite Backup Strategy for Production SaaS: WAL, Litestream, Recovery Tests

Comments
9 min read
The Silent Performance Killer in Rails: Understanding and Fixing N+1 Queries

The Silent Performance Killer in Rails: Understanding and Fixing N+1 Queries

Comments
4 min read
Oracle ORA-00911 Error: Causes and Solutions Complete Guide

Oracle ORA-00911 Error: Causes and Solutions Complete Guide

Comments
3 min read
PostgreSQL 22030 Error: Causes and Solutions Complete Guide

PostgreSQL 22030 Error: Causes and Solutions Complete Guide

Comments
3 min read
Building a Natural Language Query Interface for Your Database: A Developer's Blueprint

Building a Natural Language Query Interface for Your Database: A Developer's Blueprint

Comments
7 min read
CloudNativePG: Running PostgreSQL in Kubernetes Without the Pain

CloudNativePG: Running PostgreSQL in Kubernetes Without the Pain

Comments
10 min read
Creating HIPAA-Safe Synthetic Patient Data for Healthcare App Testing

Creating HIPAA-Safe Synthetic Patient Data for Healthcare App Testing

Comments
4 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.