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
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/
Chris Ellis
boosted
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/
@Lightfighter @GossiTheDog haha, yup, me too. Too much expectancy that software will magically solve all your problems.
@raiderrobert switch is a strong term. I have a couple of preferred languages. I often find myself using more than one on many projects. And have worked on projects where the main language is not my preference. I've often been criticised as 'writing X as if it was Y', often something I take as a positive. I tend to think that most people ascribe to an ecosystem and not a language.
Chris Ellis
boosted
i reverse-engineered the Raspberry Pi Compute Module 5! check it out at https://github.com/schlae/cm5-reveng
@tubetime damn, that is cool. Mighty impressive work, love it. Kudos!
Chris Ellis
boosted
"i use linux as my operating system," i state proudly to the unkempt, bearded man. he swivels around in his desk chair with a devilish gleam in his eyes, ready to mansplain with extreme precision.
"actually," he says with a grin, "linux is just the kernel. you use GNU+linux."
i don't miss a beat and reply with a smirk, "i use alpine, a distro that doesn't include the GNU coreutils, or any other GNU code. it's linux, but it's not GNU+linux."
the smile quickly drops from the man's face. his body begins convulsing and he foams at the mouth as he drop to the floor with a sickly thud. as he writhes around he screams "I-IT WAS COMPILED WITH GCC! THAT MEANS IT'S STILL GNU!"
coolly, i reply "if windows was compiled with gcc, would that make it GNU?" i interrupt his response with "and work is being made on the kernel to make it more compiler-agnostic. even if you were correct, you won't be for long."
with a sickly wheeze, the last of the man's life is ejected from his body. he lies on the floor, cold and limp. i've womansplained him to death.
@GossiTheDog I agree with your analysis on the shift happening within our industry. However I think a lot of the cyber security industry has been selling their tech as snake oil for a long time. Often I've felt companies own marketing departments are doing their own tech a disservice by the way it was pitched. The AI hype train seems a continuation of this.
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
