How to Upgrade SQLite3 for Python

This video will show you how to upgrade/update SQLite3 for Python. You might want to do this if you are using an app in a virtual environment and want to take advantage of some of the features in the latter SQLite3 versions.

Programming Language: Python 3.7
Console: Cmder
Libraries: sqlite3

[RamonWilliams]

Timestamps
0:00 Intro
0:49 Setting up virtual environment
1:51 Checking the current version of sqlite3 being used
3:24 Upgrading the version of sqlite3 (What you most likely came for)
5:55 Checking to see if the sqlite3 version was updated.

Note: The User "Owner" might be different on your PC.
i.e. your path to your DLLs would look something like this
To find the path where the SQLite folder is located in the python interpreter enter `print(sqlite3)`.

[weberhuang]

thank you very much, I am a NLP engineer and trying to init doccano, which is a django based app, and it comes out of sqlite dll problem as you said. By updating the dll makes me successfully init doccano, many thanks!

[moris]

Hi, can you show us how to use sglite3 with treeview tkinter, how make entry where we can modify row of database and something like this ?? :)
I still learning

[fredq]

I followed every step but still failed. Was it because I was trying to set up in my virtual env? (thou I believe it should work the same since py should import the dll under its Script folder)