SQLite via libsql is my go to for lightweight stuff.

Has vector embedding columns out of the box.