pgsty / pgsty/pigsty

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

Open
#617 1 comment 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Dominant language
Shell
Stars
5.7k
Forks
384
Avg merge
2h 36m
Merged PRs (30d)
2

Description

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

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start with the linked PostgreSQL extension documentation for pg_steadytext and inspect how this repository organizes its PostgreSQL extensions. Confirm the extension's integration requirements, then define completion as pg_steadytext being added to the ext repository with the documented functionality available.

Written by the indexing model from the issue text.

Assessment

Tech stack
postgresql
Domain
databases
Issue type
Feature
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.