How to upgrade sqlite 3.8.2 to >= 3.8.3

by

If you don’t want to recompile Python and you’re using a virtualenv you can do this to set it up without affecting the system as a whole (I’ve done this with Ubuntu 16/18):

  1. Download SQLite tarball from https://www.sqlite.org/download.html

  2. Extract the contents and cd into the folder.

  3. Run the following commands:

    ./configure

    sudo make install

  4. Now edit the activate script used to start your virtualenv so Python looks in the right place for the newly installed SQLite. Add the following line to the top of /path/to/virtualenv/bin/activate:

    export LD_LIBRARY_PATH=”/usr/local/lib”

Now, when active, Django 2.2+ should work fine in the virtualenv. Hope that helps.

More Related Contents:

  1. Django: Deploying an application on Heroku with sqlite3 as the database
  2. OperationalError: database is locked
  3. “no such table” exception
  4. sqlite3.OperationalError: unable to open database file
  5. What is an efficient way of inserting thousands of records into an SQLite table using Django?
  6. Django: sudden DB reset after Heroku sleep
  7. Set up a scheduled job?
  8. Django CSRF Cookie Not Set
  9. Django download a file
  10. Django SMTPAuthenticationError
  11. Django signals vs. overriding save method
  12. Where to put Django startup code?
  13. Can you perform multi-threaded tasks within Django?
  14. Django annotate count with a distinct field
  15. How to access the local Django webserver from outside world
  16. Django persistent database connection
  17. HDF5 – concurrency, compression & I/O performance [closed]
  18. What should I use instead of syncdb in Django 1.9?
  19. Where does pip install its packages?
  20. Django Rest Framework – Could not resolve URL for hyperlinked relationship using view name “user-detail”
  21. Django 1.7 – makemigrations not detecting changes
  22. How can my Model primary key start with a specific number?
  23. pysqlite: Placeholder substitution for column or table names?
  24. Has Django served an excess of 100k daily visits? [closed]
  25. What is the best way to access stored procedures in Django’s ORM
  26. Get the latest record with filter in Django
  27. Where should utility functions live in Django?
  28. ValueError – Cannot assign: must be an instance
  29. Unable to encode/decode pprint output
  30. Nothing happens when I do: python manage.py command

Leave a Comment