It’s harder than it might seem to create a stand-alone Python app. It’s also harder than you might think to reliably back up SQLite databases, but Python has the tools for it. And while it’s not easy to install Python on an air-gapped machine, it absolutely can be done.
Why it’s so hard to create stand-alone Python apps
Python’s dynamism is one of its most powerful features. It’s also why making stand-alone apps from Python programs is such a bear.
How to back up SQLite databases the right way (not by copying them!)
SQLite databases are single files, so backing them up just means copying them, right? Wrong. Make backups the proper way by using SQLite’s own backup mechanisms.
