Why SQLite is not for production?

It doesn’t support concurrency (no more than one user can be writing to the database at the same time) and it can’t scale

1. Still, you can use it on prod, If your app is having around 5 users and there are visitors, who read the data, instead of writing to the DB. So the users on your app cant perform the write operation at the time, While one user is doing such an operation, another user should wait for a few seconds.
2. If your app is getting traction and you hit around the million views then SQLite is not at all a good choice to scale.

3. SQLite is a serverless database, it doesn’t provide direct network access to its data. This access is built into the application. If the data in SQLite is located on a separate machine from the application, it will require a high bandwidth engine-to-disk link across the network. This is an expensive, inefficient solution, and in such cases, a client-server DBMS may be a better choice.