Menu

#PostGres

396 posts

Feed·
20 of 396 posts
This 4-line migration looks routine and breaks production. A free GitHub Action catches it (looking for 5 teams to try it)
📰
0Read More

This 4-line migration looks routine and breaks production. A free GitHub Action catches it (looking for 5 teams to try it)

DEV Community: github·Muhammad Adnan·about 7 hours ago
#dUWZ3B3z
#devtogithub#technology#devto#dev#migration

Here's a migration that would sail through most code reviews: ALTER TABLE users ADD COLUMN plan...

15s
How the PERN stack talks to its database, tried in 30 minutes
📰
0Read More

How the PERN stack talks to its database, tried in 30 minutes

DEV Community: node·Saarathi Academy·about 19 hours ago
#KWsA6XAK
#devtonodejs#devto#dev#postgresql#query

Thirty minutes, free tools, and one Express route that reads PostgreSQL safely with node-postgres. https://saarathiacademy.com.np/backend-engineering-

15s
We added one nullable column and every pod failed its order lookups until each connection had seen the error
🖼️
0Read More

We added one nullable column and every pod failed its order lookups until each connection had seen the error

DEV Community: java·Sergey Shinder·about 19 hours ago
#9vPKgiis
#devtojava#devto#dev#statement#column

We treat adding a nullable column as the safest migration there is. It needs no rewrite of the table...

15s
Postgres to DuckDB with CDC: One ATTACH Instead of a Nightly Export
🖼️
0Read More

Postgres to DuckDB with CDC: One ATTACH Instead of a Nightly Export

DEV Community: postgres·Shubham Baldava·1 day ago
#m8GASyN8
#devtopostgresql#devto#dev#duckdb#catalog

Postgres to DuckDB with change data capture: an open source tool writes the WAL into Apache Polaris, DuckDB attaches the catalog, and nothing is exported. Real run numbers.

15s
pgcoalesce: a Postgres proxy that merges concurrent point reads
🖼️
0Read More

pgcoalesce: a Postgres proxy that merges concurrent point reads

DEV Community: postgres·kobima6813·1 day ago
#A9L53zQv

A Postgres proxy that merges concurrent primary-key reads into one live query. No cache. 70–91% less DB CPU vs PgBouncer at 5,000 reads/s; p50 rises ~1.8 ms.

15s
How to Sync Billing Data to Prisma Postgres (Stripe, QuickBooks, Xero & Paddle)
🖼️
0Read More

How to Sync Billing Data to Prisma Postgres (Stripe, QuickBooks, Xero & Paddle)

DEV Community: postgres·ilshaad·2 days ago
#zTcjih88
#devtopostgresql#devto#dev#prisma#sync

Sync Stripe, QuickBooks, Xero or Paddle into Prisma Postgres. Which connection string to use, how a...

15s
Postgres to ClickHouse CDC Without Kafka: Attach a Polaris Catalog as a Database
🖼️
0Read More

Postgres to ClickHouse CDC Without Kafka: Attach a Polaris Catalog as a Database

DEV Community: postgres·Shubham Baldava·2 days ago
#Np8zWiQy
#devtopostgresql#devto#dev#catalog#olake

Replicate Postgres to ClickHouse with change data capture: an open source tool writes the WAL into Apache Polaris, and ClickHouse, DuckDB and Trino query it. Real run numbers.

15s
Billing every API request exactly once, without a database on the request path
📰
0Read More

Billing every API request exactly once, without a database on the request path

DEV Community: rust·Théo Mathieu·2 days ago
#7GtqhTm6
#devtorust#devto#dev#edge#replica

In-memory keys and credits, a five-second Postgres sync, retry-safe usage batches, and the failure modes this design accepts.

15s
PostgreSQL errors in your first month, and what they actually mean
📰
0Read More

PostgreSQL errors in your first month, and what they actually mean

DEV Community: postgres·Hollis·4 days ago
#jqUrKoCa
#devtopostgresql#devto#dev#error#role

PostgreSQL's error messages are terse, and a few of them mislead newcomers. "Role does not exist"...

15s
Best Platforms for Running Postgres in Containers (2026): 11 Options Compared on Failover, Backups, and Who Operates the Cluster
📰
0Read More

Best Platforms for Running Postgres in Containers (2026): 11 Options Compared on Failover, Backups, and Who Operates the Cluster

DEV Community: kubernetes·Noah Grinstein·4 days ago
#JX8uKS5U

The best platforms for running PostgreSQL in containers fall into three main groups: Kubernetes with...

15s
Kubernetes CronJob pg_dump backup: does the dump end up on the same node as the database?
🖼️
0Read More

Kubernetes CronJob pg_dump backup: does the dump end up on the same node as the database?

DEV Community: kubernetes·KYUNGHWAN KIM·4 days ago
#6i6JGlpr
#devtokubernetes#devto#dev#backup#server

Kubernetes CronJob pg_dump backup on k3s local-path: 5 of 7 dumps and every etcd snapshot were on the database's own disk. How to check yours.

15s