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.
PostgreSQL for Beginners: A Serious Database That Is Free and Grows With You

PostgreSQL for Beginners: A Serious Database That Is Free and Grows With You

Comments
2 min read
A Join That Only Matches One Nameplate: 157 Empty NCAP Pages

A Join That Only Matches One Nameplate: 157 Empty NCAP Pages

Comments
3 min read
Similarity Is Not Truth: Comparing vector distance, is_true(), and extract() in Azure AI for PostgreSQL

Similarity Is Not Truth: Comparing vector distance, is_true(), and extract() in Azure AI for PostgreSQL

1
Comments
25 min read
Delta Lake vs Iceberg vs Hudi

Delta Lake vs Iceberg vs Hudi

Comments
9 min read
How We Took Two-Thirds of the Load Off Our Largest Postgres Database - with dead simple approach

How We Took Two-Thirds of the Load Off Our Largest Postgres Database - with dead simple approach

1
Comments
4 min read
Building a Backup and Disaster Recovery Readiness Checker with Oracle AI Database 26ai

Building a Backup and Disaster Recovery Readiness Checker with Oracle AI Database 26ai

Comments
6 min read
What Evidence Makes You Trust a Backup?

What Evidence Makes You Trust a Backup?

Comments
2 min read
Soft Deletes vs. Unique Constraints: The Duplicate SKU Bug That Hid for a Year

Soft Deletes vs. Unique Constraints: The Duplicate SKU Bug That Hid for a Year

Comments
6 min read
Exporting large CSVs from Phoenix without exhausting memory or your database pool

Exporting large CSVs from Phoenix without exhausting memory or your database pool

Comments
5 min read
Database Schema Planning: Operational Best Practices

Database Schema Planning: Operational Best Practices

Comments
2 min read
Preventing Duplicate Leads in CRM Integrations

Preventing Duplicate Leads in CRM Integrations

Comments
2 min read
AI Agent Deleted a Production Database in 9 Seconds: The PocketOS Incident and How to Prevent It

AI Agent Deleted a Production Database in 9 Seconds: The PocketOS Incident and How to Prevent It

2
Comments
9 min read
SQL Challenge #95: BETWEEN With Dates — Can It Miss Records?

SQL Challenge #95: BETWEEN With Dates — Can It Miss Records?

Comments 1
2 min read
CREATE INDEX CONCURRENTLY Failed. The INVALID Index It Left Can Still Tax Every Write

CREATE INDEX CONCURRENTLY Failed. The INVALID Index It Left Can Still Tax Every Write

1
Comments
9 min read
Modelling a Year-End Inventory Snapshot: Cut-Off Events, Lot Status, Variance Audit Trails and Opening Balances

Modelling a Year-End Inventory Snapshot: Cut-Off Events, Lot Status, Variance Audit Trails and Opening Balances

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