Not totally clear to me why it’s preferable though: Postgres takes up as little as 50mb of memory as a server running on the host machine and offers way more features, with a large ecosystem.
Why jam SQLite in server side environments? Embedded and mobile devices I can see a case for