Earlier quoted context omitted.
I'm actually working on this ( https://mailtemi.com/blog/storage-redesign/ ). After pushing Mailtemi on Android, I will continue working on full offline support.
That’s awesome, will check it out!
The app is ready for offline use, but I don't want to implement it without 'full text search.' I plan to use SQLite FTS5. My initial tests with search show that offline search is storage-expensive, which could be problematic for mobile devices. So, the edge cases have started to appear. But it's the most requested feature, and the most interesting/challenging to me :)