Supabase VectorStore Async

[gphorvath]

Checked

• I searched existing ideas and did not find a similar one
• I added a very descriptive title
• I've clearly described the feature request and motivation for it

Feature request

I noticed that the Python Supabase Vector Store implementation does not support async calls.

It seems like that the JS/TS Supabase Vector Store implementation does support async calls interestingly.

Motivation

I'm interested in using the Supabase Vector Store library with a FastAPI/Uvicorn application, so ideally these calls would not block the interpreter.

I'm investigating SQLAlchemy or psycopg as an alternative, but it would be super convenient if it was built right into this library.

Proposal (If applicable)

Add async / non-blocking calls to the Supabase Vector Store connector.

Might be able to use supabase-py-async as the client.

[averikitsch]

Async methods should be inherited from the super class.

[mkhludnev]

Async methods should be inherited from the super class.

This makes me really really wonder regarding asyncio. It seems like it's not really feasible. Every where I see methods copied to async def a_twins(): having await inside.
Is it possible to turn sync into async via inheritance?

[Kevin-McIsaac]

Async support added to version 2.2.0 of supabase-py client

[mkhludnev]

I did it for qdrant. #26795 Quite interested repeat it for supabase. I'll ping you when I have something.

[Kevin-McIsaac]

if you work on this I'd be very interested to hear about this and help test it,

[mkhludnev]

Hi, @Kevin-McIsaac
here's the first attempt https://github.com/mkhludnev/langchain/blob/54c5e0f256161b7e4aeeb51aee4856d3d818f210/libs/community/langchain_community/vectorstores/supabase.py#L558 (draft) it's a really really rough copy-paste.
Can you build langchain-comunity from that branch? or just copy the source into your codebase?
Which async method you particularly need for your integration/app ?