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.
3 Supabase security incidents, one shared root cause: SECURITY DEFINER inherits EXECUTE TO PUBLIC

3 Supabase security incidents, one shared root cause: SECURITY DEFINER inherits EXECUTE TO PUBLIC

Comments
6 min read
Node.js Email Verification Tests with PostgreSQL

Node.js Email Verification Tests with PostgreSQL

Comments
4 min read
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
PostgreSQL 19 REPACK: Choosing the Right FILLFACTOR

PostgreSQL 19 REPACK: Choosing the Right FILLFACTOR

1
Comments 1
10 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
Following ROWIDs Through an Oracle Unique Index Update

Following ROWIDs Through an Oracle Unique Index Update

1
Comments
13 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
👋 Sign in for the ability to sort posts by relevant, latest, or top.