From docs:
PostgreSQL Extension (pg_steadytext)¶
The pg_steadytext PostgreSQL extension provides native SQL functions for deterministic text generation and embeddings by integrating with the SteadyText library. It brings the power of modern language models directly into your PostgreSQL database.
Overview¶
pg_steadytext extends PostgreSQL with:
- Deterministic Text Generation: SQL functions that generate consistent text output with custom seeds
- Vector Embeddings: Create 1024-dimensional embeddings compatible with pgvector
- Built-in Caching: PostgreSQL-based frecency cache for optimal performance
- Daemon Integration: Seamless integration with SteadyText's ZeroMQ daemon
- Custom Seed Support: Full control over deterministic generation with custom seeds
- Reliable Error Handling: Functions return NULL on errors instead of fallback text
- Security: Input validation, rate limiting, and safe error handling