pigsty icon indicating copy to clipboard operation
pigsty copied to clipboard

request(new-extension): Please consider adding pg_steadytext extension to the ext repo

Open creatorrr opened this issue 6 months ago • 1 comments

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

creatorrr avatar Jul 09 '25 11:07 creatorrr

Looks interesting, while it has some python deps, which may be trick, but I'll look into it.

Vonng avatar Jul 10 '25 03:07 Vonng