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.
Why you don't need PITR and incremental backups for most PostgreSQL databases in 2026

Why you don't need PITR and incremental backups for most PostgreSQL databases in 2026

Comments
7 min read
I Stacked 3 Small ML Models and Got Video Search That Feels Like Magic

I Stacked 3 Small ML Models and Got Video Search That Feels Like Magic

Comments
4 min read
FOR UPDATE SKIP LOCKED in MongoDB

FOR UPDATE SKIP LOCKED in MongoDB

1
Comments
6 min read
New to a Large Project? This Is How I Decode Complex Databases

New to a Large Project? This Is How I Decode Complex Databases

1
Comments
2 min read
Postgresus is live on Product Hunt — the open source PostgreSQL backup tool

Postgresus is live on Product Hunt — the open source PostgreSQL backup tool

Comments
2 min read
PostgREST vs RESTHeart

PostgREST vs RESTHeart

Comments
10 min read
IVFFlat Indexing in pgvector

IVFFlat Indexing in pgvector

Comments
3 min read
Chaos testing a Postgres cluster managed by CloudNativePG

Chaos testing a Postgres cluster managed by CloudNativePG

Comments
5 min read
Top 7 pg_dump Backup Strategies for Production-Grade PostgreSQL

Top 7 pg_dump Backup Strategies for Production-Grade PostgreSQL

Comments
6 min read
Need webhooks? Just use the Postgres HTTP extension

Need webhooks? Just use the Postgres HTTP extension

Comments
2 min read
Migrate the legacy Greenplum to Apache Cloudberry with cbcopy

Migrate the legacy Greenplum to Apache Cloudberry with cbcopy

Comments
7 min read
Rethinking Stream-Batch Unification: Real-Time Processing with Incremental Materialized Views in Apache Cloudberry

Rethinking Stream-Batch Unification: Real-Time Processing with Incremental Materialized Views in Apache Cloudberry

Comments
5 min read
Top 5 Backup Formats and When to Use Them for PostgreSQL

Top 5 Backup Formats and When to Use Them for PostgreSQL

Comments
6 min read
Building a Secure Multi-User CRM SaaS with Supabase & Retool (for UK SMEs)

Building a Secure Multi-User CRM SaaS with Supabase & Retool (for UK SMEs)

Comments
3 min read
Practicing SQL with Real Data: INSERT, WHERE, ORDER BY, and GROUP BY

Practicing SQL with Real Data: INSERT, WHERE, ORDER BY, and GROUP BY

1
Comments
3 min read
Learning SQL in Practice: LeetCode Challenges and Setting Up PostgreSQL

Learning SQL in Practice: LeetCode Challenges and Setting Up PostgreSQL

Comments
2 min read
Why Your Fast PostgreSQL Query Suddenly Became Slow: A Deep Dive into MVCC and Index Bloat

Why Your Fast PostgreSQL Query Suddenly Became Slow: A Deep Dive into MVCC and Index Bloat

2
Comments 1
5 min read
Navigating Database Trends: NoSQL, PostgreSQL, & Beyond for Modern Data

Navigating Database Trends: NoSQL, PostgreSQL, & Beyond for Modern Data

Comments
4 min read
Yellowbrick Data - Community Edition Blog

Yellowbrick Data - Community Edition Blog

Comments
5 min read
Postgresus 2.0: new version of open source PostgreSQL backup tool

Postgresus 2.0: new version of open source PostgreSQL backup tool

1
Comments
12 min read
PostgreSQL MVCC vs MySQL Key-Next Locking: How Transaction Isolation Affects Concurrency

PostgreSQL MVCC vs MySQL Key-Next Locking: How Transaction Isolation Affects Concurrency

Comments
4 min read
The RAG Illusion: Why PostgreSQL Beats Vector Search for Most AI Applications

The RAG Illusion: Why PostgreSQL Beats Vector Search for Most AI Applications

Comments
10 min read
Healthcare Analytics Dashboard in Power BI Using PostgreSQL

Healthcare Analytics Dashboard in Power BI Using PostgreSQL

Comments
2 min read
Dynamic List Data Authority

Dynamic List Data Authority

Comments
1 min read
PostgreSQL Log Viewing

PostgreSQL Log Viewing

Comments
1 min read
loading...