When using the latest django from PyPI in CentOS 7, running "./manage.py runserver" gives an error about sqlite being too old. Since there's no newer sqlite version in the CentOS repos, I tried building sqlite from scratch:
curl -L https://www.sqlite.org/2019/sqlite-amalgamation-3290000.tar.gz > sqlite-amalgamation-3290000.tar.gz tar -xvf sqlite-amalgamation-3290000.tar.gzcd sqlite-autoconf-3290000 ./configure make make install This sets up the latest sqlite3 to /usr/local/bin/. Since /usr/local/bin is ahead of /usr/bin in my PATH, just running "sqlite3" in the terminal runs the latest sqlite. It runs without issues, and shows that it's the latest version: my_hostname# sqlite3 SQLite version 3.29.0 2019-07-10 17:32:03 Enter ".help" for usage hints. Connected to a transient in-memory database. Use ".open FILENAME" to reopen on a persistent database. sqlite> Running "./manage.py runserver" again, it still tries to use the old version in /usr/bin, and fails. My django is running in a pipenv virtual environment, where PATH still has /usr/local/bin/ ahead of /usr/bin, and running "sqlite3" in terminal still shows the latest version. I followed the traceback django gives me to the dbapi2.py module, where to figure out the sqlite version it does this: import _sqlite3 _sqlite3.sqlite_version If I run "python" in my virtualenv, and type those 2 lines, it shows the old version of sqlite too. _sqlite3 is not written in python - it's a compiled binary, so I can't examine it to see where it looks. Am I missing something? How can I tell _sqlite3 that there's a newer version of sqlite available on the system? Does _sqlite3 even care about /usr/local/bin/sqlite3? Or is there some sqlite library it's looking for? -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscr...@googlegroups.com. To post to this group, send email to django-users@googlegroups.com. Visit this group at https://groups.google.com/group/django-users. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/baa28569-b18c-423e-b6a5-60e619808503%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
