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 No-Backend Backend: Neon Data API, RLS and 27 Attacks
devopsdaily profile

The No-Backend Backend: Neon Data API, RLS and 27 Attacks

#neon #postgres #security #rowlevelsecurity
10
Comments 1
16 min read
The Transactional Outbox Pattern: Dual-Write Consistency in Distributed Systems
amasen profile

The Transactional Outbox Pattern: Dual-Write Consistency in Distributed Systems

#sql #postgres #distributedsystems #architecture
Comments
3 min read
Competitive Intelligence Is a Freshness Problem, Not a Dashboard Problem
anakin_writers profile
Anakin

Competitive Intelligence Is a Freshness Problem, Not a Dashboard Problem

#dataengineering #webscraping #postgres #architecture
Comments
4 min read
Your RLS is on and the table is still readable
shipsafescan profile

Your RLS is on and the table is still readable

#supabase #security #postgres #webdev
Comments
5 min read
I built pistachio, a declarative schema tool for PostgreSQL
winebarrel profile

I built pistachio, a declarative schema tool for PostgreSQL

#showdev #postgres #database #opensource
Comments
3 min read
A week of green runs, and the pipeline was waiting for me
mk023 profile
Marco

A week of green runs, and the pipeline was waiting for me

#devops #automation #monitoring #postgres
1
Comments
3 min read
We let an AI write SQL against customer databases. Here is every guardrail, and why prompting is not one.
chattermate profile
Runix

We let an AI write SQL against customer databases. Here is every guardrail, and why prompting is not one.

#ai #security #postgres #python
1
Comments
7 min read
Building File4Base: The Modern, Open-Source Alternative to old file bases (Powered by Antigravity)
marioezquerro profile

Building File4Base: The Modern, Open-Source Alternative to old file bases (Powered by Antigravity)

#opensource #flutter #go #postgres
9
Comments
2 min read
A Straightforward Guide for MVCC in Postgres
eyochen profile
Eyo

A Straightforward Guide for MVCC in Postgres

#postgres #database #backend #learning
6
Comments
14 min read
From Zero to Hero on psql: My Weekend Adventure Installing PostgreSQL on WSL 🐧🐘
jontech profile

From Zero to Hero on psql: My Weekend Adventure Installing PostgreSQL on WSL 🐧🐘

#beginners #database #postgres #tutorial
Comments
6 min read
When Runtime Plans Enter the Prompt: A Structured Debate for SQL Review Bots
dataio_4921 profile

When Runtime Plans Enter the Prompt: A Structured Debate for SQL Review Bots

#postgres #sql #ai #security
Comments
8 min read
Ranking a Two-Dimensional Catalog With One SQL Expression
citationbuilder profile

Ranking a Two-Dimensional Catalog With One SQL Expression

#sql #postgres #webdev #database
Comments
5 min read
Ten Containers, One Developer: The Architecture of a Web GIS
srdjan_poppovic profile

Ten Containers, One Developer: The Architecture of a Web GIS

#architecture #gis #postgres #docker
Comments
5 min read
Two Webhooks, One Rank: Race-Safe Payments with Postgres Advisory Locks
pr0biex profile

Two Webhooks, One Rank: Race-Safe Payments with Postgres Advisory Locks

#postgres #supabase #nextjs #webdev
Comments 1
2 min read
Transactional Outbox Pattern: Prevent Lost Events in EDA
nainikmehta profile

Transactional Outbox Pattern: Prevent Lost Events in EDA

#reliability #outbox #cdc #postgres
2
Comments
4 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.