SQL Query Weather Data

Now I am no guru when it comes to databases and sql query language, but I have today managed to work out how to login to my database using MySql Workbench, select my database and table and query the weather station data to pull out the Max and Min values for each day.

Boy is this much easier to do than how I was doing it in a spreadsheet, the spreadsheet was a nightmare to setup and if one thing went wrong anywhere things would go bonkers and be out of whack. So now, I can pull out the data I want, cut and paste it into a database and create the charts I want and its going to take me next to no time at all now.

Who says you cannot teach an old dog new tricks Onward and Upward, is better than my condolences on the death of your chicken. LOL


Capacitance Touch Iambic Keyer

The 4th project, while no where near complete is a capacitance touch iambic keyer. Well, its not really a project but a proof of concept, and it kind of works ok and is going to be something that i develop more as i have time. The micro is an ESP32 which has 10 capacitance touch sensors built in. I used a modified version the the morse library that’s available on the net for the timing and keying and connected a peizo¬† buzzer to act as side tone. To key a radio all you have to do is set a digital pin high and pull it low when you want to key the transmitter. And as the code takes care of the timing, you could use this on any transmitter that uses a straight key and pulls to ground on keying. Most of them LOL.


Arduino Clock, with Temperature and Humidity

Easter has been quite productive for me, this is project 3 out of 4 is rechargeable battery powered arduino clock with temp and humidity function. Nothing fancy, but highly practical and accurate. The code is a mess, but i have shared it down below, i know someone out there can clean it up and make it more efficient, but for now, its working and doing what it needs so, show the temp and the time.

Hardware is kind of inefficient for this task, arduino mega and 3.2″lcd are both overkill and power hungry. There is an RTC and temp humidity sensor, 18650 battery, boost and charge controller. As usual i did a really crap job at cutting the hole out, I really should have done this in the CNC, I might even make a how to video on how i do that later today.