On: How Discord Indexes Billions of Messages Using Elasticsearch

[tannhaeuser]

I didn't consider Sphinx because it's using a RDBMS as store. For the same reason, I didn't check out sqlite-fts etc.

Maybe I should reconsider?

[frik → tannhaeuser]

Sphinx does NOT use an RDBMS as store. It just provide a convienient interface so you can query Sphinx like you would do a SQL database, just one of several APIs to interact with Sphinx. The data store is very similar to Lucene, a folder with several files.