iiinova — where your digital self keeps evolving

Ian Barwick @ianbarwick.bsky.social · 05/05/2026

Aber Bauernhöfe mitten im Flughafenbereich gab's trotzdem nicht. maps.app.goo.gl/nfPJocVMB3Us...

maps.app.goo.gl

100

Ian Barwick @ianbarwick.bsky.social · 24/02/2026

Wonder if PostgreSQL will run on this?

011

Ian Barwick @ianbarwick.bsky.social · 07/12/2025

Early three-monitor desktop setup, with 6 bit EBCDIC toggle switch input.

110

Ian Barwick @ianbarwick.bsky.social · 07/12/2025

Prague by night. (Excuse the fingers, it was 7am in the morning body time after 15 hours of flights.)

010

Ian Barwick @ianbarwick.bsky.social · 26/11/2025

Maybe I should keep some of the log files for old times' sake

000

Ian Barwick @ianbarwick.bsky.social · 26/11/2025

I think I could probably get rid of some of these directories...

A listing of directories in the "postgres" user's directory, some dating back a decade or so.

010

Ian Barwick @ianbarwick.bsky.social · 27/09/2025

"Challenge accepted". www.linkedin.com/help/linkedi...

Unless you turn the switch off, Linkedin will feed your data to the Hallucination Slop Machine.

111

Ian Barwick @ianbarwick.bsky.social · 16/07/2025

Funnily enough earlier today I wrote "pg_dump ... -v" in a ticket, then went back and revised it to "pg_dump ... --verbose" for clarity.

020

Ian Barwick @ianbarwick.bsky.social · 16/07/2025

Let's hope they allow abbreviations to speed things up, so rather than say: "make directory foo and copy file.jpg to foo and convert file.jpg to file.png". lazy people could type: "mkdir foo && cp file.jpg foo/ && convert file.jpg file.png".

220

Ian Barwick @ianbarwick.bsky.social · 16/07/2025

Hmm, this "typing out file management tasks" thing sounds like a nifty new innovation. Surprised it's never been tried before.

110

Ian Barwick @ianbarwick.bsky.social · 20/06/2025

There was actually a CTE involved, as well as a lateral join.

010

Ian Barwick @ianbarwick.bsky.social · 20/06/2025

Had to cheat a little and add a column and a trigger to keep it updated to keep the query practical, as the data structure wasn't quite suited for extracting what I wanted, but it saves updating the application and it's my own personal playground.

010

Ian Barwick @ianbarwick.bsky.social · 20/06/2025

Quite, it was the visualizing of how the data would need to be queried which is the interesting part. Syntax is just typing.

100

Ian Barwick @ianbarwick.bsky.social · 19/06/2025

(I mean this in a serious way, as most of my working days seem to be taken up with scripting DDL in the hope of triggering obscure corner-case bugs).

020

Ian Barwick @ianbarwick.bsky.social · 19/06/2025

Damn, I had almost forgotten how much fun it is writing actual SQL queries...

373

Ian Barwick @ianbarwick.bsky.social · 29/05/2025

Similarly, FTP rsync access is also no longer available.

postgresql.org

000

Ian Barwick @ianbarwick.bsky.social · 29/05/2025

In case anyone's wondering what's up with the PostgreSQL Git repository and "fatal: Could not read from remote repository" messages in the past couple of days, apparently the git:// protocol support has been deactivated (and might be withdrawn entirely), so you'll likely need to switch to https.

postgresql.org

000

Ian Barwick @ianbarwick.bsky.social · 04/04/2025

LinkedIn users not keen on it harvesting their data and content for the hallucination machine might want to disable the below setting... www.linkedin.com/mypreference...

210

Ian Barwick @ianbarwick.bsky.social · 10/03/2025

So that's how wireless LAN packets are delivered.

010

Ian Barwick @ianbarwick.bsky.social · 25/02/2025

Never even occurred to me to check if "which" takes any options.

000

Ian Barwick @ianbarwick.bsky.social · 18/02/2025

I think I had that one, or one very like it.

000

Ian Barwick @ianbarwick.bsky.social · 18/02/2025

Good to see more PostgreSQL channels moving away from the social media site formerly known as Twitter. www.postgresql.eu/news/social-...

postgresql.eu

Social Media Channels - PostgreSQL Europe

030

Ian Barwick @ianbarwick.bsky.social · 31/01/2025

010

Reposted by Ian Barwick

Ólafur Waage @olafurw.com · 31/01/2025

Programming languages: "We are just a way to operate computers in a way that makes sense to humans." Programming languages [takes a big joint hit]: "What if there were 5 kinds of nothingness?"

2663386

Ian Barwick @ianbarwick.bsky.social · 28/01/2025

Back in the day (thumbs braces and glares at kids playing on lawn) this is how we learned to program...

010

Ian Barwick @ianbarwick.bsky.social · 28/01/2025

As a child I lived in a cool temperate climate and I can't recall putting jam in the fridge. I do now because I live somewhere which tends towards hot/humid. It also wouldn't surprise me if factory jam is not as well-preserved as traditionally produced jam.

010

Reposted by Ian Barwick

PgPedia @pgpedia.info · 27/01/2025

On this day in PostgreSQL, 25 years ago: "DISTINCT ON refactored and can accept multiple expressions" pgpedia.info/on-this-day-...

pgpedia.info

2000-01-27: DISTINCT ON refactored and can accept multiple expressions

On January 27th, 2000, DISTINCT ON was refactored to accept multiple expressions

011

Ian Barwick @ianbarwick.bsky.social · 22/01/2025

Very naughty of them not to point out that the feature may have been added during that version's development cycle, but is not final until the actual release. FWIW the final status of features which were added during the Pg17 development cycle can be checked here: pgpedia.info/postgresql-v...

pgpedia.info

PostgreSQL 17 - pgPedia - a PostgreSQL Encyclopedia

120

Ian Barwick @ianbarwick.bsky.social · 21/01/2025