Introduction
Cake includes connectors for PostgreSQL data. PostgreSQL, commonly known as Postgres, is an open-source, enterprise-grade object-relational database system that underpins many core services—providing reliable, ACID-compliant data storage with powerful query capabilities and extensibility. Postgres balances performance and consistency with a broad feature set, making it an ideal choice for transactional workloads, metadata storage, feature logging, configuration management, and real-time analytics. Its rich ecosystem of extensions—including pgvector, PostGIS, and timescaledb—further enhances its utility in machine learning, geospatial data, and hybrid search applications.
Use Cases
PostgreSQL is used for:
Core service backends: Supporting APIs and services that require strong consistency, transactional updates, and schema enforcement.
Metadata stores: Logging model training runs, pipeline configs, evaluation artifacts, and prompt templates for ML workflows.
RAG and hybrid search: Storing embeddings using pgvector and enabling hybrid retrieval using SQL + vector similarity queries.
Experimentation and observability: Logging experiment variants, treatment arms, and event-level metrics for analytics and debugging.