Worked with MySQL indirectly before, I'll probably go back to it at some point to actually learn it better.

I dabbled into ChromaDB because it's another "Database on File" but has Symantic search function.... Wasn't as good as I'd liked. It defaults to a very weak embedding model and I couldn't work it with a custom one.

Maybe I'll try LanceDB next, it was the other suggestion by AI.