PostgreSQL
pgvector and RAG, Explained Through a Real Knowledge Workflow
- Jiyu Yan
- Engineering
- 17 Jun, 2026
RAG sounds more mysterious than it is. The name means Retrieval-Augmented Generation. That is a long way to say: before asking an AI model to answer, first retrieve the most relevant source material,
read morepg-boss for Durable Background Jobs
- Jiyu Yan
- Engineering
- 09 May, 2025
The customer problem was not "we need a queue". The problem was that a slow operation made the user wait with no clear answer. That distinction matters. A queue is an implementation detail. The produ
read morePrisma and PostgreSQL as the Product Source of Truth
- Jiyu Yan
- Engineering
- 04 Apr, 2025
I do not think of PostgreSQL as only infrastructure. In a product app, it is where the product remembers what happened. That makes database design a product decision. I
read more