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.
Queue vs Direct Insert: What Happens When 10,000 Users Hit Your Database at Once

Queue vs Direct Insert: What Happens When 10,000 Users Hit Your Database at Once

7
Comments
6 min read
MongoDB vs PostgreSQL: When to Choose Which One? (With Real-World Examples)

MongoDB vs PostgreSQL: When to Choose Which One? (With Real-World Examples)

Comments
4 min read
Building a Login Panel with PostgreSQL Authentication in Rust (egui + sqlx)

Building a Login Panel with PostgreSQL Authentication in Rust (egui + sqlx)

Comments
1 min read
Database Indexes Explained Like You're 5

Database Indexes Explained Like You're 5

Comments 1
7 min read
Mastering PostgreSQL Query Optimization: Techniques for Efficient Queries

Mastering PostgreSQL Query Optimization: Techniques for Efficient Queries

Comments
3 min read
Portabase: A self-hosted tool for database backup & restore

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

5
Comments 1
3 min read
PostgreSQL backup encryption — How to encrypt your PostgreSQL database backups

PostgreSQL backup encryption — How to encrypt your PostgreSQL database backups

Comments
8 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
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
Getting Started with Prisma and Neon DB: A Modern Approach to Database Management

Getting Started with Prisma and Neon DB: A Modern Approach to Database Management

Comments
3 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
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

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

Run PgBouncer with SCRAM Auth Using Docker

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