Lightnews — Scholar-powered news

Ian Barwick @ianbarwick.bsky.social · Jun 20

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

Ian Barwick @ianbarwick.bsky.social · Jun 20

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.

Ian Barwick @ianbarwick.bsky.social · Jun 20

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

PostgreSQL happenings for the week 2025-04-28 ~ 2025-05-04

Ian Barwick @ianbarwick.bsky.social · Jun 19

(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).

2

Ian Barwick @ianbarwick.bsky.social · Jun 19

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

3 3 7

Ian Barwick @ianbarwick.bsky.social · May 29

Similarly, FTP rsync access is also no longer available.

Ian Barwick @ianbarwick.bsky.social · May 29

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

Reposted by Ian Barwick

PgPedia @pgpedia.info · May 6

PgPedia Week, 2025-05-04:
pgpedia.info/blog/pgpedia...

PgPedia Week, 2025-05-04

Ian Barwick @ianbarwick.bsky.social · Apr 12

"Eisenbahn-Romantik".

Samsung’s latest stick vac can alert you to calls and text messages

Ian Barwick @ianbarwick.bsky.social · Apr 4

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...

2 1

Ian Barwick @ianbarwick.bsky.social · Mar 30

This sucks.
www.theverge.com/news/639078/...

Can I call you back after the rinse cycle?

www.theverge.com

1 2

Reposted by Ian Barwick

PgPedia @pgpedia.info · Mar 24

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

PostgreSQL happenings for the week 2025-03-03 ~ 2025-03-09

Reposted by Ian Barwick

PgPedia @pgpedia.info · Mar 10

PgPedia Week, 2025-03-09
pgpedia.info/blog/pgpedia...

PgPedia Week, 2025-03-09

Ian Barwick @ianbarwick.bsky.social · Mar 10

So that's how wireless LAN packets are delivered.

Flightradar24 @flightradar24.com · Mar 10

What's the best livery worn by the Boeing 767?

A LAN Chile Boeing 767 landing on a runway

Ian Barwick @ianbarwick.bsky.social · Feb 28

"We deleted the WAL."

nixCraft @cyberciti.biz · Feb 28

them: write a sad story using only 4 words

me: sudo rm -rf /*

https://jvns.ca/blog/2025/02/13/how-to-add-a-directory-to-your-path/"

Ian Barwick @ianbarwick.bsky.social · Feb 25

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

Will Fitzgerald @willwhim.com · Feb 24

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

Ian Barwick @ianbarwick.bsky.social · Feb 18

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

Ian Barwick @ianbarwick.bsky.social · Feb 18

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

3

Reposted by Ian Barwick

PgPedia @pgpedia.info · Feb 3

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

Ian Barwick @ianbarwick.bsky.social · Jan 31