How insert embedding data use sqlalchemy session.execute about pgvector-python

[ankane]

Hi @mwcodefun, check out the readme for how to insert vectors with SQLAlchemy. You can also use:

session.execute(insert(Item).values(id=1, embedding=np.array([1, 2, 3])))
# or
session.execute(insert(Item), [{'id': 1, 'embedding': np.array([1, 2, 3])}])
# or
session.execute(text('INSERT INTO mytable (id, embedding) VALUES (:id, :embedding)'), {'id': 1, 'embedding': np.array([1, 2, 3])})

• https://docs.sqlalchemy.org/en/20/tutorial/data_insert.html#tutorial-core-insert
• https://docs.sqlalchemy.org/en/20/orm/queryguide/dml.html#orm-queryguide-bulk-insert