Romain Pouclet

Programming

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 →

Notes

2025 - Week 23

A circle of toy dinosaures playing the uno card game. I came to feed the neighbours' dog and had to leave a surprise.

I’ve spent so much time working from this nice coffee shop close to me that I think they’re gonna start charging me for rent. The coffee is nice, I’m on a first name basis with most of the baristas and there is a park on the way where I can check on my crow friends and give them peanuts. Anyway, I’ve decided that time is not real. I’m somehow supposed to believe that it’s already been a month since I published my last post, but Trump has only been in power for less than 5 months?

Continue reading →

Programming

I ain't reading all that

A banner that says you're not reading all that then generate your own version of the famous meme and tell them. On the right is a screenshot of a slack workspace where someone shared a video and the response is a version of the meme that says I ain't watching all that

This week I released my latest project to the world: a tiny webpage that allows you to generate your own version of the “I ain’t reading all that” meme. I don’t remember how that idea came to me, except that I was using this meme a lot and making my own versions of it. After the perfect combination of “it would be fun if…” and “I wonder how…”, on an evening when I was left to my own devices, I opened my laptop and started working on it. This tiny project was super fun because I learned a lot and it’s always fun to code something stupid.

Continue reading →

Notes

2025 - Week 18: The One Where I Ain't

A picture of trees in the background, a camping ground with a spot for a camp fire. At the bottom is the top half of a laptop's screen showing an empty editor

Currently writing this post in beautiful Port Alberni, BC, a city known for… stuff, probably. And this old dog who came to see me asking for scratches. I took a few days off from work to spend time with my partner before she goes on a road trip. While work hasn’t been particularly stressful, it’s nice to take some time to recharge.

Continue reading →

Notes

2025 - Week 17: the one where we wrap up

A series of letter made of yellow plastic spelling the word conclusion on a bright blue background

Once again I missed a few weeks, but I got a lot done and posted a few blog posts, so I don’t really feel bad about it. For the past few weeks, I had a lot of extra-scholar activities that kept me busy. Most of them came to a conclusion this last week.

Continue reading →