When to switch from SQLite to MySQL during production?

Question

I am developing a web application in Django. My application is already running, and some users are using it (say, around 5-10). The database is SQLite. Should I upgrade to MySQL now?

Or wait until the user base grows? I don’t have user registration function yet. The main use of the application is the problems that Russian users serve.

Answer 1

Move now. It will be a pain to move later. At least right now, if you release your website in a few hours, it will not be noticeable. This will be a problem later. (Not to mention that you probably have to write a script to move data from your SQLite database to MySQL, which in itself is a pain in the ass.)

Answer 2

I do not understand why use SQLite for development, and then deploy it with MySQL.

Why not develop and deploy the same RDMS?

Answer 3

MySQL - , ( ?). , , .

First, do this for development, so that you understand what problems you will encounter and resolve them before being transferred to production. If you continued to use SQLite for development and MySQL for production, you would run into problems with differences in the end.