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.
MongoDB vs PostgreSQL: Which One Should You Choose?

MongoDB vs PostgreSQL: Which One Should You Choose?

5
Comments
3 min read
How to seed million rows!!

How to seed million rows!!

Comments
1 min read
PlanetScale vs. ⚔ Neon: the Continued Saga between MySQL 🐬 and PostgreSQL 🐘

PlanetScale vs. ⚔ Neon: the Continued Saga between MySQL 🐬 and PostgreSQL 🐘

6
Comments
9 min read
Time for enhancing the development tools with GenAI, first PostgreSQL IDE

Time for enhancing the development tools with GenAI, first PostgreSQL IDE

11
Comments
4 min read
SCRAM Authentication in PostgreSQL and SCRAM Pass-Through Authentication

SCRAM Authentication in PostgreSQL and SCRAM Pass-Through Authentication

1
Comments
5 min read
Building a Stock Data Pipeline with requests, Apache Airflow and PostgreSQL

Building a Stock Data Pipeline with requests, Apache Airflow and PostgreSQL

1
Comments
4 min read
No Index for LIKE on JSONB with Array in the Path (GIN limitation)

No Index for LIKE on JSONB with Array in the Path (GIN limitation)

3
Comments
5 min read
🚦 Oracle 19c vs PostgreSQL 15 — The Ultimate Parameter Showdown!

🚦 Oracle 19c vs PostgreSQL 15 — The Ultimate Parameter Showdown!

1
Comments
12 min read
PostgreSQL 🐘 Hosting Options in 2025: Pricing Comparison 💸⚖️

PostgreSQL 🐘 Hosting Options in 2025: Pricing Comparison 💸⚖️

5
Comments
5 min read
No Index Only Scan on JSONB Fields (even on scalar)

No Index Only Scan on JSONB Fields (even on scalar)

12
Comments 1
4 min read
How to handle files?

How to handle files?

1
Comments
50 min read
PostgreSQL UUID Performance: Benchmarking Random (v4) and Time-based (v7) UUIDs

PostgreSQL UUID Performance: Benchmarking Random (v4) and Time-based (v7) UUIDs

23
Comments 3
12 min read
The Database Meets the Lakehouse: Toward a Unified Architecture for Modern Applications

The Database Meets the Lakehouse: Toward a Unified Architecture for Modern Applications

4
Comments 3
6 min read
Intro to PostgreSQL with JSONB compared to MongoDB, a general purpose document database

Intro to PostgreSQL with JSONB compared to MongoDB, a general purpose document database

10
Comments
2 min read
How PostgreSQL logical decoding and plugins work

How PostgreSQL logical decoding and plugins work

1
Comments
6 min read
Stream PostgreSQL WALs with Zero Data Loss in Mind

Stream PostgreSQL WALs with Zero Data Loss in Mind

1
Comments
8 min read
Using testcontainers to improve performance in integration tests

Using testcontainers to improve performance in integration tests

1
Comments
4 min read
Deploy your Django app with Postgres DB to production using Docker and Nginx

Deploy your Django app with Postgres DB to production using Docker and Nginx

6
Comments
8 min read
Spinning Up PostgreSQL with Docker Compose + Dashboard

Spinning Up PostgreSQL with Docker Compose + Dashboard

Comments
2 min read
How Debezium captures changes from Postgres

How Debezium captures changes from Postgres

Comments
5 min read
Choosing the right, real-time, Postgres CDC platform

Choosing the right, real-time, Postgres CDC platform

Comments
8 min read
MCP Server: Integrate Database with AI

MCP Server: Integrate Database with AI

3
Comments
4 min read
A developer's reference to Postgres change data capture (CDC)

A developer's reference to Postgres change data capture (CDC)

Comments
12 min read
Xata Agent v0.2.0: Powered-up chat, custom playbooks, GCP support & more

Xata Agent v0.2.0: Powered-up chat, custom playbooks, GCP support & more

Comments
5 min read
What's New 🆕🤯 in PostgreSQL 18 🐘 - a DBA's Perspective

What's New 🆕🤯 in PostgreSQL 18 🐘 - a DBA's Perspective

5
Comments
5 min read
loading...