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 to catch a missing index in a test, when your test table has 20 rows.
ldavidsm profile

How to catch a missing index in a test, when your test table has 20 rows.

#python #postgres #testing #performance
Comments 6
6 min read
One View Per Layer: Four Sharp Edges I Found in My Own Code
srdjan_poppovic profile

One View Per Layer: Four Sharp Edges I Found in My Own Code

#postgres #gis #django #webdev
Comments
6 min read
A Small Fintech Challenge, and Why I Let Postgres Hold the Money
jeyem profile

A Small Fintech Challenge, and Why I Let Postgres Hold the Money

#postgres #go #fintech #concurrency
Comments
4 min read
Moving Oracle to PostgreSQL with a Single `INSERT` — No Oracle Client, No Python
sergey_rudenko_40963c1b7f profile

Moving Oracle to PostgreSQL with a Single `INSERT` — No Oracle Client, No Python

#dataengineering #duckdb #oracledatabase #postgres
Comments
11 min read
The 1.4 milliseconds that separate managed Postgres from a local one
remdore profile

The 1.4 milliseconds that separate managed Postgres from a local one

#postgres #database #devops #performance
8
Comments 5
6 min read
My database is the referee: a fair exchange enforced by Supabase RLS
peter_panzer_733381724c86 profile

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

#supabase #postgres #security #opensource
Comments 5
6 min read
Drizzle ORM migrations in SvelteKit: schema-first vs code-first and what actually works in production
verdantstack profile

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

#sveltekit #drizzle #postgres #tutorial
Comments
5 min read
Installing and setting up Postgres in Ubuntu
jantolentino profile

Installing and setting up Postgres in Ubuntu

#postgres #ubuntu #database
Comments
3 min read
Redis Caching in NestJS: I Cut Database Calls by 60% in Production
arihantjain916 profile

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

#nextjs #redis #backend #postgres
Comments
5 min read
pg_restore finished fine. One of my tables wasn't there.
superlede profile

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

#supabase #postgres #database #devops
Comments 1
4 min read
Your daily target was already behind before you woke up
umairhex profile
Umair

Your daily target was already behind before you woke up

#showdev #nextjs #postgres #typescript
1
Comments
4 min read
How I built recall-first search on PostgreSQL
puneet-chandna profile

How I built recall-first search on PostgreSQL

#nlp #vectordatabase #ai #postgres
2
Comments
16 min read
Row-Level Security for Multi-Tenant Postgres: USING vs WITH CHECK in Practice
udlxix profile

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

#postgres #security #database #tutorial
1
Comments
8 min read
Don't pick a partial index for speed: what I measured on a 10M-row Postgres queue table
muhammetsafak profile

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

#postgres #database #performance #backend
Comments
9 min read
The Pagination Bug Hiding in a Geo-Search Cache
rakno profile

The Pagination Bug Hiding in a Geo-Search Cache

#postgres #redis #typescript #webdev
1
Comments
4 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.