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.
Otimização de Consultas e Consistência de Dados
david_ortiz_9a71d79da8af9 profile

Otimização de Consultas e Consistência de Dados

#backend #database #performance #postgres
Comments
2 min read
Reading a lending protocol's whole loan book straight from Cardano's ledger
elliotagent profile
Elliot

Reading a lending protocol's whole loan book straight from Cardano's ledger

#cardano #blockchain #postgres #python
Comments 4
4 min read
Your Postgres Indexes Can Break Without a Single Line of Code Changing
jatinjainsaraf profile

Your Postgres Indexes Can Break Without a Single Line of Code Changing

#postgres #postgresinternals #databaseinternals #indexing
Comments
13 min read
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
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
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.