If your database isn’t massive and you are carrying out lots of operations on it, it can be much faster to load it into memory instead of working with disk access Opening an existing SQLite database into memory Saving an in memory SQLite database to file
All posts by
Convert dictionary to JSON
Dictionary to JSON
Getting command line arguments
Get arguments Returned as a list, index 0 being the path + filename of the python file that has been run Get any arguments excluding the default index0 path + filename of the python file Get argument and its value This example forces to lower case, remove .lower() if you don’t want that Handling key […]
UPDATE query
Write XML
Create a new XML file Output Output modified XML as a string
Modify XML
Remove a node Add an empty node Replace a node with an empty node Edit an attribute value in a sub node Refresh the ElementTree object You shouldn’t need to. If for some reason you do then you can do this:
Working with zip files
Extract zip file Create zip file
Checkbox
Create a checkbox Get checkbox value
Converting values in Python
Strings
Settings table
Create the table on startup Accessing the table Testing its operation