Changing db.sqlite3 to MySQL or PostgresSQL

Our current database is set to SQLite, which works fine for small projects. But when the project or the data size grows, we want to switch to other databases such as MySQL or PostgreSQL.

PythonAnywhere allows free usage of MySQL, but for PostgreSQL, you will need to have a paid account.

To start using MySQL, you can refer to PythonAnywhere's brief and useful documentation (https://help.pythonanywhere.com/pages/UsingMySQL/). You will need to recreate some of the steps you took in Chapter 7, Understanding the Database, in the Switching to a MySQL database section.

Note

After you have set up MySQL or any other database because it's a brand new database, you will have to create a new superuser (python manage.py createsuperuser) and run the makemigrations/migrate command:

python manage.py makemigrations

python manage.py migrate