I'm trying to do some R&D on SQLite because I'd like to use it for a person project, but I've run into the problem that every database manager I try that supports SQLite seems to suck. hard. As in, ...

PostgreSQL with the pgvector extension allows tables to be used as storage for vectors, each of which is saved as a row. It also allows any number of metadata columns to be added. In an enterprise ...