VECTOR DATABASES ARE THE WRONG ABSTRACTION. Here’s a better way: introducing pgai Vectorizer, a new open-source PostgreSQL tool that automatically creates and syncs embeddings with source data, just like a database index. ❌ Why vector databases fail Vector databases treat embeddings as independent data, di... See more

A nice thing about using Postgres for everything is that I don't need to set up a bunch of services just to be able to run my dev environment. I can run Postgres and get a database, message queue, job queue, cache, vector store, and more. Even simpler, I can use PGLite to run an in-memory in... See more

Reddit chose AWS Aurora Postgres as the database for the unified metadata. The diagram shows the high-level architecture. It was quite simple. The API service interfaces with the database to handle both reads and writes. To manage connection pooling, they used pgBouncer as the proxy.