PostgreSQL

Reliable database storing memory data with full-stack integration for user management.

Postgres was the second database we added, and honestly, it needs no introduction. This OSS RDBMS is massive, reliable, and just incredible to work with.

PGVector's native vector operations with PostgreSQL's ACID compliance works perfectly. We're storing millions of embeddings with sub-millisecond similarity search using cosine distance. The async connection pooling handles concurrent connections, while the vector indexing makes our query super fast. Having vector search, full-text search, and relational data in one database eliminates the complexity of managing multiple data stores.

Why use supabase when you can just use postgres?! Just sayin..