At my current company we deploy sqlite as the primary and only database for our server. Our use case is a little less impressive than your usual webscale startu

At my current company we deploy sqlite as the primary and only database for our server. Our use case is a little less impressive than your usual webscale startups though. Our product is a self-hosted IoT & hub unit solution, so we have no requirements to work with thousands of users doing who knows what. For our use case, sqlite is perfect. We don’t need to work with millions of rows, don’t need to stress the relatively low-power server units with another long lived network process, have no requirements of authentication since the user owns all the data, and can easily get insights into the database both during development and during troubleshooting at customer locations. I’d sooner leave the project than move to anything else.