@gerrymcgovern Ah, and since this seems to be making the rounds: it's time for my occasional reminder of one especially unpleasant aspect of the LLM hype storm.
LLMs take advantage of a faulty heuristic many (probably most, but don't have exact stats) people have about human intelligence: namely, someone or something that produces fluent and grammatically coherent text about a wide range of topics, on demand, is "intelligent".
This is a very compelling heuristic and also very wrong.
In the case of LLMs, it's wrong in the way we're all talking about here: it leads people to see thinking or reasoning in the statistical word salad these beasties produce.
But it's even more of a problem when people invert the heuristic and turn it into "someone or something is *not* producing fluent text about a wide range of topics, therefore they are *not* intelligent". This mirror-world version causes enormous social harm to people who for whatever reason (autism, selective mutism, etc.) can't speak the way people expect they would be able to "if they were smart".
Some pictures from the lightning talks round we had after lunch.
Join us for an afternoon with more talks and debates: https://www.youtube.com/watch?v=tJYEuIpzch4
Pictures by honkingelephant.com
@pgstef #PostgreSQL Person of the Week interview with Stefan Fercot: https://postgresql.life/post/stefan_fercot/
@floord #PostgreSQL Person of the Week interview with Floor Drees: https://postgresql.life/post/floor_drees/
@intrbiz #PostgreSQL Person of the Week interview with Chris Ellis: https://postgresql.life/post/chris_ellis/
Edco Wallet opening the PGDay Lowlands Warmup #Meetup at Lunatech in #Rotterdam
Floor Drees ( @floord ) doing Social Media at the PGDay Lowlands Warmup #Meetup at Lunatech in #Rotterdam
Josef Machytka ( @JosefMachytka ) presenting a Lightning Talk at the PGDay Lowlands Warmup #Meetup at Lunatech in #Rotterdam
Kaarel Moppel presenting a Lightning Talk at the PGDay Lowlands Warmup #Meetup at Lunatech in #Rotterdam
Jan Karremans presenting a Lightning Talk at the PGDay Lowlands Warmup #Meetup at Lunatech in #Rotterdam
Stefan Fercot ( @pgstef ) speaking at the PGDay Lowlands Warmup #Meetup at Lunatech in #Rotterdam
Chris Ellis ( @intrbiz ) speaking at the PGDay Lowlands Warmup #Meetup at Lunatech in #Rotterdam
@Edent also in general window functions are great for aggregating these kind of stats.
@Edent failing that, good old cron.
@Edent not super familiar with Maria/MySQL, more a PostgreSQL person.
But maybe: https://mariadb.com/docs/server/server-usage/triggers-events/event-scheduler/events
@Edent be careful with 'UPDATE count = count + 1" patterns. They're unlikely to accurately count as you expect due to concurrency issues. Especially in MVCC systems, it will depend alot on transaction isolation levels.
For this kind of thing, just logging the visits as records and aggregating on analysis / periodically is often the better approach. Removes a lot of the concurrent write headache and give you more flexibility.
Next week, I'll be speaking at 🇬🇧 @postgresuk about #PostgreSQL Row-Level Security on Tuesday 9th Sept. Don't miss this great event in London, CU there! 🐘🔥
🚀 The program for PGConf.EU 2025 is live!
Featuring big names in PostgreSQL and rising stars you won’t want to miss. 🌟
See you in Riga, 21–24 Oct! 🇱🇻
👉 https://www.postgresql.eu/events/pgconfeu2025/schedule/
#PostgreSQL #PGConfEU2025 #opensource #ITlatvia #Latviaevents
Bahah. Somebody has also FOI'd Ofcom too asking them for their own assessment into how safe it was to tweet links to their own website, which then (with hyperlinks) subsequently links to the 34 porn sites they are investigating. Which do not have age verification.
https://www.whatdotheyknow.com/request/ofcoms_compliance_with_the_onlin
PostgreSQL, Linux, Java, and more. Lover of computers, electronics and Open Source. European. Lib Dem. Lead Technical Strategist nexteam.co.uk