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.
Enable RSA key-pair based authentication - GoldenGate to Snowflake (On Premise)

Enable RSA key-pair based authentication - GoldenGate to Snowflake (On Premise)

Comments
7 min read
An append-only, hash-chained audit log in SQLite, and a script to check it

An append-only, hash-chained audit log in SQLite, and a script to check it

Comments 1
3 min read
Writing SQL in Go Without Losing Type Safety: An Introduction to sqlc

Writing SQL in Go Without Losing Type Safety: An Introduction to sqlc

Comments
2 min read
5 SQL Window-Function Exercises Taken From Real Business Problems

5 SQL Window-Function Exercises Taken From Real Business Problems

Comments
3 min read
I Migrated a Cloudflare Agents Workspace and Measured Everything: What Changes When the Storage Format Changes?

I Migrated a Cloudflare Agents Workspace and Measured Everything: What Changes When the Storage Format Changes?

6
Comments 2
15 min read
Building an Offline-First Bible Reader on iOS: Bundled SQLite, Full-Text Search and iCloud-Synced Notes

Building an Offline-First Bible Reader on iOS: Bundled SQLite, Full-Text Search and iCloud-Synced Notes

Comments
12 min read
How to Auto-Update an updated_at Column: MySQL ON UPDATE vs a Database Trigger vs the ORM

How to Auto-Update an updated_at Column: MySQL ON UPDATE vs a Database Trigger vs the ORM

Comments
10 min read
SQLite Ignored My ON DELETE CASCADE: Foreign Keys Are Off Until Each Connection Turns Them On

SQLite Ignored My ON DELETE CASCADE: Foreign Keys Are Off Until Each Connection Turns Them On

Comments
8 min read
PostgreSQL 17 VACUUM Overhaul: Adaptive Radix Trees End the 1GB Limit

PostgreSQL 17 VACUUM Overhaul: Adaptive Radix Trees End the 1GB Limit

Comments
2 min read
Designing data-intensive applications: replication, partitioning, quorums

Designing data-intensive applications: replication, partitioning, quorums

Comments
4 min read
What Breaks When You Migrate Petabytes: A Field Guide

What Breaks When You Migrate Petabytes: A Field Guide

1
Comments
4 min read
Where a slow call spends its time. SQL took 0.2 ms; the wait was six round trips

Where a slow call spends its time. SQL took 0.2 ms; the wait was six round trips

1
Comments 1
3 min read
notes on learning the streaming side of the warehouse

notes on learning the streaming side of the warehouse

1
Comments
6 min read
Is AI Still Lacking Systems Thinking?

Is AI Still Lacking Systems Thinking?

Comments
3 min read
A Single SQL Constraint Can Save Your Database From Bad Data — Do You Know Which One?

A Single SQL Constraint Can Save Your Database From Bad Data — Do You Know Which One?

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