Just learned a handy command for getting BigQuery table/view schema to json:
bq show --schema --format=prettyjson project_id:dataset_id.table_id > my_table_schema.json
Current RevOps professional, future Cloud Engineer/Developer. A father (of one) and a husband (also of one).
Reading
Outlive
Peter Attia, Bill Gifford
Notes
Posts
New website, now hosted on micro.blog
Alright, DNS has propagated, and my domain is now pointing to micro.blog’s servers where this site is hosted. Yay! 🥳
As said, my website is now hosted on micro.blog. The past two years I was using Ghost CMS, which I myself on Hetzner’s …
Notes
Photos
5am train to Helsinki. Time to visit the office once again.
Notes
Mozilla is shutting down Pocket.
Pocket was the first read-it-later / bookmarking app I used. Many have come and gone since then.
Pocket has helped millions save articles and discover stories worth reading. But the way people use the web has …
Notes
After a few years, giving micro.blog another try. Ghost CMS is too heavy for my use case and I don’t want to manage my own server as I have done so far.
Still working on getting things set up before finally setting up my custom domain pointing here.
Posts
Fixing "server misbehaving" error in Miniflux
I’ve been self-hosting Miniflux on my Synology NAS (DS224+) using Docker Compose/Container Manager.
My home network is powered by a GL.iNet Flint 2 router, which is running AdGuard Home for DNS-level ad and tracker blocking. All DNS traffic in …
Posts
Tech ecosystem dilemma
Once again, I’m considering if I should entirely change my personal tech stack, both in terms of hardware and software.
This is a thought that I tend to revisit often. Actually following through, not so often.
I have had a habit of making 180 degree …
Posts
My Default Apps Late 2023
There seems to be quite a trend going on with people listing their default apps. Apparently it all got started from a podcast episode Duel of the Defaults by Hemispheric Views. I must admit I have yet to listen this episode but I will definitely get …
Posts
On subscriptions
Manuel Moreale wrote about his subscriptions and said:
I'd be curious to see other people's breakdowns so if you do end up writing about your situation let me know.
Encouraged by this Kev Quirk and Jan-Lukas Else wrote about their subscriptions. After …
Notes
I got the local development setup for Ghost working after some difficulties. I have already made some changes to the theme, uploaded the edited theme in this instance and set everything to GitHub.
I feel like a proper developer. 😃
Posts
Meta offering paid subscriptions in EU
It seems Meta is starting to offer paid subscriptions for Facebook & Instagram in EU due to privacy regulations.
To comply with evolving European regulations, we are introducing a new subscription option in the EU, EEA and Switzerland. In …
Posts
Back on Ghost CMS
It took a few weeks after I remembered why I don’t like Wordpress. That being said, I’m back on Ghost CMS.
First, Wordpress, it’s too big (for me). I have had to use it previously for work. I didn’t like it then, don’t like it now. It just feels …
Posts
Secure setup for Rasperry Pi
This post is a documentation I’ve written for myself for securely set up a new Raspberry Pi. Hopefully it’s some use to someone else as well.
The steps below have been tested for Rasperry 4 B running Raspberry Pi Lite. They might work for other …
Posts
Web-based tools - from the Dock or as browser tabs?
I’ve been using Google Workspace tools for several years now mainly due to my work at Gapps. I’ve always struggled with whether to use them from the Dock or as browser tabs on my Macbook. I’ve tried both approaches, but I keep switching between the …
Posts
Getting Rasperry Pi 4 B to boot from an SSD in USB 3.0 port
Finally got it working. There were quite a few issues along the way but the main revelation came when I noticed that I was able to boot from an USB 2.0 port after all. This helped narrow down the issue and eventually led to a fix that allowed me to …
Notes
Mass Effect Legendary Edition being on PS+ in last December(?) was a really nice surprise. I’ve played some Mass Effect games when they were launched, but don’t remember much of those.
Now having a kid and having significantly less time …
Posts
Stadia is (officially) closing down
Google announced the yesterday that it’s shutting down Stadia as it is for consumer use. The servers will shut down on 18th of January 2023.
The writing had already been on the wall for a while. The first signs of Google losing faith in Stadia came …
Posts
Tools and technologies are not the solutions - they are merely potential
I participated in a sales training session today that was organized for our sales team. During the training, there was a mention that the salesperson should aim to create a need for offered products/solutions that they offer. I felt I needed a bit …
Posts
Yearly Review 2021
It’s again that time of the year when we should take a look at the rear view mirror and see what happened (and if those are the things that should have happened).
Year in Numbers
At some point during the year, I realised that I find no joy in …
Posts
Yearly Review 2020
It’s been odd and challenging year. I been thinking about doing it earlier but I guess this year finally warranted it. This is my first proper yearly review.
Year in numbers
Being quite interested in quantified-self movement, I tend to collect …
Notes
Simple enough. Often easier said than done though.
“Don’t speak unnecessarily. When speaking, think carefully and be concise. Be honest but kind.”
– Rebeka Toh, The Art of Speaking
Notes
A stupid decision that works out well becomes a brilliant decision in hindsight.
Notes
We are just a bunch of monkeys on a spinning rock.
Notes
First “Black Friday”, now “Cyber Monday”.
We buy things we don’t need with money we don’t have to impress people we don’t care about. Dark times indeed.
Posts
Bring your parents to work day
Last Friday there was an official “bring your child to work” -day in Finland. As we often do at Gapps, we did things a little differently. We arranged our own “Bring your parents to work” -day.
The idea stemmed from the notion that many of our …