I really like the concept of using SQLite as a primary db. The most annoying issue was app fail over and running multiple instances. Now LiteFS seems to solve all of those.

Really just waiting for write-forwarding support to remove the remaining hiccups when running the migrations and then going to use LiteFS in my next project.

Would like to hear if somebody has used it already. What was your experience?