> [sqlite-vec] works via virtual tables, which means vectors must live in separate tables and queries become more complex.
Not really, you can just call the distance function directly and your vector blob can be in any regular field in any regular table, like what I do. Works great.
Not really, you can just call the distance function directly and your vector blob can be in any regular field in any regular table, like what I do. Works great.
More info: https://github.com/asg017/sqlite-vec/issues/196