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.
Idle in transaction in Postgres: why pg_cancel_backend returns true and changes nothing

Idle in transaction in Postgres: why pg_cancel_backend returns true and changes nothing

Comments
5 min read
61% more Postgres backports: I recounted the delay

61% more Postgres backports: I recounted the delay

Comments
4 min read
Choose a database by access pattern, not by hype

Choose a database by access pattern, not by hype

Comments
3 min read
Modelling EUDR Lot-to-Plot Traceability for Coffee: Plots, Lot Edges and GeoJSON Exports

Modelling EUDR Lot-to-Plot Traceability for Coffee: Plots, Lot Edges and GeoJSON Exports

Comments 2
4 min read
Where macOS keeps Contacts, Calendar, Reminders, Safari tabs and Voice Memos, and how to read them from a backup

Where macOS keeps Contacts, Calendar, Reminders, Safari tabs and Voice Memos, and how to read them from a backup

Comments
4 min read
My Retry Wrote the Row Twice, and the Idempotency Key Was the Bug

My Retry Wrote the Row Twice, and the Idempotency Key Was the Bug

Comments 1
6 min read
pgvector for Beginners: Add Semantic Search to PostgreSQL

pgvector for Beginners: Add Semantic Search to PostgreSQL

Comments
3 min read
Iceberg vs Parquet: do you need a table format?

Iceberg vs Parquet: do you need a table format?

Comments
3 min read
Rider and Databases: Lesser-Known IDE Features That Save Time

Rider and Databases: Lesser-Known IDE Features That Save Time

2
Comments
12 min read
A whole second interview format cost us two columns, one CHECK constraint and a 312-byte migration

A whole second interview format cost us two columns, one CHECK constraint and a 312-byte migration

Comments
4 min read
Logging Diesel Generators Over Modbus RTU With Python: A Hands-On Build

Logging Diesel Generators Over Modbus RTU With Python: A Hands-On Build

Comments
5 min read
pgrecon, an Oracle to PostgreSQL assessment that never connects to your database

pgrecon, an Oracle to PostgreSQL assessment that never connects to your database

Comments
3 min read
Database Transaction là gì? Phân biệt Transaction và SQL thông thường

Database Transaction là gì? Phân biệt Transaction và SQL thông thường

Comments
5 min read
Defining revenue for an SQL agent, one row at a time

Defining revenue for an SQL agent, one row at a time

Comments 1
3 min read
NEXTJS Implimentation Prisma - Supabase

NEXTJS Implimentation Prisma - Supabase

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