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…
Open Source
⚑ Report a ProblemLatest Open Source news from Tech News
All topics
AI
agents
ai
api
architecture
automation
aws
beginners
career
claude
database
devchallenge
devops
discuss
javascript
linux
llm
machinelearning
mcp
opensource
performance
productivity
programming
python
rust
security
showdev
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…
AI University: Turning 280 Competitors into a Content Strategy
AI University: Turning 280 Competitors into a Content Strategy I built a database of 280 competing AI tools inside my own app. Sounds counterintuitive…
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…
I indexed 17,341 polynomial fan curves in Postgres and matched a duty point in <100ms
Most B2B HVAC catalogs publish fan performance curves as scanned PDFs. Engineers do the interpolation by eye when they need to know "will this fan del…
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…
Stripe Projects Partnership: Provision PlanetScale Postgres and MySQL Databases From the Stripe CLI
By Elom Gomez Did you hear the news? PlanetScale is participating as a co-design and launch partner for Stripe Projects, a new developer preview from …
PostgreSQL Index Usage and Optimization
PostgreSQL Index Usage and Optimization Indexing is the single biggest lever in SQL performance, and it is also the category where most of the bad adv…
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…
pg_ilib: Compact Typed Binary Serialization for PostgreSQL
The problem PostgreSQL's bytea type is powerful for storing raw binary data, but it carries no type information. Once you store a value as bytes, you …
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…
Перенос данных из отчетов 1С в PostgreSQL в два клика
Все началось с того, что мне поставили задачу: «У менеджеров есть большой телевизор. Сделай так чтобы у них там крутились красивые цифе…
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…
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 …
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…
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" …
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…
PostgreSQL INT4RANGE: Enforce non-overlapping zones in SQL
Originally written by Omar Tarek , Software Developer at Stackdrop. Posted here with his permission. When you need to assign geographic zones to recor…