October 11, 2021
Python - sqlite3
I am not sure I will even use this, but it is too good to be true.
Python on Windows includes sqlite3. It is a standard part of the
python interpreter at this point and when I fire up python on windows
and type this, it works!
import sqlite3
What you don't have without extra effor is the sqlite3 cli, which might
indeed be worth getting. The sqlite3 CLI is simply called "sqlite3".
What you want is: sqlite-tools-win32-x86-3360000.zip
This simply contains 3 "exe" files, the question is where to put them.
Various pages on disk say to create a new folder C:\sqlite and put
then in there. I do this by bringing up a file manager on C:, this has
a handy "make new folder" button up at the top, and after that it is
drag and drop.
Add this to the windows path
This is all new to me, but you search for "env". You will see a thing that
says "Edit system environment variables". When you select that, it wants
your admin password. This brings up a "System Properties" dialog and there
is a button near the bottom labeled "Environment Variables".
Find the System Variable labeled "Path", select it, and click edit down below.
Now click "New" and add C:\sqlite.
You have to start a new command line window for this to take effect.
Feedback? Questions?
Drop me a line!
Tom's Mineralogy Info / tom@mmto.org