I wrote https://github.com/jkitchin/scimax/blob/master/org-db.el to use sqlite for this. It does not do full text search, I found that too slow with my files and sqlite.
you might see https://github.com/emacs-helm/helm-recoll. I have some blog posts with similar ideas: https://kitchingroup.cheme.cmu.edu/blog/2017/01/03/Find-stuff-in-org-mode-anywhere/ you might find interesting. Nathan Neff <nathan.n...@gmail.com> writes: > Hello all, > > I'm considering "indexing" my org-mode files and haven't done any research > into > this. I'm sure there's 100 different ways to do this but wanted to ask the > list if anyone > is indexing their org-mode files and using a search tool like Solr, Elastic > or smaller indexing engines to search their org-files. > > Emacs integration obviously would be a plus. > > Thanks for any feedback, > --Nate -- Professor John Kitchin Doherty Hall A207F Department of Chemical Engineering Carnegie Mellon University Pittsburgh, PA 15213 412-268-7803 @johnkitchin http://kitchingroup.cheme.cmu.edu