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)

Queries on JSON 👉🏻 compound indexes (Equality, Sort, Range)

1
Comments
8 min read
Building a Secure API with Quarkus, PostgreSQL, Kong, and OAuth2

Building a Secure API with Quarkus, PostgreSQL, Kong, and OAuth2

Comments 1
1 min read
Supadex: A Mobile Dashboard for Supabase Developers 🚀

Supadex: A Mobile Dashboard for Supabase Developers 🚀

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

How PostgreSQL logical decoding and plugins work

Comments
6 min read
Setup SSL/TLS for PostgreSQL in Docker

Setup SSL/TLS for PostgreSQL in Docker

11
Comments 3
7 min read
How to use Postgresql psql shell command line

How to use Postgresql psql shell command line

Comments
3 min read
loading...