Search posts, papers, and topics
Step‑by‑step recipe to run OpenBao (Vault fork) on Kubernetes using CloudNativePG as a password‑less, TLS‑authenticated PostgreSQL storage backend. Shows how to spin up a Kind cluster with the cnpg‑playground, deploy a 3‑node CNPG cluster with synchronous quorum replication, configure DatabaseRole‑based client certificates, set up pg_hba rules, and initialize OpenBao’s schema via a one‑off Job.
This article details how to diagnose PostgreSQL index bloat, write amplification, and buffer cache inefficiency using SQL tools like pgstattuple and pg_buffercache. It provides a reusable SQL toolbox and a Docker environment to identify and understand performance bottlenecks caused by MVCC-related index fragmentation.
This tutorial demonstrates building an event-driven lead scoring pipeline using Node.js and PostgreSQL. It focuses on robust design patterns like idempotency, secure webhook processing, and transactional consistency with a transactional outbox.
Google Cloud adds native BM25 ranking to AlloyDB and Cloud SQL (PostgreSQL 17+) via the open‑source pg_textsearch extension, letting you run keyword‑based full‑text search inside the database. This removes the need for a separate search backend and, on AlloyDB, speeds up vector queries up to 10×.
This tutorial demonstrates how to set up a PHP/Laravel/PostgreSQL development environment using Docker and Docker Compose. It covers creating a Dockerfile for the PHP application and defining services for NGINX, the PHP app, and PostgreSQL in a docker-compose.yml file.
This tutorial demonstrates how to set up a Node.js application with a PostgreSQL database using Docker Compose for local development. It covers creating a Dockerfile for the Node.js app and defining both services in a docker-compose.yml file, including volume mounts and environment variables.
