Proposal: Replace FTS with Semantic Search #4
Description
Instead of having 3 copies of the entire database: plain bookmarks table, FTS bookmarks, and vector bookmarks. It might be reasonable to completely replace the FTS bookmarks with the vector database as they both fulfill a similar purpose.
Risks & Mitigations
Potentially this could be a performance limitation for mark nodes that are not able to run an Ollama API or have access to one. Likewise for resource constrained nodes this kind of database would be out of the question. A potential mitigation would be the ability to pick the behavior of the table on the local mark node, either fts or vector. Because the synced data is only for the plain bookmark table anyway it doesn't really matter what the text search table process is.