Travel to the US

I went on a trip with my family to Florida in the United States for two weeks. It was a wonderful trip with ups and down. The downs were related to our trip to the United States. Let us start from the beginning. We were supposed to wake up at 3AM and then head to Billund Airport by car. From there we would go in the first leg of the flight to Amsterdam.

Converting SQL data to Parquet

For the post two weeks I have tried to create a script, that converts SQL data to the Parquet format. First I needed to subdivide the data between years and months. This was the actual hard part, because it took forever. However I did it. The data was retrieved from the database, packaged under correct dates and then uploaded to S3. As I mentioned earlier, I’m not a programmer. I consider myself as a devops engineer first.

What I'm reading

For the past several months I have been reading the books in the “Wheel of Time” series. I wanted a series of books that were kind of like “The Lord of the Rings” with a rich history. And I found it in these books. I read the first one over several months because I was busy with other things, however I got really into them and I started to care about the characters, so I just had to read them.

More memory for my laptop

So two days ago I ordered 64GB of memory for my laptop. It is two modules where each one is 32GB. I got a Dell XPS 15" 9510 that has two removable memory slots. Some laptops these days have soldered on memory slots that really sucks. Making them removeable is, from my perspective, very convenient and necessary. Manufacturers should do that - all of them. The next part came with opening up the bottom of my laptop.

Gerrit migration from LDAP to OIDC using Keycloak

This is a rather cumbersome guide because lots of moving parts must be aligned perfectly together to make this work. At the company I work at we are 12 people that uses Gerrit. I needed to have these 12 people, and some of them were from different departments, to sit in a virtual meeting at the same time. Thankfully this was done over the internet, but it did take some time to find 30 minutes in their busy schedules to run through a guide on migrating their users from LDAP to OIDC.

Gerrit and Keycloak integration using OIDC

I spent several days trying to make Gerrit work with Keycloak using OIDC (OpenID Connect). At the company I’m working at we’re using Gerrit for our code repositories. I had never tried or heard of Gerrit before, so it is actually pretty interesting to learn that something like Gerrit exists. The user interface is simple and I actually started to enjoy using it. It is not that I use UI that much, because I interact with Gerrit using ‘git’ in the terminal.

Random update #2

I have started watching Community again. It is one of those series that I can watch over and over again without ever getting tired of it, or skipping episodes. I can do the same thing with Friends, How I met your mother, Scrubs, Frasier, Spin City (First 3 seasons), New Girl and Brooklyn Nine-Nine. It is October and the energy crises is hitting us all. The cost of electricity has increased somewhat.

End of vacation

My vacation ends tomorrow. It is the last day and then we are starting up our routines again. I need to figure them out because I have forgotten them already. Is that what happens after two weeks of relaxing? I guess so.

Airport Memories

Last week I was in Copenhagen Airport. I was walking around the concourses to pass the time, because there was two hours before my flight. So I thought I would do a stroll around and look at things. I first wandered to concourse F. It is one of the farthers concourses there is - the other one is concourse A. So I was walking to concourse F - there was nothing to see.

Just one more update about tools

For the past several years I have worked with Terraform and only Terraform. CloudFormation is not something that I have worked that much with and I feel like I’m in quicksand. I did you use it a lot back when CloudFormation Stacksets got released. I like that I could just deploy a stackset and it then got pushed to all other accounts that I had designated. It worked really well. However tools such as Terraform has come a long way, so doing multiaccount deployments could not be done directly in Terraform.