Example create/open a database and return it ready to be used Closing database connection
All posts by
My other SQLite resources
I’ve also used SQLite with VC# and VC++ and have resources on my min site dedicated to those languages: Primary other site:https://ibex.tech/csharp/category/c-sharp/databases/sqlite Also:https://ibex.tech/visualcpp/category/databases/sqlite
.SQLite general
Python’s built in database Your Python installation contains a Python SQL library named sqlite3 that you can use to interact with an SQLite database. SQLite databases are serverless and self-contained, they read and write data to a file.
Random strings
Create random filename string
Tabs or spaces
Python officially prefers spaces, however you can use either. A file must use one or the other, not both. Use 4 spaces per indentation level.
Python style guide!
Python has an official style guide!! https://peps.python.org/pep-0008/
Tkinter general
Tkinter is the standard GUI library for Python. IDLE not only supports Tkinter but is itself a Tkinter app.
Making a python file executable
#!/usr/bin/python If the script is made executable, the operating system will use that first line to know which interpreter to run to parse the rest of the file. If you always run python scripts from the command line like python myprogram.py then you could remove this line if preferred.
Sleep
Delay with console output displaying countdown
While loops
While loop Loop Control Exit loop Exit and start next iteration