Forums

Bash console command sqlite3 --version shows me SQLite version 3.11, but it is outdated like 3 years from now. I need to use current sqlite version 3.26.0. How can I update to it on pythonanywhere?

You can try apsw. It's a thin Python wrapper around sqlite and it downloads and compiles its own sqlite from source when you install it.

Hi Glenn, is this the only way to get a newer version of sqlite3? I am in the unfortunate middle ground of having to either use this method or rewrite a whole bunch of RANK () OVER statements that are valid on my local machine but apparently need to use SQLite 3.25 or newer, looks like from the bash console the pythonanywhere version is 3.11 Thanks

You could try compiling and installing sqlite from a source tarball, but that's not something that we can give you much help with.