Building a highly-available search engine using SQLite

[thunderbong]

https://www.philipotoole.com/building-a-highly-available-search-engine-using-sqlite/

[lnkdinsuxs]

> I achieved indexing rates greater than 3,000 log lines per second, indexing 5 million logs in under 30 minutes

What was the size of the 5 million logs on disk?

> SELECT * FROM logs WHERE entry MATCH 'SuperSecretAgent'

If I wanted to sort the results in descending order of how many times 'SuperSecretAgent' occured in the record, how would I do it?

[otoolep]

rqlite creator here, happy to answer any questions.