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.
PostgreSQL backup encryption — How to encrypt your PostgreSQL database backups

PostgreSQL backup encryption — How to encrypt your PostgreSQL database backups

Comments
8 min read
Jestr (2014): The Architecture of a Social App and the Power of PostgreSQL Views

Jestr (2014): The Architecture of a Social App and the Power of PostgreSQL Views

1
Comments 1
6 min read
Overview of Real-Time Data Synchronization from PostgreSQL to VeloDB

Overview of Real-Time Data Synchronization from PostgreSQL to VeloDB

Comments
5 min read
A safe way to let coding agents interact with your database (without prod write access)

A safe way to let coding agents interact with your database (without prod write access)

1
Comments
12 min read
How We Made SendRec Billing Webhooks Bulletproof

How We Made SendRec Billing Webhooks Bulletproof

2
Comments
3 min read
How POSTGRES indexing is more efficient than MYSQL

How POSTGRES indexing is more efficient than MYSQL

1
Comments
2 min read
How We Added Folders and Tags to Organize Video Libraries

How We Added Folders and Tags to Organize Video Libraries

4
Comments 1
4 min read
PostgreSQL backup verification — How to test and validate your PostgreSQL backups

PostgreSQL backup verification — How to test and validate your PostgreSQL backups

Comments
9 min read
What MongoDB taught me about Postgres.

What MongoDB taught me about Postgres.

1
Comments
2 min read
Read‑your‑writes on replicas: PostgreSQL WAIT FOR LSN and MongoDB Causal Consistency

Read‑your‑writes on replicas: PostgreSQL WAIT FOR LSN and MongoDB Causal Consistency

3
Comments
4 min read
Run PgBouncer with SCRAM Auth Using Docker

Run PgBouncer with SCRAM Auth Using Docker

Comments
1 min read
PostgreSQL vs MySQL: A 2026 Production Decision Framework

PostgreSQL vs MySQL: A 2026 Production Decision Framework

1
Comments
5 min read
Who's That Pokémon?

Who's That Pokémon?

2
Comments
12 min read
Supabase vs Firebase in 2026: The Honest Comparison After Using Both in Production

Supabase vs Firebase in 2026: The Honest Comparison After Using Both in Production

2
Comments
17 min read
Full-Text Search in PostgreSQL: When You Can Skip Elasticsearch

Full-Text Search in PostgreSQL: When You Can Skip Elasticsearch

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