Adding Semantic Search to Your Postgres App with pgvector
pgvector is a Postgres extension that adds vector storage and similarity search to an existing database, so you can run semantic queries directly agai…
DevOps
⚑ Report a ProblemLatest DevOps news from Tech News
All topics
agents
ai
api
architecture
automation
aws
beginners
claude
cloud
database
devchallenge
devops
docker
googlecloud
javascript
kubernetes
llm
machinelearning
mcp
opensource
performance
productivity
programming
python
security
showdev
testing
tutorial
typescript
webdev
Bridging 533K Dubai Land Department transactions to 1,387 buildings — developer naming is the real problem
When I started building Ghost Workforce — a Dubai real estate intelligence dashboard — I assumed scraping the Dubai Land Department (DLD) was going to…
I Built an Open-Source Platform Foundation for Accounting-Centric Business Apps
The problem I kept running into Every serious line-of-business project I worked on eventually forced me to solve the same hard problems from scratch. …
Supabase Edge Functions with Deno: Production-Ready Design Patterns
Supabase Edge Functions with Deno: Production-Ready Design Patterns Supabase Edge Functions run on Deno. Similar to Node.js, but with subtle differenc…
274 AI Tools, One Database: Why I Treat Competitors as Curriculum
274 AI Tools, One Database: Why I Treat Competitors as Curriculum This project has a feature called "AI University" — a database of 274 AI tools and s…
War Story: Scaling PostgreSQL 17 to 100k IOPS for AI_ML Feature Stores with Read Replicas
In Q3 2024, our AI/ML feature store’s p99 read latency hit 2.8 seconds as training throughput spiked to 12k features/sec, with PostgreSQL 16 strugglin…
Migrating From a JSON Column to a Proper Schema in Postgres
Book: Database Playbook: Choosing the Right Store for Every System You Build My project: Hermes IDE | GitHub — an IDE for developers who ship with Cla…
Build an AI teammate to help with your Postgres
Think about those times on team calls when a simple question like “Can someone check the latest sales numbers?” puts the meeting to a pause while some…
The Heart of B3: Building the Matching Engine with RabbitMQ, Redis and Spring Boot
Hello everyone! Continuing the My Broker B3 series, we've reached one of the most anticipated components of the ecosystem: the B3 Matching Engine API …
Time-Series, Document, or Relational? The 5-Question Test Every New Project Needs
Book: Database Playbook My project: Hermes IDE | GitHub — an IDE for developers who ship with Claude Code and other AI coding tools Me: xgabriel.com |…
Persistent JWT Signing Keys with PostgreSQL
The previous article ended with this caveat: In production, replace createInMemoryKeyStore() with a persistent store backed by a database or secrets m…
Choosing Postgres, MongoDB, or DynamoDB: The 4 Questions That Actually Decide It
Book: Database Playbook My project: Hermes IDE | GitHub — an IDE for developers who ship with Claude Code and other AI coding tools Me: xgabriel.com |…
200-Line Outbox Pattern: ~90% Fewer Mystery Bugs
Book: Event-Driven Architecture Pocket Guide: Saga, CQRS, Outbox, and the Traps Nobody Warns You About My project: Hermes IDE | GitHub — an IDE for de…
Postgres With pgvector vs Pinecone: 1 Million Embeddings, One Honest Comparison
Book: Database Playbook: Choosing the Right Store for Every System You Build Also by me: RAG Pocket Guide: Retrieval, Chunking, and Reranking Patterns…
850x Faster PostgreSQL Writes With One Line of Python
Every Python developer loading data into PostgreSQL hits the same wall. executemany() with 1M rows? 16 minutes. df.to_sql() ? Same thing — it generate…
Why PostgreSQL EXPLAIN ANALYZE Can Mislead You — and What to Use Instead
EXPLAIN ANALYZE is the standard tool for understanding how PostgreSQL runs a query. It shows the chosen plan, estimated and actual row counts, and exe…
Anti-Join in MongoDB
SQL databases implement anti-joins—finding rows with no match—through NOT EXISTS. Although anti-join is not a distinct relational algebra operator, it…
Reacting to Database Changes in Real-Time: How I Built a CDC Tool
I built youjustneedpostgres.com to argue that most teams could use Postgres for almost everything. For queues, for search, for documents. The recommen…
Introducing Xata OSS: Postgres platform with branching, now Apache 2.0
Xata is a cloud-native Postgres platform with the following highlights: Fast branching using Copy-on-Write at the storage level. You can “copy” TB of …
Generating Realistic Seed Data That Respects Foreign Keys, in 20 Seconds
Someone asks for a demo. You need 10,000 users, 30,000 orders, a handful of products, and enough variety that the UI does not look fake. You have twen…
Postgres MCP in Go - Giving Claude Code a Live Line to Your Database
Introduction Copy-pasting SQL from a chat window into a DB client and back again is how most "AI + database" workflows actually feel. 🙃 It breaks flow…
Cloud SQL IAM auth on Cloud Run with Postgres.js (no connector package in your app)
If you're using Cloud SQL on Cloud Run in Node.js, most tutorials point you to @google-cloud/cloud-sql-connector . That package is fine. But if you're…
Enhanced Tagging in Postgres Query Insights
By Rafer Hazen As part of our Traffic Control launch , we made enhancements to the Insights query tagging feature for Postgres databases. Insights has…
I built a self-hosted PostgreSQL Control Plane that runs on single Docker container
The itch I was scratching Every time I spin up a new side project, I hit the same wall with Postgres: postgres:latest in Docker is fine until you want…
How I indexed 18,141 polynomial fan curves in Postgres and matched a duty point in 4 ms
If you work in building HVAC, you know the ritual. You need a fan that will push 5000 m³/h at 400 Pa. Your manufacturer rep emails you a 400 MB instal…
The 8 tables behind a real auth system (Postgres schema, explained column by column)
This is day 2 of the series. Yesterday I showed the architecture diagram. Today we are looking at the database that sits underneath it. Every table, e…
PostgreSQL Backup and Recovery: A Complete Guide
Your database has never failed. That's not because you're careful. It's because you haven't been running long enough. Hardware dies. Disk controllers …
PostgreSQL Performance Optimization: Why Connection Pooling Is Critical at Scale
If you’ve ever scaled an app and suddenly your database starts struggling even though your queries are optimized, you’re not alone. The issue often is…
PostgreSQL Read Replicas with Docker: A Step-by-Step Guide
As your application scales, your database becomes the first bottleneck. Every dashboard query, every report, every analytics request competes with the…
Database Subsetting for PostgreSQL: A Practical Guide (2026)
Every team that has tried to copy production data into a dev environment has hit the same wall: production is too big, full of PII, and growing. The f…