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.
ALTER TABLE ... ADD COLUMN

ALTER TABLE ... ADD COLUMN

5
Comments
12 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
COMPARISON OPERATORS (POSTGRES)

COMPARISON OPERATORS (POSTGRES)

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

What is an Embedding? And Why Should Devs Care?

Comments
3 min read
Como Processar 60+ milhões de CNPJs com Python: Arquitetura e Decisões Técnicas

Como Processar 60+ milhões de CNPJs com Python: Arquitetura e Decisões Técnicas

5
Comments 1
4 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
RDS Blue/Green Deployments while using IaC

RDS Blue/Green Deployments while using IaC

6
Comments
10 min read
Handling Concurrency with Row Level Locking in PostgreSQL

Handling Concurrency with Row Level Locking in PostgreSQL

Comments 2
6 min read
Postgres on a Budget: 3 Free Solutions You Should Know

Postgres on a Budget: 3 Free Solutions You Should Know

1
Comments
2 min read
🧠 1. Understanding PostgreSQL Data Types

🧠 1. Understanding PostgreSQL Data Types

Comments
1 min read
🚀 The Ultimate PostgreSQL psql Cheat Sheet & Admin Guide

🚀 The Ultimate PostgreSQL psql Cheat Sheet & Admin Guide

1
Comments
2 min read
Postgres SQL FILTER: A Smarter CASE and CTE Alternative

Postgres SQL FILTER: A Smarter CASE and CTE Alternative

20
Comments 4
5 min read
DigitalOcean Fundamentals: PostgreSQL

DigitalOcean Fundamentals: PostgreSQL

Comments
7 min read
How to Use JSONB in PostgreSQL

How to Use JSONB in PostgreSQL

7
Comments 4
4 min read
Tech, Talk & Emotions – PostgreSQL Meetup Recap

Tech, Talk & Emotions – PostgreSQL Meetup Recap

1
Comments
2 min read
How OpenAI Scales Postgres to +1M Queries Per Second

How OpenAI Scales Postgres to +1M Queries Per Second

Comments
3 min read
Introduction to PostgreSQL

Introduction to PostgreSQL

Comments
5 min read
🚀 Tired of Slow Queries? Use CQRS with PostgreSQL to Split Reads & Writes

🚀 Tired of Slow Queries? Use CQRS with PostgreSQL to Split Reads & Writes

1
Comments
1 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
Design Your Database with dbdiagram.io (Beginner to Pro)

Design Your Database with dbdiagram.io (Beginner to Pro)

5
Comments
3 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
Features I Wish Postgres 🐘 Had but MySQL 🐬 Already Has 😼

Features I Wish Postgres 🐘 Had but MySQL 🐬 Already Has 😼

6
Comments
4 min read
PostgreSQL Branching: Xata vs. Neon vs. Supabase - Part 1

PostgreSQL Branching: Xata vs. Neon vs. Supabase - Part 1

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

Supadex: A Mobile Dashboard for Supabase Developers 🚀

1
Comments 1
2 min read
loading...
close