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.
A Postgres driver silently shifted my timestamps by 8 hours — and every test stayed green
libersand profile

A Postgres driver silently shifted my timestamps by 8 hours — and every test stayed green

#postgres #node #typescript #webdev
Comments
4 min read
Как мы держим мусор подальше от программных гео-страниц: белый список метро и чёрный список районов
numart profile

Как мы держим мусор подальше от программных гео-страниц: белый список метро и чёрный список районов

#seo #postgres #webdev #database
Comments
1 min read
Keeping junk out of programmatic geo pages: an allow list for metro, a block list for districts
numart profile

Keeping junk out of programmatic geo pages: an allow list for metro, a block list for districts

#seo #postgres #webdev #database
Comments
4 min read
What Flyway validate actually checks
eggletric profile

What Flyway validate actually checks

#postgres #database #flyway #devops
Comments
4 min read
I thought backing up Supabase was just pg_dump + rclone. It wasn't.
mkpdigital profile

I thought backing up Supabase was just pg_dump + rclone. It wasn't.

#supabase #postgres #devops #backup
Comments
3 min read
Export a Database Data Dictionary: HTML, Markdown and Excel from Your ERD
tbson87 profile

Export a Database Data Dictionary: HTML, Markdown and Excel from Your ERD

#database #documentation #sql #postgres
Comments
7 min read
What Actually Happens When You UPDATE a Row in PostgreSQL?
ujjwal_011 profile

What Actually Happens When You UPDATE a Row in PostgreSQL?

#postgres #programming #backend #database
Comments
4 min read
Dissecting Databases: CockroachDB Has Almost Every Postgres Feature - So Why Is It the Default Answer for Distributed SQL?
shadowsaurus profile

Dissecting Databases: CockroachDB Has Almost Every Postgres Feature - So Why Is It the Default Answer for Distributed SQL?

#cockroachdb #postgres #distributedsystems #database
1
Comments
8 min read
Sistema de assinaturas recorrentes
marciopolicarpo profile

Sistema de assinaturas recorrentes

#dotnet #docker #postgres #ai
2
Comments
4 min read
How to sync PostgreSQL to Meilisearch in real time — without dual-writes
bashiru98 profile

How to sync PostgreSQL to Meilisearch in real time — without dual-writes

#postgres #meilisearch #cdc #opensource
Comments
4 min read
ENAMETOOLONG: how one dirty database field crashed our static build
numart profile

ENAMETOOLONG: how one dirty database field crashed our static build

#postgres #webdev #seo #debugging
Comments
2 min read
ENAMETOOLONG: как одно грязное поле в базе уронило сборку статики
numart profile

ENAMETOOLONG: как одно грязное поле в базе уронило сборку статики

#postgres #webdev #seo #debugging
Comments
1 min read
Demystifying Vector Distance in PostgreSQL
rpi1337 profile

Demystifying Vector Distance in PostgreSQL

#algorithms #database #postgres #sql
1
Comments
2 min read
Read-Only by Design: Letting AI Explore Your Database Without the Risk of Writes
vivekdraxlr profile

Read-Only by Design: Letting AI Explore Your Database Without the Risk of Writes

#sql #database #ai #postgres
Comments 1
6 min read
Enforce, Don't Issue: Remote MCP with OAuth Without Becoming an Authorization Server
takashimatsuyama profile

Enforce, Don't Issue: Remote MCP with OAuth Without Becoming an Authorization Server

#kozou #mcp #oauth #postgres
Comments 4
10 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.