v vector

[dineshbvadhia]

Hi. Not an Issue but a question about the statement:
cur.execute("create table test(v vector)")
Where or how is (v vector) defined so sqlite3 knows numpy arrays are being added?

[joosephook]

Hi,
The code responsible for defining vector is

sqlite3.register_adapter(Vector, adapter_func)
sqlite3.register_converter(f"{Vector.__name__}", converter_func)

See the Python documentation and another example here!

[dineshbvadhia]

Ah, ok. Thanks. Your code looks perfect for the job.