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.
How I Built a 93-Day Streak Engine in Postgres That Scales to 28K Users

How I Built a 93-Day Streak Engine in Postgres That Scales to 28K Users

1
Comments
6 min read
Branch Your Database Like You Branch Your Code

Branch Your Database Like You Branch Your Code

3
Comments
3 min read
PostgreSQL Performance Tuning for Python/FastAPI APIs: Indexes, Query Optimization & Connection Pooling

PostgreSQL Performance Tuning for Python/FastAPI APIs: Indexes, Query Optimization & Connection Pooling

Comments
4 min read
ASP.NET Core Identity with Supabase PostgreSQL | Login & Registration Tutorial (.NET 9)

ASP.NET Core Identity with Supabase PostgreSQL | Login & Registration Tutorial (.NET 9)

Comments
1 min read
Testing Password Reset Emails in PostgreSQL-Backed REST APIs

Testing Password Reset Emails in PostgreSQL-Backed REST APIs

Comments
5 min read
Building an Open-Source Vue 3 + Supabase Enterprise Admin Starter with AI SQL, Vehicle Management, and TMS

Building an Open-Source Vue 3 + Supabase Enterprise Admin Starter with AI SQL, Vehicle Management, and TMS

Comments
2 min read
Taming Open Food Facts: building a fast, searchable nutrition database

Taming Open Food Facts: building a fast, searchable nutrition database

6
Comments 1
2 min read
Tracking Tableau Viewership with PostgreSQL

Tracking Tableau Viewership with PostgreSQL

Comments
2 min read
The new customer who took down everyone: an ORM include that ate our CRM

Summer Bug Smash: Smash Stories 🐛🛹

The new customer who took down everyone: an ORM include that ate our CRM

1
Comments
4 min read
Typed ORM with automatic migrations: Fitz vs SQLAlchemy + Alembic + Pydantic

Typed ORM with automatic migrations: Fitz vs SQLAlchemy + Alembic + Pydantic

Comments
9 min read
ORM tipado con migraciones automĂĄticas: Fitz vs SQLAlchemy + Alembic + Pydantic

ORM tipado con migraciones automĂĄticas: Fitz vs SQLAlchemy + Alembic + Pydantic

Comments
9 min read
PostgreSQL Performance Tuning for High-Traffic React Applications

PostgreSQL Performance Tuning for High-Traffic React Applications

Comments
4 min read
Building a world-history map: PostGIS time+bbox search, a full-screen MapLibre UI, and Wikidata ETL lessons

Building a world-history map: PostGIS time+bbox search, a full-screen MapLibre UI, and Wikidata ETL lessons

Comments
8 min read
Eighty Percent Done Is Not a Real Number

Summer Bug Smash: Smash Stories Submission 🐛🛹

Eighty Percent Done Is Not a Real Number

27
Comments 21
10 min read
I just published Postgres MCP Server in Go!

I just published Postgres MCP Server in Go!

Comments
2 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.