Search code examples
pythonmysqldjangosqlitedev-to-production

Django: sqlite for dev, mysql for prod?


Quick question: is it a good idea to use sqlite while developing a Django project, and use MySQL on the production server?


Solution

  • I'd highly recommend using the same database backend in production as in development, and all stages in between. Django will abstract the database stuff, but having different environments will leave you open to horrible internationalisation, configuration issues, and nasty tiny inconsistencies that won't even show up until you push it live.

    Personally, I'd stick to mysql, but I never got on with postgres :)