Showing posts with label Advent of Code. Show all posts
Showing posts with label Advent of Code. Show all posts

Tuesday, December 26, 2023

Advent of Code 2023 Has Come To A Close

Another year of Advent of Code is in the books. The puzzles seemed much harder this year than they have in past years, but it was still a load of fun. 

Once again, I didn't make it as far as I wanted to. I think I got somewhere around 7 1/2 Days completed, with some work done on the first part of a couple of more days. And once again, I'm reminded that some things probably shouldn't be done. SQL is a really bad language for most of these puzzles. But the ASCII art is fun to reveal. :-)

This year started with over 227K participants, which is a pretty good jump over their first year (2015) with around 87K people. The stories are always entertaining and the puzzles are always fun and challenging. It's been an amusing exercise, although the holiday time begins to get in the way towards the end. 

Around the middle of the season, I was also made aware of another set of puzzles; this one more amenable to SQLish solutions: Hanukkah of Data. This one was a bit different, and a lot shorter, than Advent of Code, and I only completed a few days of the puzzles, but it's worth taking a look at. I'll try to complete it over the year, and probably play along again next year. 

As far as Advent of Code, I'm not sure what language I'll try it again next year. I'd like to keep solving these with SQL, but they aren't really teaching me anything except how to not use SQL to solve procedural problems. It's been pretty amazing that I have been able to actually come to some of these answers, but my code is a whole different level of ugly. We'll see what next year brings. 

To wrap this up for another year, I'd like to thank my fellow participants from the Working Code Podcast.  Give them a listen and join the Discord. And next year, join with us for Advent of Code 2024. 




Thursday, November 30, 2023

Advent of Code 2023 Has Begun!

 How did December get here so fast??? 

It's time for another iteration of Advent of Code.


I'll likely try these in SQL again. I may do multiple languages. We'll see

Sunday, December 26, 2021

Advent of Code Is Done For The Year

We've come to the end of another year of Advent of Code. Apparently this year AoC saw the 10 millionth star issued since it began in 2015! Pretty impressive. Not sure of any final numbers yet, but I've heard there was again more participation this year than the previous year. The stats show that on Day 1, 190,118 people completed both parts and 22,274 additional people completed Part 1. And on Day 25, 7227 completed both parts with 4701 completing Part 1. Last year, more people stuck around to the end (quarantine-related?), but this year had far more participants. 

Pretty cool. 

I started the season with the framework I had begun building to quickly parse the inputs into a usable format, but I quickly realized that the inputs this year were a bit more complex than I was previously working on. I bailed on my framework and just resorted to simple day-by-day processing. I'll go back and refactor my earlier framework to include this year's processing needs. 

I'm not one of the Competitive Programmers who always top the AoC Leaderboard, but I did participate this year with a few other programmers from the Working Code Podcast's Discord server. Some used Python, and a couple of us used CFML. I created a Private Leaderboard for us so that we could at least see how we were doing against some of our peers. Considering that most of the Top 100 Public Leaderboard spots were filled within just a few minutes of puzzle release, I'm glad I did it. 

I didn't finish as many days as I wished I had. I only made it through Part 1 of Day 9 before time ran out. I ran into a huge stumbling block on Day 4 that really hung me up and killed my motivation. I gave it a few tries a couple of times, but kept getting wrong answers. I watched myself getting further and further behind, and just kinda set the whole thing aside for a few days. I finally went back to it and solved it, much easier than I thought I would, and realized I had been way over-thinking it. I tried to blast through as many as I could before time ran out, but stumbled again on Day 8. I managed to get the solution and knocked out Part 1 of Day 9, but struggled with Part 2 until I ran out of time. The biggest lesson I learned was to not try to do these late in the evening. And also, Off-By-One errors suck. 

Oh, and Python (which has been on my Things I Want To Learn list for way too long) is much more capable of handling these types of problems. ColdFusion can do it, but some of the processing seemed to be much more straightforward in some of the other language answers. 

I took notes on the days I did, and I need to finish writing them all up. 

A big thank you to Eric Wastl for creating this, and another big thank you to all who participated. I look forward to doing this again next year. 👍


Working Code Podcast Group 2021 Private Leader Board


Tuesday, December 1, 2020

Advent of Code 2020

 Advent of Code 2020 has begun! 


I have a lot going on right now, but let's see if I make it further this year than I have in past years. 

Thursday, December 5, 2019

Advent of Code 2019

As usual, I'm late. Advent of Code has started on December 1 every year since 2015, yet somehow, I always end up behind. I've done a few of the exercises from previous years, so I want to at least get through some of these for 2019 while they're actually going on.

As this is now December 5th, I've managed to make it through Day 3. Or at least the first half of it. As of right now, Day 6 goes live in about 2 1/2 hours, so I need to do a little bit of catching up.

The first couple of days weren't too tough. Day 2 was a bit of a brute-force solution, and I think Day 3 is shaping up that way so far. My initial solution for Day 3 Part 1 took over an hour to complete! I want to make this a bit smoother and faster.

Regardless, I want to try to keep up with these. Or at least complete all of 2019. And then go back to previous years. Some of these puzzles aren't ideal for ColdFusion, but these are still some pretty good exercises.

So I need to catch up.