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.




Weather Station Programing

What a day, what should have been a simple job, for a simple man turned out to be an all day endeavor to overcome a litany of problems. In other words it was a fucking disaster. LOL but hey, i got there in the end and now the weather station is about to be put back out in the weather to do its thing. So lets see, what went wrong, well the sensor i was using was different from the previous one, so i needed a different library, then the device address was different to what was in the code, then the micro controller I was using shit itself and died, then i had problems with my computer not recognizing USB devices, then the board library was being a pain in the arse and needed upgrading, and finally there was this problem with crashing because dumb arse here created an array and was causing a stack overflow because the array had no size.

Well, after all that, I now have a pile of crap on my bench destined for the bin and a nice space on my bench where the weather station used to be. This time i have spares and should be able to fix things if something breaks without having to wait months. Its been down for 5 weeks, and thankfully its back up and running. For now, touch wood. LOL. Now I need to create a page that will query the database and display the data.




So it turns out, that just by changing a DLL file in SDR# and changing from Quadrature to Q Branch, you can get HF on a dongle without an upconverter or modifications to the hardware. And most surprising of all is it actually works ok. I do have some AM broadcast breakthrough and I will need to add in a Highpass filter to remove it, but other than that, it looks like it works quite ok.