#devtopostgresql

PostgreSQL 14 Reaches End of Support on November 12. What Should You Check First?

📰

0Read More

PostgreSQL 14 Reaches End of Support on November 12. What Should You Check First?

DEV Community: postgres·sunny·about 1 hour ago

#aCH235S8

#devtopostgresql #devto #dev #postgresql #upgrade

The PostgreSQL Global Development Group lists November 12, 2026, as the final release date for...

15s

PostgreSQL Query Optimization: Indexes, EXPLAIN ANALYZE, B-tree vs GIN vs GiST & the N+1 Problem 🚀

📰

0Read More

PostgreSQL Query Optimization: Indexes, EXPLAIN ANALYZE, B-tree vs GIN vs GiST & the N+1 Problem 🚀

DEV Community: postgres·Deepika Pusala·about 1 hour ago

#WykbMjkg

#devtopostgresql #devto #dev #index #enter

🚀 PostgreSQL Query Optimization: Let's Learn from ZERO! Imagine your social media app has...

15s

Transactions, Isolation Levels, MVCC, Locking, Triggers, Audit Logs & CAP Theorem in PostgreSQL 🔒

📰

0Read More

Transactions, Isolation Levels, MVCC, Locking, Triggers, Audit Logs & CAP Theorem in PostgreSQL 🔒

DEV Community: postgres·Deepika Pusala·about 1 hour ago

#2jTGMF0y

#devtopostgresql #devto #dev #sql #database

🔒 Isolation, MVCC, Locking, Triggers, Audit Logging & CAP Theorem This is one of the...

15s

# Week 10 -- Task 1: Connecting a NestJS Tasks API to PostgreSQL with TypeORM

📰

0Read More

# Week 10 -- Task 1: Connecting a NestJS Tasks API to PostgreSQL with TypeORM

DEV Community: postgres·koushikmaya·about 1 hour ago

#UJtdQTlG

#devtopostgresql #devto #dev #tasks #task

Introduction Until now, the Tasks API stored its data in memory. That was useful while...

15s

One finance report ran our database host out of memory and Postgres dropped every connection

📰

0Read More

One finance report ran our database host out of memory and Postgres dropped every connection

DEV Community: postgres·Sergey Shinder·about 1 hour ago

#33aFiqfd

#devtopostgresql #devto #dev #postgres #memory

Our order database runs on Postgres 15 on a virtual machine with sixty four gigabytes of memory,...

15s

How we built hybrid search in Postgres: pgvector, full text, and reciprocal rank fusion

🖼️

0Read More

How we built hybrid search in Postgres: pgvector, full text, and reciprocal rank fusion

DEV Community: postgres·Infrenic Team·about 1 hour ago

#6kY7KKEF

#devtopostgresql #devto #dev #search #answer

A question comes in: "What is our notice period for contractors?" Two searches run at once. One...

15s

Stop Using OFFSET for Pagination: Keyset Pagination Is 10,000x Faster on Deep Pages

📰

0Read More

Stop Using OFFSET for Pagination: Keyset Pagination Is 10,000x Faster on Deep Pages

DEV Community: postgres·Muiduzzaman Lipu·about 1 hour ago

#U8fqtT2J

#devtopostgresql #devto #dev #offset #article

Almost every API paginates like this: SELECT * FROM posts ORDER BY created_at DESC, id DESC LIMIT...

15s

4 SQL NULL Traps That Silently Break Your Queries (NOT IN Returns 0 Rows!)

📰

0Read More

4 SQL NULL Traps That Silently Break Your Queries (NOT IN Returns 0 Rows!)

DEV Community: postgres·Muiduzzaman Lipu·about 1 hour ago

#1GcMxbPn

#devtopostgresql #devto #dev #null #select

This query should return three users. It returns zero. No error, no warning: SELECT * FROM...

15s

Our reports hung for fifteen minutes every morning on connections the firewall had already forgotten

📰

0Read More

Our reports hung for fifteen minutes every morning on connections the firewall had already forgotten

DEV Community: postgres·Sergey Shinder·about 1 hour ago

#NcEUFAHB

#devtopostgresql #devto #dev #firewall #connection

Our reporting service is a Python application that queries a Postgres replica in another network...

15s

Our whole account system is an email address and 60 bits, and the 32-letter alphabet is why the modulo is not biased

📰

0Read More

Our whole account system is an email address and 60 bits, and the 32-letter alphabet is why the modulo is not biased

DEV Community: postgres·Daniel Pertu·about 1 hour ago

#cPYCSOsW

#devtopostgresql #devto #dev #token #email

Notifio has no accounts, no passwords and no sessions. A census of what that leaves: one table, four unique columns, two forms on 38 pages, zero Set-Cookie headers, and one activation token a human can retype from an email.

15s

Exchange Rates API Data in a Database: Schema, Indexes and As-Of Queries

📰

0Read More

Exchange Rates API Data in a Database: Schema, Indexes and As-Of Queries

DEV Community: postgres·Exchange Rate API·about 14 hours ago

#yiT1dLkt

#devtopostgresql #devto #dev #rate #rates

How to store exchange rates API data: a Postgres schema with NUMERIC rates, keys, as-of lookups, idempotent upserts and daily loading.

15s

Quick tip: one Postgres advisory lock stops your scheduled job running twice

📰

0Read More

Quick tip: one Postgres advisory lock stops your scheduled job running twice

DEV Community: postgres·delay.run·about 14 hours ago

#pdV8bvvV

#devtopostgresql #devto #dev #lock #connection

You scaled to two servers and now the nightly job runs twice. If you already have Postgres, you don't need a new coordination service to fix it. Here's the pattern, with the gotchas.

15s

5 Essential Tools for AI Agent Database Security in 2026: Controlled Reads and Checked Changes

📰

0Read More

5 Essential Tools for AI Agent Database Security in 2026: Controlled Reads and Checked Changes

DEV Community: postgres·Claix·about 14 hours ago

#E6Hp5eMW

#devtopostgresql #devto #dev #claix #agent

Quick answer The five essential tools for securing how AI agents access a database are...

15s

Build Buddy, Day 5: my vector search's best match was a wrong answer

🖼️

0Read More

Build Buddy, Day 5: my vector search's best match was a wrong answer

DEV Community: postgres·Gabby Gill·about 14 hours ago

#IwGQfhf7

#devtopostgresql #devto #dev #wrong #null

Day 5 of MLH Global Hack Week: Builders Week. All week, Build Buddy has been collecting explanations...

15s

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

🖼️

0Read More

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

DEV Community: postgres·Jimmy Yeung·about 14 hours ago

#Nhbm11tO

#devtopostgresql #devto #dev #patient #postgres

A deep dive into building a patient-scoped FHIR cache on object storage. 1. The problem:...

15s

Scheduled Payment Cleanup Recovery: Postgres pg_cron, App Cron, or Webhook Scheduler?

📰

0Read More

Scheduled Payment Cleanup Recovery: Postgres pg_cron, App Cron, or Webhook Scheduler?

DEV Community: postgres·DemetriusReed2163·about 14 hours ago

#snjYW3iV

#devtopostgresql #devto #dev #database #self

Short answer: for a nightly payment reconciliation cleanup, choose the least complex scheduler that...

15s

Postgres to BigQuery CDC Tutorial: From the WAL to a Four-Part Table Name

🖼️

0Read More

Postgres to BigQuery CDC Tutorial: From the WAL to a Four-Part Table Name

DEV Community: postgres·Shubham Baldava·about 14 hours ago

#3lJnIm5e

#devtopostgresql #devto #dev #bigquery #olake

Replicate Postgres to BigQuery with change data capture: an open source tool writes the WAL into a BigLake catalog that BigQuery, DuckDB and Spark query. Real run numbers.

15s

Idempotency in REST APIs: how I prevented duplicate charges with an Idempotency-Key

📰

0Read More

Idempotency in REST APIs: how I prevented duplicate charges with an Idempotency-Key

DEV Community: postgres·Jhoan Sebastian Rojas Holguin·about 14 hours ago

#RlW3j5i6

#devtopostgresql #devto #dev #response #payments

🔥 The problem The client sends a POST /payments, the network drops before the response...

15s

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

📰

0Read More

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

DEV Community: postgres·Franck Pachot·about 14 hours ago

#23nxNvPG

#devtopostgresql #devto #dev #false #true

Vector search queries often use top-k similarity, assuming the highest-scoring results are true and...

15s

Menu

PostgreSQL 14 Reaches End of Support on November 12. What Should You Check First?

PostgreSQL Query Optimization: Indexes, EXPLAIN ANALYZE, B-tree vs GIN vs GiST & the N+1 Problem 🚀

Transactions, Isolation Levels, MVCC, Locking, Triggers, Audit Logs & CAP Theorem in PostgreSQL 🔒

# Week 10 -- Task 1: Connecting a NestJS Tasks API to PostgreSQL with TypeORM

One finance report ran our database host out of memory and Postgres dropped every connection

How we built hybrid search in Postgres: pgvector, full text, and reciprocal rank fusion

Stop Using OFFSET for Pagination: Keyset Pagination Is 10,000x Faster on Deep Pages

4 SQL NULL Traps That Silently Break Your Queries (NOT IN Returns 0 Rows!)

Our reports hung for fifteen minutes every morning on connections the firewall had already forgotten

Our whole account system is an email address and 60 bits, and the 32-letter alphabet is why the modulo is not biased

Exchange Rates API Data in a Database: Schema, Indexes and As-Of Queries

Quick tip: one Postgres advisory lock stops your scheduled job running twice

5 Essential Tools for AI Agent Database Security in 2026: Controlled Reads and Checked Changes

Build Buddy, Day 5: my vector search's best match was a wrong answer

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

Scheduled Payment Cleanup Recovery: Postgres pg_cron, App Cron, or Webhook Scheduler?

Postgres to BigQuery CDC Tutorial: From the WAL to a Four-Part Table Name

Idempotency in REST APIs: how I prevented duplicate charges with an Idempotency-Key

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