Added support for adding PGVector (Vector database for Postgres)

[AksAman]

Added support for adding PGVector (Vector database for Postgres)

PGVector PGVector Python

The integration test can be run using

poetry run pytest tests/integration_tests/vectorstores/test_pgvector.py

Make sure you setup a postgres database with pgvector extension installed PGVector Installation Steps before running the integration tests.

[AksAman]

@hwchase17 I had to add

pgvector = {version = "^0.1.6", optional = true}
psycopg2-binary = {version = "^2.9.5", optional = true}

as optional dependencies to pyproject.toml, which led to change in the poetry.lock on running

poetry lock --no-update

causing the conflict. Should i remove the dependencies and revert these two files to the master branch or how should i resolve them? I don't have much experience with poetry, so can you please guide here?

[hwchase17]

@hwchase17 I had to add

pgvector = {version = "^0.1.6", optional = true}
psycopg2-binary = {version = "^2.9.5", optional = true}

as optional dependencies to pyproject.toml, which led to change in the poetry.lock on running

poetry lock --no-update

causing the conflict. Should i remove the dependencies and revert these two files to the master branch or how should i resolve them? I don't have much experience with poetry, so can you please guide here?

i can work to resolve!

[hwchase17]

will take a look at imports tmrw if i ahve time!

[AksAman]

Thanks for the merge! Any timeline on when it will be available in the PyPI release?

[hwchase17]

Thanks for the merge! Any timeline on when it will be available in the PyPI release?

as soon as i finish drafting the tweets :)