Personally, I can vouch for ParadeDB: https://www.paradedb.com/
It adds extra extensions to PostgreSQL which enable vector indexing, full text search and BM25. Works great and developers are helpful!
The major difference is that you must generate the embeddings by yourself, but I consider it an upside - to each their own :)
I'm curious why you consider an upside. Hypothetically speaking, wouldn't it be better if the embeddings could automatically be updated when you want them to be? Is the problem that it's not easy to automated based on the specific rules of when you want updates to happen?
- What if certain rows in a table don't need to be embedded?
- What if we use a single API key for embedding database rows and user queries and it hits a rate limit - how to prioritize user queries?
- What if some rows should be vectorized using a different model, depending on an external configuration?