[FEATURE REQUEST] Expand to other vector stores beyond Pinecone

[iuliaturc]

Is your feature request related to a problem? Please describe.
Solely supporting Pinecone is reportedly a deal breaker for some users, see for instance this comment.

Describe the solution you'd like
We should expand to other providers, at least top 5 supported by LangChain (Weaviate, Milvus, FAISS, Chroma, Qdrant). We should also allow mixing local LLMs with remote vector stores (currently, local LLMs only go with local Marqo vector store).

[aazam-gh]

I would like to work on this :)

[LuciAkirami]

Can I work on this @iuliaturc ? Hey @aazam-gh maybe we each can take a separate vector database and integrate them

[iuliaturc]

Apologies for the late response, I need to adjust my notifications :)

I'll assign this to @aazam-gh on a first-come-first-serve basis. Splitting the work based on vector stores is not a bad idea, but it might be prone to conflicts.

@LuciAkirami would you like to take #47 instead? I marked it as "difficulty 2" but really I think it's "difficulty 1" but more fun :D