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.
One long SELECT, one ALTER TABLE, and every query behind them

One long SELECT, one ALTER TABLE, and every query behind them

9
Comments 1
6 min read
A Shapefile Is Four Files, and the Important One Is Optional

A Shapefile Is Four Files, and the Important One Is Optional

Comments
5 min read
Enforce your free-plan limit in the database, not in the UI

Enforce your free-plan limit in the database, not in the UI

2
Comments 9
5 min read
Supabase stops auto-granting on Oct 30. Here is what breaks, and five traps the changelog does not mention.

Supabase stops auto-granting on Oct 30. Here is what breaks, and five traps the changelog does not mention.

Comments 2
7 min read
Django ORM & PostgreSQL Indexing: Benchmarking B-Tree, Composite, and GIN Indexes

Django ORM & PostgreSQL Indexing: Benchmarking B-Tree, Composite, and GIN Indexes

1
Comments
6 min read
Ota on dbmask: Proving a Synthetic PostgreSQL Masking Lane

Ota on dbmask: Proving a Synthetic PostgreSQL Masking Lane

Comments
2 min read
Multi-Tenant Database Isolation: Schema-per-Tenant vs. Row-Level Security in Postgres

Multi-Tenant Database Isolation: Schema-per-Tenant vs. Row-Level Security in Postgres

Comments 1
2 min read
Building an ETL Pipeline with Python, Docker, and PostgreSQL (And Debugging the Real Errors)

Building an ETL Pipeline with Python, Docker, and PostgreSQL (And Debugging the Real Errors)

1
Comments 1
5 min read
Building a RAG Retrieval Service: pgvector, Embedding Migrations, and Provenance Tracking

Building a RAG Retrieval Service: pgvector, Embedding Migrations, and Provenance Tracking

Comments
3 min read
Building a Notification Service: Cloud Tasks Delivery, Circuit Breakers, and Webhook Dispatch

Building a Notification Service: Cloud Tasks Delivery, Circuit Breakers, and Webhook Dispatch

Comments
5 min read
Money in a Parking App: Paise, Basis Points and a Ledger Postgres Won't Let You Edit

Money in a Parking App: Paise, Basis Points and a Ledger Postgres Won't Let You Edit

Comments 4
5 min read
I couldn't touch the database, so I built search next to it

I couldn't touch the database, so I built search next to it

1
Comments 2
9 min read
Multi-Tenancy in SaaS: Choosing Between Shared Tables, Schemas and Separate Databases

Multi-Tenancy in SaaS: Choosing Between Shared Tables, Schemas and Separate Databases

3
Comments 3
2 min read
Your dashboard is green and the number is wrong: the SQL checks I schedule next to every metric

Your dashboard is green and the number is wrong: the SQL checks I schedule next to every metric

1
Comments 3
4 min read
I put reminders, contacts and recipes in the same Postgres table. Here is the SQL, and what it cost.

I put reminders, contacts and recipes in the same Postgres table. Here is the SQL, and what it cost.

Comments
5 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.