The Booze Challenge
In 2024 i was talking to friends about how our drinking habits have changed over the years as we get older. I knew apps existed that track drinking habits but they are often complex. So i decided to create something simple. I wanted something that you simply log on and click 'Sober' or 'Not Sober'. It was a great way to get back into the world of SQL/databases, general coding and turning data into visualisations. I've created a mini ecosystem whereby you can get insight into your own habits or join challenges with your friends and see how you compare.
Behind the scenes i've coded it to connect to a database with multiple relational tables through SQL/PHP. Using advanced SQL queries to retrieve the data through dynamic PHP coding i'm able to then present the data in a visual form for every user on their own dashboard. I've used both Google charts API and CSS/HTML to turn the data into a picture.
Click here for more info on this project
More to come...