Well after some head banging and stuff Ive got soem working python code. if its a bit dodgey sorry its my first attempt at python and quiet frankly I dont have a clue what Im doing but the end result is t will connect to my MQTT broker and subscribe to my MQTT topics and write the data to an SQLlite3 database.

So now I can get on with loghing the data which I have desperately wanted to do all winter - now winter has come to an end - Oh well I expect to see lots of very high temps by lunchtime most days.

Interesting just while its beenrunning and Ive been playng with it I have already found the freeze point in the system which has caused me to have no hot water on a couple of days this year - its been a very mild wet winter here so not much problem with freezing but next year will probably be nasty.

I have a lot tlearn about writing python so now im not trying to make this project work Ill go back and do some tutorials and learn what Ive done and come back and fix things like my bunch of global variables in a function.