sqlite-vec is an extremely small, 'fast enough' vector search SQLite extension designed to run anywhere. It allows storing and querying of float, int8, and binary vectors using virtual tables, written in pure C with no dependencies. It supports storing non-vector data in metadata, auxiliary, or partition key columns. It is a Mozilla Builders project with additional sponsorship from companies like Fly.io, Turso, SQLite Cloud, and Shinkai.
- New Feature:
openai-to-sqlitetool now allows enriching data in a SQLite database using OpenAI's GPT3.5 model. - Sentiment Analysis Example:
- Update a
sentimentcolumn in amessagestable usingchatgpt()function.
