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.
Mastering PostgreSQL Query Optimization: Techniques for Efficient Queries
imarwan profile

Mastering PostgreSQL Query Optimization: Techniques for Efficient Queries

#database #postgres #sql #backend
Comments
3 min read
Portabase: A self-hosted tool for database backup & restore
portabase_io profile

Portabase: A self-hosted tool for database backup & restore

#database #postgres #mysql #mongodb
5
Comments 1
3 min read
PostgreSQL backup encryption — How to encrypt your PostgreSQL database backups
piteradyson profile

PostgreSQL backup encryption — How to encrypt your PostgreSQL database backups

#database #postgres
Comments
8 min read
Overview of Real-Time Data Synchronization from PostgreSQL to VeloDB
apachedoris profile

Overview of Real-Time Data Synchronization from PostgreSQL to VeloDB

#postgres #bigdata #database #doris
Comments
5 min read
A safe way to let coding agents interact with your database (without prod write access)
getpochi profile

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

#database #postgres #sql #opensource
1
Comments
12 min read
How We Made SendRec Billing Webhooks Bulletproof
alexneamtu profile

How We Made SendRec Billing Webhooks Bulletproof

#go #postgres #webhooks #opensource
2
Comments
3 min read
How POSTGRES indexing is more efficient than MYSQL
khairul_basar_a2746d66c5f profile

How POSTGRES indexing is more efficient than MYSQL

#postgres #mysql #database #dbms
1
Comments
2 min read
How We Added Folders and Tags to Organize Video Libraries
alexneamtu profile

How We Added Folders and Tags to Organize Video Libraries

#postgres #go #react #opensource
4
Comments 1
4 min read
PostgreSQL backup verification — How to test and validate your PostgreSQL backups
piteradyson profile

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

#database #postgres
Comments
9 min read
Read‑your‑writes on replicas: PostgreSQL WAIT FOR LSN and MongoDB Causal Consistency
franckpachot profile

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

#postgres #mongodb #database #replication
1
Comments
4 min read
Run PgBouncer with SCRAM Auth Using Docker
hasanaliagar profile

Run PgBouncer with SCRAM Auth Using Docker

#pgbouncer #postgres #docker #devops
Comments
1 min read
PostgreSQL vs MySQL: A 2026 Production Decision Framework
matheus_releaserun profile

PostgreSQL vs MySQL: A 2026 Production Decision Framework

#postgres #mysql #database #devops
1
Comments
5 min read
Who's That Pokémon?
nicolas_vbgh profile

Who's That Pokémon?

#postgres #ai #python #beginners
2
Comments
12 min read
Supabase vs Firebase in 2026: The Honest Comparison After Using Both in Production
pockit_tools profile

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

#supabase #firebase #baas #postgres
1
Comments
17 min read
How Instagram Scales Tagging for Billions of Users
nitheesh_gaddam_e36ec4aa4 profile

How Instagram Scales Tagging for Billions of Users

#architecture #microservices #postgres #systemdesign
Comments
2 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.