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.
The 1.4 milliseconds that separate managed Postgres from a local one

The 1.4 milliseconds that separate managed Postgres from a local one

8
Comments 5
6 min read
My database is the referee: a fair exchange enforced by Supabase RLS

My database is the referee: a fair exchange enforced by Supabase RLS

Comments 5
6 min read
Drizzle ORM migrations in SvelteKit: schema-first vs code-first and what actually works in production

Drizzle ORM migrations in SvelteKit: schema-first vs code-first and what actually works in production

Comments
5 min read
Installing and setting up Postgres in Ubuntu

Installing and setting up Postgres in Ubuntu

Comments
3 min read
Redis Caching in NestJS: I Cut Database Calls by 60% in Production

Redis Caching in NestJS: I Cut Database Calls by 60% in Production

Comments
5 min read
pg_restore finished fine. One of my tables wasn't there.

pg_restore finished fine. One of my tables wasn't there.

Comments 1
4 min read
Your daily target was already behind before you woke up

Your daily target was already behind before you woke up

1
Comments
4 min read
How I built recall-first search on PostgreSQL

How I built recall-first search on PostgreSQL

2
Comments
16 min read
Row-Level Security for Multi-Tenant Postgres: USING vs WITH CHECK in Practice

Row-Level Security for Multi-Tenant Postgres: USING vs WITH CHECK in Practice

1
Comments
8 min read
Don't pick a partial index for speed: what I measured on a 10M-row Postgres queue table

Don't pick a partial index for speed: what I measured on a 10M-row Postgres queue table

Comments
9 min read
The Pagination Bug Hiding in a Geo-Search Cache

The Pagination Bug Hiding in a Geo-Search Cache

1
Comments
4 min read
A rate limiter changes when it leaves memory

A rate limiter changes when it leaves memory

Comments
4 min read
My analytics said 15 users. The database said 2.

My analytics said 15 users. The database said 2.

Comments 3
2 min read
Parte 2: Resolvendo o Desafio Técnico de Backend do PicPay

Parte 2: Resolvendo o Desafio Técnico de Backend do PicPay

1
Comments
3 min read
Every feature in our catalog had at least one user. It was the same user every time - our own scanner.

Every feature in our catalog had at least one user. It was the same user every time - our own scanner.

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