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.
Evolving Our Infrastructure: Why We Moved from Heroku Postgres to Neon

Evolving Our Infrastructure: Why We Moved from Heroku Postgres to Neon

129
Comments 10
5 min read
PostgreSQL 18 just dropped: 10 powerful new features devs need to know

PostgreSQL 18 just dropped: 10 powerful new features devs need to know

Comments
50 min read
How to Document a PostgreSQL Schema in 2025

How to Document a PostgreSQL Schema in 2025

8
Comments
4 min read
Display a Docker Swarm cluster with 3 nodes

Display a Docker Swarm cluster with 3 nodes

1
Comments
2 min read
Streaming PostgreSQL Backups with pgrwl: Now with Time & Count-Based Retention!

Streaming PostgreSQL Backups with pgrwl: Now with Time & Count-Based Retention!

Comments
2 min read
Using SSL with a PostgreSQL DB Instance

Using SSL with a PostgreSQL DB Instance

Comments
3 min read
Handle Many to Many Relations in PostgreSQL using Prisma ORM

Handle Many to Many Relations in PostgreSQL using Prisma ORM

Comments 1
3 min read
Free PostgreSQL Hosting Now Available – Public Access Included

Free PostgreSQL Hosting Now Available – Public Access Included

Comments 1
2 min read
Build a Full-Stack App with Next.js 14, Prisma, and PostgreSQL

Build a Full-Stack App with Next.js 14, Prisma, and PostgreSQL

Comments
1 min read
PostgreSQL Practical Labs: Error Handling, Advanced Data Types & Kali Linux Setup

PostgreSQL Practical Labs: Error Handling, Advanced Data Types & Kali Linux Setup

Comments
3 min read
Como provisionei meu BD PostgreSQL no AWS RDS

Como provisionei meu BD PostgreSQL no AWS RDS

Comments
2 min read
Using NoSQL Features in PostgreSQL

Using NoSQL Features in PostgreSQL

6
Comments
3 min read
Safeguarding Your PostgreSQL Data: A Practical Guide to pg_dump and pg_restore

Safeguarding Your PostgreSQL Data: A Practical Guide to pg_dump and pg_restore

Comments
5 min read
What is an Embedding? And Why Should Devs Care?

What is an Embedding? And Why Should Devs Care?

Comments
3 min read
Setting Up PostgreSQL on macOS: A Fresh Start Guide

Setting Up PostgreSQL on macOS: A Fresh Start Guide

1
Comments
5 min read
I Replaced MongoDB with a Single Postgres Table

I Replaced MongoDB with a Single Postgres Table

64
Comments 21
7 min read
Introduction to PostgreSQL

Introduction to PostgreSQL

Comments
5 min read
Postgres TEXT vs VARCHAR: When to Use Which

Postgres TEXT vs VARCHAR: When to Use Which

Comments
2 min read
Build a Local RAG Using Ollama, PostgreSQL and BladePipe

Build a Local RAG Using Ollama, PostgreSQL and BladePipe

Comments 1
6 min read
Queries on JSON 👉🏻 compound indexes (Equality, Sort, Range)