@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
DocumentDB has a new home now!
https://news.itsfoss.com/documentdb-moves-to-linux-foundation/
The PostgreSQL User Group NL team is organizing a PGDay Lowlands Warmup Meetup on Thursday, September 11.
Whether you are attending PGDay Lowlands or not (but really you should), this meetup is open to the entire community and is a great opportunity to meet some of the speakers and other attendees.
Join for talks by Chris Ellis, showcasing some Postgres features that make developers’ lives easier, and Stefan Fercot from Data Egret, who will dive into the inner workings of PgBouncer: https://www.meetup.com/postgresql-user-group-nl/events/310728717/
PostgreSQL, Linux, Java, and more. Lover of computers, electronics and Open Source. European. Lib Dem. Lead Technical Strategist nexteam.co.uk