Blog
8 blog available in the DeepSeek directory
Articles, tutorials, and deep dives on this AI platform — from getting-started guides to advanced techniques and real-world use cases.
postgresDesigning an Expiring-Points System on an RDBMS (with Benchmarks)
A battle-tested relational design for airline-mile-style points that expire per grant, support exact cancellation, and satisfy accounting audits — plus real PostgreSQL benchmarks and a scalability analysis.
Y
Yuki Matsukura
postgresAdding Semantic Search to Your Postgres App with pgvector
How to add vector similarity search to an existing Postgres app using pgvector — covering extension setup, embedding generation, cosine similarity queries, and HNSW indexing for performance.
R
Ryan Carter
postgresMy 14-Year Journey Away from ORMs - How I Built pGenie, the SQL-First Postgres Code Generator
Story about how I went from shipping a popular ORM in 2012… to throwing it all away… to realizing that the database itself should be the single source of truth.
N
Nikita Volkov
postgresTigerFS: A Filesystem Backed by PostgreSQL
TigerFS is a filesystem backed by PostgreSQL, built by the Timescale team. It mounts a database as a...
P
Polliog
postgresHow Do PostgreSQL Indices Work, Anyways?
You've created hundreds of indexes but do you know what's actually happening underneath? B-tree internals, page splits, MVCC bloat, and the diagnostic queries to see it all for yourself.
M
Matty Stratton
postgresI Deleted Pinecone, Redis, and 400 Lines of Python. My RAG Pipeline Still Works.
I had 5 services running for a RAG pipeline. Turns out I only needed PostgreSQL. Here's the whole thing in SQL.
A
Ahmet Zeybek
postgresBuilding Real-Time Log Streaming with PostgreSQL LISTEN/NOTIFY
I needed tail -f for a distributed system. The logs were in PostgreSQL. Users wanted to see them...
P
Polliog
postgresI Replaced Redis with PostgreSQL (And It's Faster)
I had a typical web app stack: PostgreSQL for persistent data Redis for caching, pub/sub, and...
P
Polliog