Show newer

Kaarel Moppel presenting a Lightning Talk at the PGDay Lowlands Warmup #Meetup at Lunatech in #Rotterdam

#PostgreSQL #Conference

Jan Karremans presenting a Lightning Talk at the PGDay Lowlands Warmup #Meetup at Lunatech in #Rotterdam

#PostgreSQL #Conference

@Edent also in general window functions are great for aggregating these kind of stats.

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

🚀 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! 🇱🇻
👉 postgresql.eu/events/pgconfeu2

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

whatdotheyknow.com/request/ofc

#OnlineSafetyAct

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: meetup.com/postgresql-user-gro

Show older
Mastodon

Time for a cuppa... Earl Grey please!