Postgres Page 5 - DEV Community

Skip to content

DEV Community

👋 Sign in for the ability to sort posts by relevant, latest, or top.

Oct 23

Our daily cleanup job refreshes before it deletes, and that order is the only reason the 30 day rule holds

#postgres #node #nextjs #database

7 min read

Clément

Oct 23

Following foreign keys in DBeaver, pgAdmin or IntelliJ: one row at a time

#postgres #sql #database #tooling

2 min read

Valipireddy Kowshik

Oct 23

Your Index Isn't Being Used: A Senior Engineer's Guide to Database Indexing

#database #postgres #performance #backend

4 min read

Max S.

Oct 23

pgvector is enough. Here are the two bugs you'll ship anyway.

#postgres #ai #database #pgvector

5 min read

Oct 23

gcloud ADC Expires After ~44h: Reauthentication failed Fix

#database #postgres #devops #webdev

4 min read

Tomo

Oct 23

Enforce SSL on Supabase, Then Measure the Restart: A Status Page for Encryption and Downtime

#supabase #postgres #security #tutorial

9 min read

Chris Rodriguez

Oct 23

Serializable vs SELECT FOR UPDATE vs advisory locks — pick the boundary, not the loudest tool

#architecture #backend #database #postgres

3 min read

Oct 23

Two Postgres error codes are the only ones we retry, and the retry sits underneath a React cache()

#nextjs #postgres #react #webdev

6 min read

Oct 23

Twelve SELECTs for the list and six filtered counts for the page, and the only shared code is three SQL fragments

#postgres #typescript #nextjs #sql

7 min read

Oct 23

Analytics for 10 social networks: polling post stats by age, and why NULL isn't zero

#showdev #go #postgres #webdev

3 min read

Oct 23

The admin side of scheduling: booking states, a day-grouped calendar and honest no-show rates

#showdev #webdev #go #postgres

3 min read

Oct 23

pg_duckdb quietly ignored force_execution on my numeric column

#postgres #duckdb #azure #numeric

3 min read

Tomo

Oct 23

Multi-Tenant Data Isolation with Supabase RLS, Tested Through Real Logins in a Small Invoice Portal

#supabase #postgres #security #tutorial

8 min read

Tomo

Oct 23

Semantic Search in Postgres with Supabase Edge Functions: Auto-Embeddings and a Small App

#supabase #postgres #ai #tutorial

9 min read

subashthiruppathy

Oct 22

Why OFFSET Pagination Is Killing Your PostgreSQL Queries (And How to Implement Keyset Pagination in Node.js)

#node #postgres #sql #performance

11 min read

👋 Sign in for the ability to sort posts by relevant, latest, or top.