Ian van der Linde
LightNews LightNews
banner
ivdl.co.za
Ian van der Linde
@ivdl.co.za
15 followers 10 following 11 posts
Senior PostgreSQL DBA

https://ivdl.co.za
Posts Replies Media Videos
Reposted by Ian van der Linde
was.tl
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...
October 22, 2025 at 2:32 AM
ivdl.co.za
Chaining sudo on SSH to run PostgreSQL queries and dumps remotely

ivdl.co.za/2025/03/23/c...
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...
ivdl.co.za
March 23, 2025 at 9:34 AM
ivdl.co.za
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
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...
ivdl.co.za
February 23, 2025 at 8:19 AM
ivdl.co.za
Day 3 and 4 of #adventofcode done! Already two days behind but catching up since it's weekend!
December 6, 2024 at 9:27 PM
Reposted by Ian van der Linde
microsoft.com
We've always been a fan of blueskies.
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.
December 6, 2024 at 1:44 AM
ivdl.co.za
Day 2 of #adventofcode2024 done! Not bad, although the classic Python copy by reference on list assignment does bite!

#adventofcode
December 2, 2024 at 6:58 PM
ivdl.co.za
Day 1 of #adventofcode2024 done! Straightforward challenge to start things off with.

#adventofcode #python
Advent of code leaderboard screenshot
December 1, 2024 at 12:25 PM
ivdl.co.za
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
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...
ivdl.co.za
November 24, 2024 at 7:12 PM
ivdl.co.za
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
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...
ivdl.co.za
November 21, 2024 at 10:36 AM
ivdl.co.za
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
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 ...
ivdl.co.za
November 18, 2024 at 9:30 AM