feat: Implement python binding

[gaocegege]

Maybe like this: https://github.com/pgvector/pgvector-python

[AuruTus]

hi master @gaocegege , I'm interested in this, but can you provide more details? I have some thoughts but am still a bit confused.

[gaocegege]

/cc @VoVAllen

[VoVAllen]

@AuruTus Hi, Can you join our discord so that we can discuss this in detail?

[AuruTus]

@VoVAllen hi master, sorry for the late reply 😅. A bit busy with new semester enrolment. I'm alr in the discord channel, but I didn't found your name to at. Could you at me later when you are free?

[BeautyyuYanli]

I'm currently working on this and the following is considered to be implemented. The list may update frequently.

Low-level python binding is to add support of vector-related Python structures for the Python postgres libraries.

---

From the view of libraries:

• Support SQLAlchemy (ref: https://github.com/pgvector/pgvector-python#sqlalchemy)
• Support Psycopg 3 (ref: https://github.com/pgvector/pgvector-python#psycopg-3)
• Support Psycopg 2 (ref: https://github.com/pgvector/pgvector-python#psycopg-2)
• Support SQLModel (ref: https://github.com/pgvector/pgvector-python#sqlmodel)
• Support asyncpg (ref: https://github.com/pgvector/pgvector-python#asyncpg)
• Support Peewee (ref: https://github.com/pgvector/pgvector-python#peewee)

---

From the view of Python structures:

• Read/Write 1-d np.array
  • Considering Binary vectors and Index #86 , elements of vector may be bool in the future

---

Other

• Use binary representation to reduce the cost of serialize/deserialze (ref: vector_recv, vector_send)
  • Support the interface of pgrx External binary representation support (SEND/RECEIVE for custom types) pgcentralfoundation/pgrx#887