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.
credits_remaining -= 1 is a race condition
indierob_ profile

credits_remaining -= 1 is a race condition

#postgres #python #saas #concurrency
Comments 2
5 min read
Your AI will fail. Your billing system needs to know that.
cmartinezv profile

Your AI will fail. Your billing system needs to know that.

#ai #architecture #saas #postgres
Comments
5 min read
Why Adding an Index Won't Fix Your Slow COUNT(*) in PostgreSQL
bodanthebackend profile

Why Adding an Index Won't Fix Your Slow COUNT(*) in PostgreSQL

#postgres #sql #database #performance
1
Comments 1
5 min read
Moving a Live SaaS from Firebase to Supabase: 283 Functions, 139 Tables, Zero Password Resets
joshmsn profile
Joshua

Moving a Live SaaS from Firebase to Supabase: 283 Functions, 139 Tables, Zero Password Resets

#supabase #firebase #postgres #saas
Comments 1
5 min read
From GraphQL types to a PostgreSQL API with Simfinity.js
pailletjuanpablo profile

From GraphQL types to a PostgreSQL API with Simfinity.js

#graphql #node #postgres #opensource
2
Comments
3 min read
pglite vs Tinbase: different tools for different jobs
lucas_martin_8cb158b9a81b profile

pglite vs Tinbase: different tools for different jobs

#postgres #supabase #database #webdev
Comments
4 min read
Cron Worker Retry Failure Capture Explained — Durable Background Evidence for SaaS
jerichorhodes5847 profile

Cron Worker Retry Failure Capture Explained — Durable Background Evidence for SaaS

#observability #postgres #backgroundjobs
Comments
6 min read
How I stopped double bookings with one Postgres constraint (no locks, no race conditions)
damian_zimiski profile

How I stopped double bookings with one Postgres constraint (no locks, no race conditions)

#postgres #supabase #nextjs #webdev
Comments 2
3 min read
Hybrid Search in Postgres with pgvector: Field Notes on HNSW, tsvector, and Why Pure Vector Search Missed Exact Matches
ahmed_mahmoud360 profile

Hybrid Search in Postgres with pgvector: Field Notes on HNSW, tsvector, and Why Pure Vector Search Missed Exact Matches

#postgres #ai #database #webdev
1
Comments
7 min read
I built a free database client with a modern UI for Postgres, MySQL, MariaDB and SQLite
janvorisek profile

I built a free database client with a modern UI for Postgres, MySQL, MariaDB and SQLite

#database #electron #vue #postgres
1
Comments
2 min read
When Did This Transaction Happen? PostgreSQL Snapshots, LSNs, Oracle SCNs, and More
franckpachot profile

When Did This Transaction Happen? PostgreSQL Snapshots, LSNs, Oracle SCNs, and More

#postgres #oracle #database #transactions
1
Comments
33 min read
PostgreSQL Graph Queries with MATCH: 3 Practical Traversal Patterns
ineron profile
Eugene

PostgreSQL Graph Queries with MATCH: 3 Practical Traversal Patterns

#postgres #sql #backend #ai
Comments
2 min read
Your UUID Primary Keys Are Quietly Taxing Every Insert
jatinjainsaraf profile

Your UUID Primary Keys Are Quietly Taxing Every Insert

#postgres #database #performance #indexing
Comments
9 min read
Amazon Aurora's analytics is gated DuckDB: comparison with open-source pg_duckdb
franckpachot profile

Amazon Aurora's analytics is gated DuckDB: comparison with open-source pg_duckdb

#postgres #duckdb #aws #azure
Comments
6 min read
Why a 40-Year-Old Database Is Still Winning in the AI Era
akulkarni01 profile

Why a 40-Year-Old Database Is Still Winning in the AI Era

#postgres #ai #database #dev
Comments
4 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.