DEV Community

#postgres

Posts on tips and tricks, using and learning about PostgreSQL for database development and analysis.

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
ParadeDB's pg_search 0.26 cuts a ten-term BM25 search from 129ms to 29ms

ParadeDB's pg_search 0.26 cuts a ten-term BM25 search from 129ms to 29ms

8
Comments
8 min read
Migrating a Large Table Without Locking Production

Migrating a Large Table Without Locking Production

Comments
15 min read
When crt.sh's website is down, query its public database instead

When crt.sh's website is down, query its public database instead

Comments
4 min read
Your Postgres backup exists. Does it restore?

Your Postgres backup exists. Does it restore?

Comments
6 min read
Database alerts that don't spam: dedup keys, backtests and shadow mode

Database alerts that don't spam: dedup keys, backtests and shadow mode

Comments
5 min read
Database Indexes: From B-Trees to Production

Database Indexes: From B-Trees to Production

Comments
3 min read
Your Postgres ID columns will run out of numbers. Here's a 10-second check (and the trap that hides it)

Your Postgres ID columns will run out of numbers. Here's a 10-second check (and the trap that hides it)

Comments
4 min read
A Postgres table as our push queue: retries, dead letters, and FCM in Next.js

A Postgres table as our push queue: retries, dead letters, and FCM in Next.js

Comments
9 min read
Node.js Transactional Email Service: Deliverability Plus Preview Tests for Gaming Support

Node.js Transactional Email Service: Deliverability Plus Preview Tests for Gaming Support

Comments 1
6 min read
Hosted Application Logging for Postgres SaaS: API Workers, Cron Jobs, Europe

Hosted Application Logging for Postgres SaaS: API Workers, Cron Jobs, Europe

Comments
6 min read
Implementing a 2FA Login SMS OTP API in Postgres — Cancel Semantics

Implementing a 2FA Login SMS OTP API in Postgres — Cancel Semantics

Comments
6 min read
auth.uid() is null: why Supabase RLS denies your app

auth.uid() is null: why Supabase RLS denies your app

Comments
5 min read
GSTR-2B Reconciliation with Configurable Tolerances in GSTBot

GSTR-2B Reconciliation with Configurable Tolerances in GSTBot

Comments
4 min read
How to Format SQL in PostgreSQL: Styles, Tools, and Team Standards

How to Format SQL in PostgreSQL: Styles, Tools, and Team Standards

Comments
2 min read
Load testing your database with your real query mix: from pg_stat_statements to a weighted load test

Load testing your database with your real query mix: from pg_stat_statements to a weighted load test

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