How We Host a Blog on Vercel with SQLite

Vercel's filesystem is ephemeral, so a local SQLite file won't survive deploys. The fix: libSQL / Turso — hosted SQLite with the same SQL.

The stack

• Next.js App Router for SSG/ISR
• Drizzle ORM over libSQL
• Vercel Blob for image uploads

The result is a fast, SEO-friendly blog with zero servers to manage.