It'll keep popping up because it's not practical to have a fully fledged database system running if your data can be downloaded in a few seconds with a phone on a decent 5G network.
DHH and friends have recently been evangelizing it like there’s no tomorrow. Simon Willison has been bullish on SQLite for the last six years.
The Go community is pushing out tools like Litestream and LiteFS. Plus, people at fly.io, especially Ben Johnson, are heavily proselytizing SQLite. All of this adds up. Being a fantastic piece of software in its own right also helps.
