2025 - Week 38: this website runs on my Oura ring

A hand holding a cup of coffee resting on a folded leg. In the background, a beach with stranded logs and a huge rusted chair, the sea with a few boats, the mountains covered with trees and a crisp blue sky.

Yesterday I ran into this news about a hacker who reused a disposable vape to host a website, pretty impressive stuff. I ordered an Oura ring 18 months ago, but haven’t really used it (or charged it, for what it’s worth) in months now. It made me think… could I build and host this website on my Oura ring as well? Probably not. Also, this isn’t even what this post is about. Kind of embarrassing for you if you believed that.

Continue reading

I'm moving away from GitHub

a screenshot of the top section on GitHub, which shows Palleas' profile. There is a blue banner announcing that my account while be transitioned to the free yearly plan

Well, kind of. I guess I’m leaving GitHub like I left Facebook: I don’t plan on using it anymore, but since that’s where the people of our residence tell us about their kids’ lemonade stands, I’m keeping my account to interact with the outside world when needed.

Continue reading

2025 - Week 33

I’m finally getting my head out of the water after a pretty eventful summer, which started with spending eleven days caring for my partner, stuck at the hospital. It really sucked, I wouldn’t wish it on anybody and this is something that will keep my wonderful therapist busy for the forseeable future. Fortunately, as soon as things started improving, I took some time off for some much needed rest as well as entertaining my little sister who visited for the month.

Continue reading

Expanding the elements of an array with PostgreSQL and Exposed

A picture of the main characters from the TV show The Expanse with one white guy in the center, another guy on his left looking toward the horizon, both are wearing beards. At the bottom are 3 women and in the middle is the first 2 thirds of my face. The title says The Expanse and the subtitle says a store about a postgresql array.

One of the things I really like about Postgres is the various types of columns you can use (without saying that this is limited to Postgres). In this context, the array column type makes it easy to store a list of “stuff”. You can then use the various functions that PostgreSQL provides to query and transform those data. Recently I needed to get all the unique elements from all the values of an array column and once it worked, I pushed a little further to achieve the same result with Exposed.

Continue reading