I see the idea of sql lite, but a mysql / Postgres store a lot in memory so no disk access required (if not the data the indexes stay memory resident)

We have an old web based tool that uses Java and luncene indexed file system based database. It’s a pain to work with frankly.

https://lucene.apache.org/