SQL

PostgreSQL sits behind this site's CMS and visits tracker, and behind the two RAG systems I've built. In one of them, with the pgvector extension, it holds the embeddings too.

PostgreSQL behind this site

The CMS and the tracker, both Laravel apps, store their data on PostgreSQL in Docker.

pgvector in Local RAG Example

In a RAG the text of documents is turned into vectors and searched by similarity: pgvector adds exactly that kind of column and search to PostgreSQL. I use it in Local RAG Example, my open-source RAG in Go. The RAG I built at STCC also used PostgreSQL as its database: it's described on the Python page.