PostgresML integrates[🤗 Hugging Face Transformers](https://huggingface.co/transformers) to bring state-of-the-art models into the data layer. There are tens of thousands of pre-trained models with pipelines to turn raw inputs into useful results. Manystate of the art deep learning architectures have been published and made available for download. You will want to browse all the[models](https://huggingface.co/models) available to find the perfect solution for your[dataset](https://huggingface.co/dataset) and[task](https://huggingface.co/tasks). The pgml extension provides a few APIs for different use cases:

PostgresML integrates[🤗 Hugging Face Transformers](https://huggingface.co/transformers) to bring state-of-the-art models into the data layer. There are tens of thousands of pre-trained models with pipelines to turn raw inputs into useful results. ManyLLMs have been published and made available for download. You will want to browse all the[models](https://huggingface.co/models) available to find the perfect solution for your[dataset](https://huggingface.co/dataset) and[task](https://huggingface.co/tasks). The pgml extension provides a few APIs for different use cases:

*[pgml.embed.md](pgml.embed.md"mention") returns vector embeddings for nearest neighbor searches and other vector database use cases

*[pgml.generate.md](pgml.generate.md"mention") returns streaming text responses for chatbots

*[pgml.transform](pgml.transform/"mention") allows you to perform dozens of natural language processing (NLP) tasks with thousands of models, like sentiment analysis, question and answering, translation, summarization and text generation

*[pgml.tune.md](pgml.tune.md"mention")fine tunes an open source model on your own data

*[pgml.tune.md](pgml.tune.md"mention")fine tunes an open source model on your own data

layout:

title:

visible:true

description:

visible:true

tableOfContents:

visible:true

outline:

visible:true

pagination:

visible:true

PostgresML integrates[🤗 Hugging Face Transformers](https://huggingface.co/transformers) to bring state-of-the-art models into the data layer. There are tens of thousands of pre-trained models with pipelines to turn raw inputs into useful results. Many state of the art deep learning architectures have been published and made available for download. You will want to browse all the[models](https://huggingface.co/models) available to find the perfect solution for your[dataset](https://huggingface.co/dataset) and[task](https://huggingface.co/tasks).

PostgresML is written in Rust, so you'll need to install the latest compiler from[rust-lang.org](https://rust-lang.org). Additionally, we use the Rust PostgreSQL extension framework`pgrx`, which requires some initialization steps:

cargo install cargo-pgrx --version 0.11.2&& \

cargo install cargo-pgrx --version 0.9.8&& \

cargo pgrx init

cd pgml-extension&& \

cargo install cargo-pgrx --version 0.11.2&& \

cargo install cargo-pgrx --version 0.9.8&& \

cargo pgrx init

To install`pgrx`, simply run:

Before using`pgrx`, it needs to be initialized against the installed version of PostgreSQL. In this example, we'll be using the Ubuntu 22.04 default PostgreSQL 14 installation: