I have an “always-on” Raspberry Pi 3 which does logging of
temperature, pressure, power use and so on readings from around the
house and county.
I've had it just over a year and it's been running the version of
Raspbian (the Debian Linux distribution modified for the Pi) that was
current when I got it. The logging has been to flat files containing
lines of JSON but recently I started switching to a Sqlite3 database
but was having problems with the code running on the Pi which didn't
happen on my
laptop
running Ubuntu 17.04.
I strongly suspected the problem was the old version of Sqlite3
or Python3 in that Raspbian distribution so decided to upgrade to
the latest Rasbian (2017-11-29, based on Debian 9 Stretch rather
than the previous one which was based on Debian 8 Jessie).
During the installation on the new system I made notes of what I needed
to do to get my code running. For my own future reference and maybe
of help to others, here they are.
More...