Chris Ellis @intrbiz@bergamot.social
Admin
PostgreSQL, Linux, Java, and more. Lover of computers, electronics and Open Source. European. Lib Dem. Lead Technical Strategist nexteam.co.uk
Joined Nov 2022
Chris Ellis
boosted
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
Chris Ellis
boosted
@pgstef #PostgreSQL Person of the Week interview with Stefan Fercot: https://postgresql.life/post/stefan_fercot/
Chris Ellis
boosted
@floord #PostgreSQL Person of the Week interview with Floor Drees: https://postgresql.life/post/floor_drees/
Chris Ellis
boosted
@intrbiz #PostgreSQL Person of the Week interview with Chris Ellis: https://postgresql.life/post/chris_ellis/
Chris Ellis
boosted
Edco Wallet opening the PGDay Lowlands Warmup #Meetup at Lunatech in #Rotterdam
Chris Ellis
boosted
Floor Drees ( @floord ) doing Social Media at the PGDay Lowlands Warmup #Meetup at Lunatech in #Rotterdam
Chris Ellis
boosted
Josef Machytka ( @JosefMachytka ) presenting a Lightning Talk at the PGDay Lowlands Warmup #Meetup at Lunatech in #Rotterdam
Chris Ellis
boosted
Kaarel Moppel presenting a Lightning Talk at the PGDay Lowlands Warmup #Meetup at Lunatech in #Rotterdam
Chris Ellis
boosted
Jan Karremans presenting a Lightning Talk at the PGDay Lowlands Warmup #Meetup at Lunatech in #Rotterdam
Chris Ellis
boosted
Stefan Fercot ( @pgstef ) speaking at the PGDay Lowlands Warmup #Meetup at Lunatech in #Rotterdam
Chris Ellis
boosted
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.
Chris Ellis
boosted
Chris Ellis
boosted
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! 🐘🔥
Chris Ellis
boosted
🚀 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
Chris Ellis
boosted
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
Chris Ellis
boosted
DocumentDB has a new home now!
https://news.itsfoss.com/documentdb-moves-to-linux-foundation/
Admin
PostgreSQL, Linux, Java, and more. Lover of computers, electronics and Open Source. European. Lib Dem. Lead Technical Strategist nexteam.co.uk
Joined Nov 2022
