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.
A JSONB Side Table Only Wins on Rows You Rewrite Twice

A JSONB Side Table Only Wins on Rows You Rewrite Twice

1
Comments
6 min read
SQL in Depth: Interactive WASM SQLite 3 Workbench & Database Internals from First Principles

SQL in Depth: Interactive WASM SQLite 3 Workbench & Database Internals from First Principles

Comments
1 min read
The transactional outbox pattern in Node.js: never lose an event when the database commits

The transactional outbox pattern in Node.js: never lose an event when the database commits

Comments
4 min read
Binding Sherlock Hits to Durable Agent Memory with pgvector

Binding Sherlock Hits to Durable Agent Memory with pgvector

Comments
5 min read
MySQL to Redshift Without DMS: A Binlog CDC Tutorial Through AWS Glue

MySQL to Redshift Without DMS: A Binlog CDC Tutorial Through AWS Glue

Comments
10 min read
Full-Text and Vector Search for Scanned PDFs with HexDB

Full-Text and Vector Search for Scanned PDFs with HexDB

Comments
5 min read
PostgreSQL 19:用 WAIT FOR LSN 实现“读己之写”

PostgreSQL 19:用 WAIT FOR LSN 实现“读己之写”

Comments
1 min read
Neon vs Supabase free tiers: the difference that kills side projects

Neon vs Supabase free tiers: the difference that kills side projects

Comments
4 min read
Postal codes are the easy part: reference data lessons from 249 countries

Postal codes are the easy part: reference data lessons from 249 countries

Comments
13 min read
Building Senda: Handling Write Timeouts

Building Senda: Handling Write Timeouts

Comments
1 min read
PostgreSQL 19 Is Out: What to Check Before You Upgrade

PostgreSQL 19 Is Out: What to Check Before You Upgrade

6
Comments
23 min read
Shipping a YouTube monetization dataset every month: snapshots, DOIs and an "unable to determine" column

Shipping a YouTube monetization dataset every month: snapshots, DOIs and an "unable to determine" column

Comments
5 min read
Snowflake vs BigQuery vs Redshift vs Databricks: Start With How You're Billed

Snowflake vs BigQuery vs Redshift vs Databricks: Start With How You're Billed

Comments
3 min read
Leaving Oracle: the licence is the easy part

Leaving Oracle: the licence is the easy part

Comments
3 min read
Have you ever restored your database backup?

Have you ever restored your database backup?

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