60 stories tagged with #postgres, in publish-time order across the WeSearch catalog. Tag pages update as new stories ingest.
⌘ RSS feed for this tag → or search "Postgres"
Mike Stonebraker: Disagreeing with Google, Postgres and Future Problems [video]
Enjoy the videos and music you love, upload original content, and share it all with friends, family, and the world on YouTube.…
Rebuilding Postgres Metrics on Self-Hosted VictoriaMetrics with Zero Downtime
How we rebuilt Xata's PostgreSQL branch metrics on a self-hosted VictoriaMetrics stack in six weeks, with zero user-visible downtime.…
PostgreSQL Connection Pooling Explained: How It Works and Why It Matters
Opening a new database connection for every query is one of the most expensive things your backend...…
Handling Graphs with SQL/PGQ in PostgreSQL
Fuzzy Text Search in PostgreSQL: How Trigrams Make Computers "Almost Right"
A deep dive into one of the most clever tricks in database engineering - explained so simply, your...…
Azure HorizonDB: Enterprise-Ready Postgres, Engineered for the AI Era
Affan Dar, Vice President of Engineering, PostgreSQL at MicrosoftCharles Feddersen, Partner Director of Program Management, PostgreSQL at Microsoft Today at...…
PostgreSQL 20000 Error: Causes and Solutions Complete Guide
PostgreSQL Error 20000: case_not_found — What It Means and How to Fix It PostgreSQL error...…
Getting Started with Vector Databases Using Amazon Aurora PostgreSQL + pgvector
Hello! I'm Satoshi Kaneyasu, DevOps engineer at Serverworks. In this article, I'll introduce the...…
PostgreSQL CLI Setup
Great Stack to Doesn't Work Bonus: SQL vs NoSQL: Which One in 2026?
The honest decision framework, not another flame war. The SQL vs NoSQL debate has been running...…
Installing PostgreSQL on Arch Linux | Practical Setup Guide
Installing postgres on windows/mac is pretty simple, you just follow the steps on the installation...…
Three Ways to Set Up CDC from Postgres to ClickHouse
Postgres CDC into ClickHouse via Kafka + Debezium, MaterializedPostgreSQL, and ClickPipes — setup, schemas, monitoring SQL, and where each one breaks.…
Show HN: MigraDiff v1.3.0 – PostgreSQL schema diff with AI migration explanation
Install pip install --upgrade migradiff What's New AI-Powered Migration Explanation (--explain) MigraDiff can now explain any migration in plain English — what each change does, w…
PostgreSQL tool that you wish ware not deprecated
UUID v4 vs UUID v7 — Lequel choisir pour PostgreSQL en 2026 ?
Si vous utilisez PostgreSQL, vous avez probablement déjà dû choisir entre une clé primaire BIGSERIAL...…
Great Stack to Doesn't Work Bonus: 10 PostgreSQL Features You Didn't Know Existed
Between episodes, here's something lighter. Still useful. Still PostgreSQL. You've used...…
PostgreSQL 08003 오류 원인과 해결 방법 완벽 가이드
08003 connection does not exist 는? PostgreSQL 에러 코드 08003은 클라이언트가 이미 존재하지 않는 데이터베이스 연결을 통해...…
3 Files Every AI-Assisted Project Needs Before You Write a Line of Code
Most developers think of project setup as: install dependencies, configure TypeScript, set up...…
DuckDB 1.5.3 Iceberg updates, PostgreSQL TDE extension & AI index tuning
DuckDB 1.5.3 Iceberg updates, PostgreSQL TDE extension & AI index tuning ...…
Not All Open Source Is Equal: Choosing a PostgreSQL Operator for Kubernetes in 2026
Recent licensing and distribution changes (MinIO archived, Bitnami catalog reduced, Crunchy Data redistribution limits) reshape what "open source" means for Kubernetes Postgres ope…
Practical Docker 29.5.2 setup for a Java 25 / Spring Boot 4.0.6 / PostgreSQL backend project using a vide-coding approach
AI and data sovereignty in Postgres: An answer to the datacenter energy crisis
A billion AI agents walk into a power grid…
Database Index Selection: Why Basic Approaches Fall Short?
Introduction: The Unseen Costs of Indexes When we talk about database performance, indexes...…
Debo Data Studio – Visual ETL that compiles pipelines to a single SQL query
Contribute to Debo-et/Debo_data_studio development by creating an account on GitHub.…
1.4 Planner: Which Path to Take
By the time 1.3 ends, the rewriter has let the Query tree through. Views have been expanded, RLS...…
How to set up PostgreSQL permissions for AI coding tools (Cursor, Claude, Copilot)
Most developers I talk to connect Cursor or Claude directly to their databases using a full admin...…
PostgreSQL 02000 Error: Causes and Solutions Complete Guide
PostgreSQL Error 02000: No Data PostgreSQL SQLSTATE 02000 ("no data") occurs when a query...…
RSQL – High-Performance, Open Source PostgreSQL Client (Tauri v2, React, Rust)
A Tauri application for efficient and secure database management. - rust-dd/rsql…
HeidiSQL – Lightweight MariaDB, MySQL, SQL Server, PostgreSQL and SQLite Manager
A lightweight client for managing MariaDB, MySQL, SQL Server, PostgreSQL, SQLite, Interbase and Firebird, written in Delphi and Lazarus/FreePascal - HeidiSQL/HeidiSQL…
Why shouldn’t I just have Claude code connect to Postgres production db for every data analysis task?
Why Postgres Lacks Transparent Data Encryption
Oracle, SQL Server, and MySQL all ship Transparent Data Encryption. Postgres doesn't... yet the mailing list threads go back to 2016. Here's the full history: five implementations,…
The "Stateful App Storage Trap": We overprovisioned our self-managed Postgres/Kafka volumes for a huge ingestion job, and now we’re stuck paying for empty space.
TrailBase 0.28: Fast, open, single-executable Firebase alternative - now w/ Postgres
TrailBase 0.28: Fast, open, single-executable Firebase alternative - now w/ Postgres
Just Use Postgres for Durable Workflows
Explaining the concept of a Postgres-backed durable execution system like DBOS and comparing it to external workflow orchestration systems like Temporal.…
Shaun Thomas on "Why Postgres Lacks Transparent Data Encryption"
Built a tool to catch dangerous Postgres migrations before they hit production
Built a tool to catch dangerous Postgres migrations before they hit production
Cache Aware Scheduling Shows Nice Wins For AMD Zen 5 On PostgreSQL, Valkey, Network Performance
5 gotchas I hit moving LLM logs from Postgres to ClickHouse
The problem I am building Spanlens, an open-source LLM observability platform. Every call...…
How Polymarket Scaled Their Data Stack with Postgres + ClickHouse
Prediction markets move fast — and so does their data. As Polymarket grew to billions in monthly...…
Christophe Pettus: All Your GUCs in a Row: cluster_name
cluster_name looks like a cosmetic label for process listings, but on a standby it silently becomes the name your primary uses to verify synchronous……
5 PostgreSQL locking behaviors that trip people up
Introduction PostgreSQL uses MVCC (Multi-Version Concurrency Control) for concurrency...…
Shinya Kato: 5 PostgreSQL locking behaviors that trip people up
Introduction PostgreSQL uses MVCC (Multi-Version Concurrency Control) for concurrency...…
How I Built a Programmatic SEO Site with 16,750 Pages Using FastAPI and PostgreSQL
A deep dive into building BSBFinder.com — a free Australian BSB number lookup tool — from data...…
Open-sourcing a distributed bot platform built on Elixir, NATS, and PostgreSQL
Transaction Hooks: A General Primitive for Post-Commit Side Effects (Case Study: Queuert)
The previous two posts in this series walked through how Queuert keeps job state atomic with your...…
Andrei Lepikhov: EXPLAIN Prettier, or Post-Processing Query Plans in Postgres
EXPLAIN output carries more noise than most analyses need. EXPLAIN Prettier is an open-source PL/pgSQL script that strips it systematically, with stable output across Postgres vers…
Cornelia Biacsics: Contributions for week 20, 2026
Contributions for week 20, 2026 | PGConf.dev 2026 took place from May 19-22 2026, organized by Gwen Shapira Jonathan Katz Kaiting Chen Magnus ……
Bajándole todos los minutos posibles al CI del backend con mas de 1000 tests
Esta es la historia de muchas horas de trabajo en un hoyo continuo tratando de elegir optimizaciones...…
Polymorphic Associations in Postgres
or one more time on ORM-systems complexity…
A Go outbox library that runs inside your own DB transaction
tickr is a Postgres-backed outbox + worker pool for Go. You enqueue messages in the same transaction as your business write — no Kafka, no Debezium, no dual-write problem.…
Prisma-7 A Complete Beginners Guide (With Free Cloud Database!)
No prior database experience needed. This guide walks you through everything — what Prisma is, how...…
Show HN: Pgcraft – a lazygit-style TUI for Postgres
lazygit-style TUI for Postgres. Navigate schemas, run queries, view explain plans — without leaving the terminal. - lucasfrederico/pgcraft…
Making queries with PostgreSQL
Christophe Pettus: All Your GUCs in a Row: client_min_messages
`client_min_messages` controls what your session sees, not what the server logs—a confusion that spawns most of its trouble.…
How soon is now in PostgreSQL?
Event-Driven by Oskar Dudycz…
Prisma Query Logging and PostgreSQL: Where the ORM Ends and the Database Begins
Prisma query logs help you catch patterns, but if the problem lives inside PostgreSQL, the ORM won't show it to you. Here I break down when Prisma logging is enough and when you ne…
Prisma query logging y PostgreSQL: dónde termina el ORM y empieza la base
Los query logs de Prisma ayudan a detectar patrones, pero si el problema vive adentro de PostgreSQL, el ORM no va a mostrártelo. Acá separo cuándo alcanza con Prisma logging y cuán…