Ian van der Linde's Avatar

Ian van der Linde

@ivdl.co.za

Senior PostgreSQL DBA https://ivdl.co.za

17
Followers
7
Following
14
Posts
18.11.2024
Joined
Posts Following

Latest posts by Ian van der Linde @ivdl.co.za

Post image

It’s finally done and I love it. #mechkeyboard #mkb

09.02.2026 15:22 πŸ‘ 1 πŸ” 1 πŸ’¬ 0 πŸ“Œ 0

Nice! Onto the reading list it goes 😁

27.01.2026 17:28 πŸ‘ 0 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0
Post image

Day 11: Reactor,Blindness
#AdventOfCode

11.12.2025 22:43 πŸ‘ 34 πŸ” 3 πŸ’¬ 1 πŸ“Œ 2
Advent of Code 2025

I just completed all 12 days of Advent of Code 2025! #AdventOfCode adventofcode.com Thanks @was.tl - it was a blast! It was also a huge pleasure attempting the puzzles together with @jvdl.me and @mphomafata.bsky.social this year!

12.12.2025 14:37 πŸ‘ 1 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

Finally got around to reading yours now. Really nice, concise solution.

07.12.2025 20:04 πŸ‘ 1 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0
The Advent of Code Day 1 countdown showing 23:46:29 remaining until the first puzzle unlocks.

The Advent of Code Day 1 countdown showing 23:46:29 remaining until the first puzzle unlocks.

aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa

30.11.2025 05:15 πŸ‘ 149 πŸ” 14 πŸ’¬ 4 πŸ“Œ 9

Hello, friends! After 10(!) years of #AdventOfCode, I've made some changes to preserve my sanity: there will be 12 days of puzzles each December (still starting Dec 1) and there is no longer a global leaderboard. Read more:
adventofcode.com/2025/about#f...
adventofcode.com/2025/about#f...

22.10.2025 02:32 πŸ‘ 615 πŸ” 120 πŸ’¬ 51 πŸ“Œ 25
Preview
Chaining sudo on SSH to run PostgreSQL queries and dumps remotely Photo by Kvistholt Photography on Unsplash It is common to run some commands via the postgres account as it is the de facto PostgreSQL super user. This means that if you're running these commands r...

Chaining sudo on SSH to run PostgreSQL queries and dumps remotely

ivdl.co.za/2025/03/23/c...

23.03.2025 09:34 πŸ‘ 1 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0
Preview
Firefox has built-in vertical tabs now Last year, Mozilla announced that they're developing native vertical tabs for Firefox, and that it's available in the Nightly release channel. Since then, despite generally keeping up with things, I h...

Turns out you can enable vertical tabs in Firefox stable now - they work great, and you only need to change one flag in about:config.

ivdl.co.za/2025/02/19/f...

#firefox

23.02.2025 08:19 πŸ‘ 1 πŸ” 1 πŸ’¬ 0 πŸ“Œ 0

It was fun to see you solving that one :D

I really like the premise of Day 7 - I'll continue working on it later today. I'll get back to Day 5 and 6 sometime.

07.12.2024 07:32 πŸ‘ 0 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0
Post image

Day 3 and 4 of #adventofcode done! Already two days behind but catching up since it's weekend!

06.12.2024 21:27 πŸ‘ 2 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0
Originally the default wallpaper of Microsoft's Windows XP, this photo shows green rolling hills with a vibrant blue sky and white clouds in the background. Charles O'Rear took the photo in California, USA.

Originally the default wallpaper of Microsoft's Windows XP, this photo shows green rolling hills with a vibrant blue sky and white clouds in the background. Charles O'Rear took the photo in California, USA.

We've always been a fan of blueskies.

04.04.1975 12:00 πŸ‘ 11820 πŸ” 2099 πŸ’¬ 671 πŸ“Œ 654
Post image

Day 2 of #adventofcode2024 done! Not bad, although the classic Python copy by reference on list assignment does bite!

#adventofcode

02.12.2024 18:58 πŸ‘ 5 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0
Advent of code leaderboard screenshot

Advent of code leaderboard screenshot

Day 1 of #adventofcode2024 done! Straightforward challenge to start things off with.

#adventofcode #python

01.12.2024 12:25 πŸ‘ 1 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

You could write a little blog post to tell people if they see a mismatch between core count and hardware specs to check that setting :)

27.11.2024 08:58 πŸ‘ 0 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

Increase your processing power by 50% with this one weird trick!

27.11.2024 06:20 πŸ‘ 0 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0
Preview
Pretending to be PostgreSQL: Part two - responding to queries Masquerading as the elephant in the room Introduction In Part 1 we implemented the server handshake in Python. With our subterfuge now established, we'll go ahead and respond to requests. Las...

Curious about the PostgreSQL protocol? Part two of my series "Pretending to be PostgreSQL" is now live, which shows how to craft packets to respond to queries on the wire:

ivdl.co.za/2024/11/24/p...

#postgresql #postgres #sql #python

24.11.2024 19:12 πŸ‘ 3 πŸ” 1 πŸ’¬ 0 πŸ“Œ 0
Preview
A quickstart guide to CloudNativePG on Ubuntu and Mac OS Photo by Namukolo Siyumbwa on Unsplash Running CloudNativePG (CNPG) allows you to run a replicated PostgreSQL cluster with similar characteristics to a production employment on your personal machin...

CloudNativePG allows you to run a three-node, replicated PostgreSQL cluster on your laptop with just a couple of commands. I wrote a quickstart guide for those running on Mac OS or Ubuntu:

ivdl.co.za/2024/11/21/a...

#postgresql #postgres #macos #ubuntu #kubernetes #cnpg #cloudnative

21.11.2024 10:36 πŸ‘ 3 πŸ” 2 πŸ’¬ 0 πŸ“Œ 0
Preview
PostgreSQL streaming replication characteristics on UNLOGGED tables Ever wondered what happens if you switch an UNLOGGED PostgreSQL table to LOGGED while replication is active? Probably not, but now that you're here you might as well find out. Photo by Timelab ...

Ever wondered what happens if you switch an UNLOGGED PostgreSQL table to LOGGED while replication is active? Probably not, but now that you're here you might as well find out.

ivdl.co.za/2024/11/04/w...

#postgresql #postgres

18.11.2024 09:30 πŸ‘ 1 πŸ” 1 πŸ’¬ 0 πŸ“Œ 0