At Frontpage.fyi we recently embarked on a journey of migrating our storage solution from Vercel Postgres to Turso. During the process we learned about some of the limitations with SQLite and how to build around them with a little ingenuity.