Sqlite3: Command Not Found Python 3 On Windows 10

I installed Python 3.6.5 on Windows 10. I see that there is a sqlite3 folder in ...\Python\Python36\Lib directory. I added Python PATH to environment variable. However, I can't run

Solution 1:

Python's sqlite library probably is installed. Try: import sqlite3 in the Python shell.

If you want to be able to use sqlite's CLI program, you need to install it.

Download here. Use the Windows version obviously.

Solution 2:

Check the permissions of the folder where python3 is installed, it may be that when using powershell you do not have the necessary permissions to access them.

It is always highly recommended to install python3 in a route WITHOUT SPACES

like a:

C:\python36

Solution 3:

So, apparently Sqlite3's CLI does not come installed with Python (Python 3.6). What comes pre-installed is Python's Sqlite3 library.So, you can access the Sqlite3 DB either through the library, or by manually installing Sqlite3 CLI.

Solution 4:

I had an issue with installing brotab, and I always got the message that sqlite3 was not found. I had just installed python beforehand, and in list of modules, I saw sqlite3. When I started py.exe console, I also could import that module. It turned out that I had a entry in my Path to c:\Program Files\LibreOffice\program, which contained an older version of python.exe.

I ran python.exe -m pydoc -b inside that program folder to see the Index of modules, and there was no mention of sqlite3. I removed that entry from my Path, and kept the newly installed python.exe, and it fixed the issue