I use sqlite with litestream through Pocketbase in production for around 2 years now on a site with 12,000 / month traffic. Works flawlessly and I haven't had to do anything to maintain it.
I've been tinkering with it over the last week, but have yet to hear of someone using it in production.
I'd love to hear more about your use case, and any other thoughts you can share when using PocketBase.