Vector Database Solution
A plugin called sqlite-vss provides multi-dimensional vector search on top of sqlite.
sqlite-vss was replaced with sqlite-vec
Importing and Exporting CSV Data
From sqlite cli:
-- export data
.mode csv
.headers on
.output output.csv
SELECT * FROM your_table;
.output stdout --turn output back to normal stdout
-- re-import data
.mode csv
.import path/to/your_file.csv your_table