{"repo":"serpent7776/pg_sentence_transformer","free":true,"listed":false,"github":"https://github.com/serpent7776/pg_sentence_transformer","clone":"git clone https://github.com/serpent7776/pg_sentence_transformer.git","description":"Postgres extension running a huggingface sentence transformer model directly in a background worker","language":"C","stars":17,"topics":["ai","extension","postgresql","python","sentence-transformers"],"license":null,"category":"databases-storage","readme_excerpt":"pg sentence transformer Run a huggingface model right inside Postgres process, without the need for an external LLM service. Installation The usual make invocation will install the extension. This extension also requires pg sentence transformer python package to be installed in venv readable by postgres user. This extension needs to be added to shared preload libraries in your postgresql.conf : Configuration The following configuration options are recognised and should be set in postgresql.conf : Path to python virtual environment where pg sentence transformer python package and its dependencies were installed. Virtual environment needs to be created with virtualenv tool. Note that this path must be readable by postges user. If the path is empty, then virtual environment is not used and packages are loaded from system packages. The database name to which the worker should connect to. Schema name that contains the source table. The destination table with embeddings will also be created in this schema. Source table name with the data for which the embeddings should be computed. The embeddings will be stored in the newly created table. It's name will be the same as the source table, but will embeddings suffix. Column name in the source table containing the source text for which the embeddings should be computed. The integral ID column in the source table that uniquely identifies the row.","default_branch":null,"files":null,"tree":[],"storefront":"/r/serpent7776","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/serpent7776/pg_sentence_transformer/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}