Is sqlite is supported in vercel?, SQLITE_CANTOPEN in nextjs when deploy the app

[inteclix]

[GET] /api/specialities
04:53:46:50
Executing (default): SELECT id, name, description, dateOfSpeciality, icon, img1, img2, createdAt, updatedAt FROM specialities AS specialities;
2020-05-21T02:53:47.143Z 7872090f-10c1-49e6-9053-6960e7e10706 ERROR Unhandled Promise Rejection {"errorType":"Runtime.UnhandledPromiseRejection","errorMessage":"SequelizeConnectionError: SQLITE_CANTOPEN: unable to open database file","reason":{"errorType":"SequelizeConnectionError","errorMessage":"SQLITE_CANTOPEN: unable to open database file","name":"SequelizeConnectionError","parent":{"errorType":"Error","errorMessage":"SQLITE_CANTOPEN: unable to open database file","code":"SQLITE_CANTOPEN","errno":14,"stack":["Error: SQLITE_CANTOPEN: unable to open database file"]},"original":{"errorType":"Error","errorMessage":"SQLITE_CANTOPEN: unable to open database file","code":"SQLITE_CANTOPEN","errno":14,"stack":["Error: SQLITE_CANTOPEN: unable to open database file"]},"stack":["SequelizeConnectionError: SQLITE_CANTOPEN: unable to open database file"," at Database. (/var/task/node_modules/sequelize/lib/dialects/sqlite/connection-manager.js:61:34)"]},"promise":{"isFulfilled":false,"isRejected":true,"rejectionReason":{"errorType":"SequelizeConnectionError","errorMessage":"SQLITE_CANTOPEN: unable to open database file","name":"SequelizeConnectionError","parent":{"errorType":"Error","errorMessage":"SQLITE_CANTOPEN: unable to open database file","code":"SQLITE_CANTOPEN","errno":14,"stack":["Error: SQLITE_CANTOPEN: unable to open database file"]},"original":{"errorType":"Error","errorMessage":"SQLITE_CANTOPEN: unable to open database file","code":"SQLITE_CANTOPEN","errno":14,"stack":["Error: SQLITE_CANTOPEN: unable to open database file"]},"stack":["SequelizeConnectionError: SQLITE_CANTOPEN: unable to open database file"," at Database. (/var/task/node_modules/sequelize/lib/dialects/sqlite/connection-manager.js:61:34)"]}},"stack":["Runtime.UnhandledPromiseRejection: SequelizeConnectionError: SQLITE_CANTOPEN: unable to open database file"," at process. (/var/runtime/index.js:35:15)"," at process.emit (events.js:322:22)"," at eventToObjectGenerator.promiseCreated (/var/task/node_modules/bluebird/js/release/debuggability.js:258:33)"," at activeFireEvent (/var/task/node_modules/bluebird/js/release/debuggability.js:301:44)"," at fireRejectionEvent (/var/task/node_modules/bluebird/js/release/debuggability.js:703:14)"," at Promise._notifyUnhandledRejection (/var/task/node_modules/bluebird/js/release/debuggability.js:90:9)"," at Timeout.unhandledRejectionCheck [as _onTimeout] (/var/task/node_modules/bluebird/js/release/debuggability.js:39:25)"," at listOnTimeout (internal/timers.js:549:17)"," at processTimers (internal/timers.js:492:7)"]}
Unknown application error occurred

[styfle]

Since sqlite stores data locally, we recommend using a different database that can share state between instances of your functions.

You can't reliably write to sqlite because storage is ephemeral in Serverless Functions. As your function receives more concurrent traffic, we will create new instances of your function that don't share the same storage.

[Luisdv93]

What would be a good alternative? I just uploaded a simple project to Vercel and I found out about this issue.

[styfle]

Do you need to write data or is is read only?

If its read only, consider creating a json file with your data instead.

[Luisdv93]

It's read only.

I guess it does make sense to use a json file in my case. Thank you.

[AaronConlon]

Hope to support sqlite db file...😌