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…
Architecture
⚑ Report a ProblemLatest Architecture news from Tech News
All topics
agents
ai
api
architecture
automation
aws
backend
beginners
career
claude
cloud
database
devchallenge
devops
javascript
llm
machinelearning
news
opensource
performance
productivity
programming
python
security
showdev
softwareengineering
systemdesign
tutorial
typescript
webdev
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…
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 |…
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…
Advanced PostgreSQL: JSONB, partial indexes and partitioning
A trades table with 50 million rows. The query "which active trades for this user this month" takes 4 seconds. After applying the four techniques in t…
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 …
Why Application-Layer Audit Trails Fail (and How PostgreSQL Triggers Fix It)
Most fintech teams build their audit trails in the application layer. An ORM plugin here. A middleware hook there. A background job that "eventually" …
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…
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…
Обзор доклада PGBootCamp 2026 о технологии разделения Compute и Storage
В статье - обзор доклада Алексея Копытова ( автора sysbench ) на конференции PG BootCamp, прошедшей 19 марта 2026 года. Доклад заинтересовал меня тем,…
Managing Academic Data: A Practical Application of SQL in PostgreSQL
Introduction Databases are essential for storing and managing data in modern applications. Many organizations turn to PostgreSQL, a powerful, open-sou…
PostgreSQL Write Performance: What the Benchmarks Won't Tell You
I've spent years building financial systems on PostgreSQL. Payment processing, account management, transaction engines. The kind of systems where ever…
SQL-First PostgreSQL Migrations Without the Magic
If you work with PostgreSQL long enough, you start noticing a pattern: migration tools often become more complicated than the schema changes they are …
PostgreSQL Connection Pooling: PgBouncer, Supavisor & Built-In
PostgreSQL Connection Pooling: PgBouncer, Supavisor & Built-In Every PostgreSQL connection creates a new OS process. Each one allocates roughly 5-…