wp-serverless-search VS TNTSearch

Here is an existing plugin which is similar but i believe uses an xml export as the data source: https://github.com/getshifter/wp-serverless-search

This might be worth looking into: https://github.com/getshifter/wp-serverless-search

Static Wordpress hosting: while this approach is not free it has its own advantages. Some of the best static Wordpress hosts are Shifter, HardyPress, NorthStack

I'm thinking of converting my WordPress site to static version, anyone has used any of the tools like FLATsite, Shifter or HardyPress ? Which one is better and why?

Howdy, I’m attempting to implement the search plugin found here: https://github.com/getshifter/wp-serverless-search

FWIW an alternative might be to have your endpoint perform the full text search server-side with something like https://github.com/teamtnt/tntsearch. No external search service required.

While we're at it, would it be possible to store the index in the existing database instead of SQLite ? Wouldn't that allow for index syncing reliability (I hear there are file corruption problems ) ? And reducing the number of processes (no index queue) ?

As you saw from the tutorial, adding a full-text search to your project is pretty straightforward. We covered only the tip of the iceberg here. TNTSearch is a powerful engine that can do a lot of stuff - even classification if that's something you might need. For more info, you can check out the GitHub documentation.