Ian Barwick
banner
ianbarwick.bsky.social
Ian Barwick
@ianbarwick.bsky.social
Biped, oxygen breather. Lives on seventh largest island in the world. Owner of two now largely useless snow shovels.
September 27, 2025 at 2:41 AM
Hmm, this "typing out file management tasks" thing sounds like a nifty new innovation. Surprised it's never been tried before.
July 16, 2025 at 11:44 AM
Damn, I had almost forgotten how much fun it is writing actual SQL queries...
June 19, 2025 at 1:55 PM
Similarly, FTP rsync access is also no longer available.
May 29, 2025 at 12:19 PM
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.
www.postgresql.org
May 29, 2025 at 9:18 AM
Reposted by Ian Barwick
PgPedia Week, 2025-05-04:
pgpedia.info/blog/pgpedia...
PgPedia Week, 2025-05-04
PostgreSQL happenings for the week 2025-04-28 ~ 2025-05-04
pgpedia.info
May 6, 2025 at 12:03 AM
"Eisenbahn-Romantik".
April 12, 2025 at 7:44 AM
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...
April 4, 2025 at 8:00 AM
Reposted by Ian Barwick
PgPedia Week, 2025-03-25:
pgpedia.info/blog/pgpedia...
PgPedia Week, 2025-03-23
PostgreSQL happenings for the week 2025-03-17 ~ 2025-03-23
pgpedia.info
March 24, 2025 at 1:24 PM
Reposted by Ian Barwick
PgPedia Week, 2025-03-09
pgpedia.info/blog/pgpedia...
PgPedia Week, 2025-03-09
PostgreSQL happenings for the week 2025-03-03 ~ 2025-03-09
pgpedia.info
March 10, 2025 at 1:24 PM
So that's how wireless LAN packets are delivered.
What's the best livery worn by the Boeing 767?
March 10, 2025 at 1:49 PM
"We deleted the WAL."
them: write a sad story using only 4 words

me: sudo rm -rf /*
February 28, 2025 at 1:19 AM
Never even occurred to me to check if "which" takes any options.
TIL that the `which` command has a flag, `-a`, which shows all possible places from which a command might be found, e.g.,

$ which -a python
/opt/homebrew/opt/python3/libexec/bin/python
/usr/local/bin/python
/Users/willf/.local/bin/python
https://jvns.ca/blog/2025/02/13/how-to-add-a-directory-to-your-path/"
February 25, 2025 at 5:21 AM
Good to see more PostgreSQL channels moving away from the social media site formerly known as Twitter.
www.postgresql.eu/news/social-...
Social Media Channels - PostgreSQL Europe
www.postgresql.eu
February 18, 2025 at 2:03 AM
Reposted by Ian Barwick
PgPedia Week, 2025-02-02:
pgpedia.info/blog/pgpedia...
PgPedia Week, 2025-02-02
PostgreSQL happenings for the week 2025-01-27 ~ 2025-02-02
pgpedia.info
February 3, 2025 at 1:40 PM
Reposted by Ian Barwick
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?"
January 31, 2025 at 8:51 AM
Reposted by Ian Barwick
Reposted by Ian Barwick
On this day in PostgreSQL, 25 years ago: "DISTINCT ON refactored and can accept multiple expressions"

pgpedia.info/on-this-day-...
2000-01-27: DISTINCT ON refactored and can accept multiple expressions
On January 27th, 2000, DISTINCT ON was refactored to accept multiple expressions
pgpedia.info
January 27, 2025 at 1:41 PM
Reposted by Ian Barwick
PgPedia Week, 2025-01-26:
pgpedia.info/blog/pgpedia...
PgPedia Week, 2025-01-26
PostgreSQL happenings for the week 2025-01-20 ~ 2025-01-26
pgpedia.info
January 27, 2025 at 10:46 AM
Another one for the collection :)
January 19, 2025 at 7:45 AM
Reposted by Ian Barwick
On this day in PostgreSQL, 25 years ago: handling of NULL constraint conditions fixed
pgpedia.info/on-this-day-...
2000-01-19: Fix handling of NULL constraint conditions
On January 19th, 2000, handling of NULL constraint conditions was improved
pgpedia.info
January 19, 2025 at 2:40 AM
3993 days? fscking hell.
January 18, 2025 at 3:23 AM
Engaging in another round of Obsolete Tech Disposal.

Incredibly, I have a purchaser for this ca. 2009-era motherboard.
January 13, 2025 at 6:06 AM
Don't think I need that any more...
December 24, 2024 at 6:11 AM