I cannot install Prefect 2.0 on Ubuntu 18.04 LTS due to sqlite3 incompatibility. Why?

[anna_geller]

View in #prefect-community on Slack

@Rajan_Subramanian: hello, i am having issues with installing prefect 2.0 in my aws. I have a ubuntu 18.0 running which comes with a older version of sqlite3. Prefect 2.0 uses version greater than 3.24. is there anyway i can not install the sqlite3 depdency when installing prefect? @Kevin_Kho @Anna_Geller

@Kevin_Kho: You can try using pip install --no-deps to not install dependencies and then do them manually

@Rajan_Subramanian: pip install prefect --no-deps?

@Kevin_Kho: Yep
See this

[March 11th, 2022 8:41 AM] michael054: You can do pip install --no-dependencies prefect

@Rajan_Subramanian: seems im still getting this error: Orion requires sqlite >= 3.24.0 but we found version 3.22.0

@Michael_Adkins: You won’t be able to use Prefect with the old version of SQLite since we use newer features
Unfortunately, it’s really hard to install a new version of sqlite because it’s linked into python

@Rajan_Subramanian: oh i see, so i suppose i ahve to upgrade to ubuntu 2.0
20
ubuntu 20 which comes shipped with newer sqlite package?

@Michael_Adkins: Yeah we test on Ubuntu 20.04
You can also try something like charles leifer | Compiling SQLite for use with Python Applications but really it’s a pain
If there was a good way to get a newer sqlite installed we’d have a tutorial on it but I haven’t found a reliable method yet

[Tarek]

Hi Admin,

any updates about how to upgrade sqlite linked in python? I tried to upgrade to python 3.9.9 but unfortunately, sqlite still at version 3.22. Also, I tried the link you mentioned above but I got an error while running the Makefile about a file missing sqlite3.h
any suggestions?

Thanks

[anna_geller]

The problem with this is that Ubuntu 18.04 relies on an older incompatible Python version - do you have the option to use Ubuntu 20.04 instead? this comes prepackaged with Python 3.8.

Alternatively, try installing using Conda - this might be the easiest

also, check this thread:

How to install Prefect 2.0 on a Linux VM

Installation guide Troubleshooting tips Python version Make sure you are using supported Python version - you can find the minimal version here: Postgres backend When using a Postgres backend, make sure to use Postgres version >= 13. SQLite backend The main challenge when installing Prefect 2.0 with SQLite backend on Linux is finding the right SQLite version matching the environment (Python version and Linux distribution). Older versions of Linux package a version of SQLite that cann…