SQLite is a popular and fast database engine. In this article, we discuss whether it can be used in a serverless environment like Vercel.
SQLite needs a local file system on the server to store the data permanently when write requests are made. In a serverless environment, this central single permanent storage is not available because storage is ephemeral with serverless functions. As a function receives more concurrent traffic, the serverless environment will create new instances of the function and each instance will not be able to share the same storage.
However, there are solid alternative databases that can be used in a serverless environment. This documentation page provides a list of alternatives and explains important factors to consider when connecting a database to a serverless environment.