I also have never done much with databases so it is part curiosity and part project. I am interested in home automation, I have Solar Panels, Smart Meters for the gas and electric usage and about to fit a smart heating control system.
All of these systems gather data but are separate, I want to graph the data on a website hosted on my Nethserver so I can see the data visually and then possibly start to use IFTTT type conditions to perhaps react to what the house is doing.
I also have a basic weather station that I want to upgrade with some Arduino electronic projects I have in mind, and then display that data and am looking at building an air quality system (again Arduino or Raspberry Pi based) so more data to gather and display.
Other projects I have is a lightning storm detector to add to the general weather data, an earthquake sensor, ground moisture sensor and others.
It’s a long list, some of which will not see the light of day but if I can at least get the website and database working I can at least start to record my electricity and solar data.
I retire in 5 years, so I need stuff to “tinker” with to keep me occupied and interested, you cannot walk the dog all day every day and I do not want to become addicted to daytime TV and have my limited mind turned to mush in the first year.