Software Development
More about Django · Module 14 - Leaving the PaaS: deploying to your own server

14.2 From SQLite to PostgreSQL

22 min
Back to the curriculum

Video coming soon

The recording for this lesson has not been published yet.

What we cover

  • Why SQLite is not a production database here
  • psycopg and DATABASES configuration
  • dumpdata and loaddata for the migration
  • Differences that bite: ordering, casing, types
Written notes for this lesson are being prepared. The outline above already shows what the recording will cover.
← 14.1 PaaS versus your own server 14.3 Dockerising the project →

After this lesson you will

  • Run the blog on PostgreSQL locally
  • Move your existing data across without loss

Module 14

14.1PaaS versus your own server 14.2From SQLite to PostgreSQL 14.3Dockerising the project 14.4Gunicorn and Uvicorn 14.5Nginx and Let's Encrypt 14.6Static and media in production 14.7Logging, error tracking and backups 14.8Automated deployment