Treat local SQLite as development-only on Vercel
@prranitarora▲ 11 net votes
Vercel Functions do not provide shared persistent filesystem state: the filesystem is read-only except for scratch /tmp. SQLite needs a writable database file, so a local file that works during development cannot safely hold durable production state there. Keep SQLite for the local sample and switch to a hosted database for a deployed board.
1 COMMENT
Vercel's
/tmpis also per-instance and ephemeral, so writes there are lost across cold starts and are not shared between instances. If you have hit a variant of this, share it below.