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.
pgvector for Beginners: Add Semantic Search to PostgreSQL
clinerds profile

pgvector for Beginners: Add Semantic Search to PostgreSQL

#database #postgres #pgvector #vectorsearch
Comments
3 min read
Read/Write Controversy
bhanupartap13 profile

Read/Write Controversy

#redis #postgres #awss3 #systemdesign
Comments
4 min read
Six predicates in this codebase are written twice, once in TypeScript and once in SQL
daniel_pertu profile

Six predicates in this codebase are written twice, once in TypeScript and once in SQL

#sql #postgres #typescript #testing
Comments
7 min read
Your location join is copying salaries across cities
nimbryxo-studio profile

Your location join is copying salaries across cities

#node #typescript #postgres #automation
Comments
6 min read
A whole second interview format cost us two columns, one CHECK constraint and a 312-byte migration
daniel_pertu profile

A whole second interview format cost us two columns, one CHECK constraint and a 312-byte migration

#postgres #database #typescript #webdev
Comments
4 min read
pgrecon, an Oracle to PostgreSQL assessment that never connects to your database
ejazarain profile

pgrecon, an Oracle to PostgreSQL assessment that never connects to your database

#postgres #oracle #database #opensource
Comments
3 min read
4,300 tests, written by an AI: how they were planned, run and enforced
rakno profile

4,300 tests, written by an AI: how they were planned, run and enforced

#ai #testing #typescript #postgres
Comments
3 min read
PostgreSQL's recovery_prefetch prefetches pages the WAL already holds
importstatic profile

PostgreSQL's recovery_prefetch prefetches pages the WAL already holds

#database #postgres #sql #backend
Comments
6 min read
Rotate a Database Password With Only Seconds of Downtime
julia_kafarska profile

Rotate a Database Password With Only Seconds of Downtime

#lightcloud #cloudplatform #tutorial #postgres
Comments
4 min read
Meilisearch is the easy part. The sync worker is where it hurts.
cramxd profile
Marc

Meilisearch is the easy part. The sync worker is where it hurts.

#postgres #meilisearch #search #docker
1
Comments 2
3 min read
Changing one number from 32 to 34 made a Postgres query 6,000 faster. Here's exactly why.
payyavula_balanagaraju_6d profile

Changing one number from 32 to 34 made a Postgres query 6,000 faster. Here's exactly why.

#postgres #backend #database
Comments
12 min read
Your Agent's ADD FOREIGN KEY Stalls Writes on Two Tables. NOT VALID, Then VALIDATE
gabrielanhaia profile

Your Agent's ADD FOREIGN KEY Stalls Writes on Two Tables. NOT VALID, Then VALIDATE

#postgres #database #sql #ai
1
Comments
7 min read
Cutting LLM Calls in Incident Triage: Sliding Windows, Log Reduction, and a pgvector Cache
axololtos_30 profile

Cutting LLM Calls in Incident Triage: Sliding Windows, Log Reduction, and a pgvector Cache

#java #kafka #postgres #ai
Comments
6 min read
Supabase Storage upload fails with "new row violates row-level security policy"? Here's the fix
ahmed_hassanyaseen_1b7ab profile

Supabase Storage upload fails with "new row violates row-level security policy"? Here's the fix

#supabase #postgres #webdev #security
Comments
3 min read
Konut projesinde ünite stok haritasını kodla kurmak: Durum makinesi, süreli opsiyon, eşzamanlı rezervasyon ve canlı güncelleme
korayyalcin profile

Konut projesinde ünite stok haritasını kodla kurmak: Durum makinesi, süreli opsiyon, eşzamanlı rezervasyon ve canlı güncelleme

#database #backend #postgres #proptech
Comments
10 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.