PostgreSQL as a Vector Database: pgvector notebook and overview page

[dmagda]

trafficstars

Summary

This pull request adds PostgreSQL to the category of vector databases capable of working with OpenAI. This first contribution includes the main overview page (README.md) and a Jupyter notebook for getting started with Postgres pgvector.

Motivation

PostgreSQL has a rich ecosystem of extensions and solutions that let us use it as a vector database. The PostgreSQL section on the OpenAI Cookbook will help developers to learn how to use Postgres with OpenAI for general-purpose AI apps.

---

For new content

When contributing new content, read through our contribution guidelines, and mark the following action items as completed:

• [x] I have added a new entry in registry.yaml (and, optionally, in authors.yaml) so that my content renders on the cookbook website.
• [x] I have conducted a self-review of my content based on the contribution guidelines:
  • [x] Relevance: This content is related to building with OpenAI technologies and is useful to others.
  • [x] Uniqueness: I have searched for related examples in the OpenAI Cookbook, and verified that my content offers new insights or unique information compared to existing documentation.
  • [x] Spelling and Grammar: I have checked for spelling or grammatical mistakes.
  • [x] Clarity: I have done a final read-through and verified that my submission is well-organized and easy to understand.
  • [x] Correctness: The information I include is correct and all of my code executes successfully.
  • [x] Completeness: I have explained everything fully, including all necessary references and citations.

We will rate each of these areas on a scale from 1 to 4, and will only accept contributions that score 3 or higher on all areas. Refer to our contribution guidelines for more details.

[dmagda]

@ted-at-openai could you please take a look at the pull request?

[dmagda]

Hey @shyamal-anadkat would you be able to review this new Postgres pgvector handbook? I saw that you had reviewed Tembo's handbook, and my contribution should not be that much different.

[github-actions[bot]]

This PR is stale because it has been open 60 days with no activity. Remove stale label or comment or this will be closed in 10 days.

[dmagda]

The issue is not stale. Hopefully maintainers will check the backlog.

[github-actions[bot]]

This PR is stale because it has been open 60 days with no activity. Remove stale label or comment or this will be closed in 10 days.

[dmagda]

The issue is not stale.

[github-actions[bot]]

This PR is stale because it has been open 60 days with no activity. Remove stale label or comment or this will be closed in 10 days.

[github-actions[bot]]

This PR was closed because it has been stalled for 10 days with no activity.