Archive

This year I am attempting to solve the Advent of Code problems with BigQuery SQL. I don't know how far I will get, but I have completed the first 4 days here.

SQL is a ridiculous choice for this challenge, but this is a good opportunity to learn more of BigQuery's features that I don't normally use.

I'll be posting daily on my site and will be sending out weekly recaps via this newsletter.

Today's post is quite short, just wanted to share that I figured out how to get tomorrow's wordle: https://boonepeter.github.io/posts/tomorrows-wordle/

(Spoiler alert if you play!)

The hardest part of this post was getting some JavaScript to run on the blog post (to update the title with tomorrow's word). I like using Hugo a lot, but trying to insert JavaScript is not quite as seamless as I'd like.

After I made this post I saw that I wasn't the first one to figure this out. Someone even made a bot that tweets tomorrow's word at people who post their score. But that's just downright mean.

It's been almost a year since I first posted about Spotify Codes. I'd like to share part 2 of my deep dive with you now: https://boonepeter.github.io/posts/spotify-codes-part-2/

In this post I walk through the encoding process step by step and demonstrate a working version of the decoder.

Let me know if you have any questions about this process!