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.
Building a Temporary Message Sharing API with NestJS, PostgreSQL, Prisma & Redis
vedant48 profile

Building a Temporary Message Sharing API with NestJS, PostgreSQL, Prisma & Redis

#nestjs #redis #postgres #prisma
1
Comments 1
9 min read
Enforce, Don't Issue: Remote MCP with OAuth Without Becoming an Authorization Server
takashimatsuyama profile

Enforce, Don't Issue: Remote MCP with OAuth Without Becoming an Authorization Server

#kozou #mcp #oauth #postgres
Comments 4
10 min read
Event-driven architecture without the Kafka tax — lightweight patterns for small teams
letusai15 profile

Event-driven architecture without the Kafka tax — lightweight patterns for small teams

#eventdriven #architecture #postgres #typescript
1
Comments
5 min read
The webhook dedupe everyone copies has a hole in it
webhooker-eu profile

The webhook dedupe everyone copies has a hole in it

#webhooks #postgres #api #backend
1
Comments 1
6 min read
Run AI-Written Migrations on a Throwaway Database Before They Touch Yours
codepy_1473 profile

Run AI-Written Migrations on a Throwaway Database Before They Touch Yours

#postgres #ai #devops #database
Comments 1
4 min read
Rebuilding the Cerebras Knowledge Base: adding hybrid search
faridgnank02 profile

Rebuilding the Cerebras Knowledge Base: adding hybrid search

#rag #vectordatabase #postgres #ai
Comments
6 min read
Rebuilding the Cerebras Knowledge Base: the naive vector baseline
faridgnank02 profile

Rebuilding the Cerebras Knowledge Base: the naive vector baseline

#rag #vectordatabase #postgres #ai
Comments
5 min read
Incremental Backup Using pg_basebackup in PostgreSQL 18
vahidusefzadeh profile

Incremental Backup Using pg_basebackup in PostgreSQL 18

#postgres #database #linux #ai
1
Comments
7 min read
Postgres RLS multi-tenancy: two leaks that survive correct policies
wenceslaudev profile

Postgres RLS multi-tenancy: two leaks that survive correct policies

#postgres #database #security #webdev
Comments 2
8 min read
Five bugs AI wrote for me that never threw an error
igor_potapenko profile

Five bugs AI wrote for me that never threw an error

#ai #webdev #testing #postgres
Comments
6 min read
Deterministic checks for AI-written migrations
bolvrk profile

Deterministic checks for AI-written migrations

#aiworkflows #postgres #migrations
9
Comments
4 min read
Why ADD COLUMN NOT NULL fails on a full table, and the migration that does not
bolvrk profile

Why ADD COLUMN NOT NULL fails on a full table, and the migration that does not

#postgres #migrations #notnull
10
Comments
3 min read
Replace the Heuristic With a Boundary: Rebuilding a Leave Table as an Append-Only Ledger
dbartalos profile

Replace the Heuristic With a Boundary: Rebuilding a Leave Table as an Append-Only Ledger

#postgres #architecture #database #datamigration
Comments
9 min read
What is Information Schema in PostgreSQL?
hrrydgls profile

What is Information Schema in PostgreSQL?

#database #postgres
Comments
2 min read
CREATE INDEX CONCURRENTLY is not free, and half the time you do not need it
bolvrk profile

CREATE INDEX CONCURRENTLY is not free, and half the time you do not need it

#postgres #indexes #locks #data
7
Comments
4 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.