Just a theory: containerized backends gave developers much more freedom of choice to pick technologies that happen to work better with SQLite.
Go and Rust work great with SQLite because all the concurrency is mediated within a single application process.
During the PHP and Ruby years, SQLite did not work that well and still does not, because the different worker processes can't communicate and SQLite has an extremely poor-performing sleep loop around the write lock.
This gave it a low-performance reputation compared to MySQL and Postgres that it has struggled to shake off.
Go and Rust work great with SQLite because all the concurrency is mediated within a single application process.
During the PHP and Ruby years, SQLite did not work that well and still does not, because the different worker processes can't communicate and SQLite has an extremely poor-performing sleep loop around the write lock.
This gave it a low-performance reputation compared to MySQL and Postgres that it has struggled to shake off.