On 11 Feb 2020, at 4:10am, Peng Yu <pengyu...@gmail.com> wrote: > It seems that sqlite3 databases are not searchable by Spotlight on Mac OS X. > Is there a way to make them searchable? Thanks.
A long time ago I wrote a SQLite indexer for … I think it was Sherlock back then. It went through all text fields (ignoring numbers and BLOB) and indexed them. It worked fine. But every time even a single field in a big SQLite database changed, my Mac slowed to a crawl, because the entire file got reindexed. That was how it worked. Hmm. I see Core Spotlight allows entity registering. You'd add hooks to SQLite so that every time a row was added, updated or deleted another routine was called, which told Spotlight about the new (or vanished) entity. Problem is, it would work only for apps which used your own library with the extra programming in. Without that, you're back to reindexing the entire database file any time anything in it changes. Whichever way you did it, it would slow down SQLite a lot. Sorry. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
