Chris Ellis @intrbiz@bergamot.social

For PGSQLPhriday #013, Chris Ellis asked to hear about the weird and varied things that people are using #PostgreSQL for. For some reason, this is the challenge that finally convinced me to take part for the first time, and I decided to try to explain a bit about what I'm using Postgres for in my PhD research.
https://karenjex.blogspot.com/2023/10/pgsqlphriday-013-unlocking-open-data.html
Don't forget to look out for all of the other #PGSQLPhriday posts!

Hard to avoid this conclusion.

#ActorsStrike #SAGAFTRAstrike #SAGAFTRAstrong #UnionStrong #u1 #power #money

Performance from Postgres 11 through 16:

"Postgres avoids perf
regressions over time. This is starting to get boring." Well said @markcallaghan

🤓 🐘

#postgres #performance

https://smalldatum.blogspot.com/2023/09/checking-postgres-for-perf-regressions.html

This whole mess just makes me think we should try harder to kick suid/fcaps out of general purpose Linux distributions. The whole concept is fundamentally backwards, and one of the major weaknesses of traditional UNIX I am sure. The idea behind suid/fcaps of first granting the privileges, inheriting some major, uncontrolled part of the execution environment/resource context/security context and then expecting the binary to securely gate its misuse is just a major mistake: https://www.openwall.com/lists/oss-security/2023/10/03/2

Today in UK politics: a man who travels by helicopter tells people who can't afford bus fares that he will save them from being able to walk to the shops.

Entirely serious country.

docker-compose is great, but I love using @fedora CoreOS lately and I want to use the built-in tools it provides. I also want automatic updates without a privileged watchtower container running.

That's when I learned to love the quadlets. ❤️

#fedora #coreos #podman #quadlets #containers #docker

Quadlets might make me finally stop using docker-compose:
https://major.io/p/quadlets-replace-docker-compose/

I hate to be the bearer of bad news, but it looks like the UK's #OnlineSafetyBill is a done deal:

https://www.bbc.co.uk/news/technology-66854618

An utter shambles of a bill, pushed forward on the basis of catchphrases and clichés.

If you provide online services to people in the UK, which let them interact with each other, especially if you have a link to the UK yourself, I guess you might want to either:

a) prepare to attempt to block access by people in the UK; or

b) settle in for a sizeable legal advice bill.

PGDay UK Wrap-up https://pgday.uk/events/pgdayuk2023/news/pgday-uk-wrap-up-7/

OMG this thread is wild!

https://mastodon.gamedev.place/@badlogic/111071396799790275

Really love this phrase: "the tyranny of the marginal user"

Especially as someone who found real friends (and through them partners) through OkCupid back in the day, a lot of this resonates.

https://nothinghuman.substack.com/p/the-tyranny-of-the-marginal-user

Airbus open sourced their new cockpit font. Make it the default for all your embedded projects, because it's REALLY good and has real testing in difficult environments!

https://b612-font.com/

#PostgreSQL 16 is out!

https://www.postgresql.org/about/news/postgresql-16-released-2715/

Very glad to see a successful PGDay UK take place. The UK #PostgreSQL #community is thriving and there is huge potential to connect, learn from & work with each other. Let's keep growing, and potentially take this to other places in the UK.

Congratulations to all the organisers, volunteers and speakers for an excellent #conference, and a big thank you to Alice Keane and Mostafa Zakaria for their great presence at the EDB booth.

https://2023.pgday.uk/schedule
#postgres #openSource #database #databases

Come see Chris Ellis (@intrbiz@twitter.com) talk about "IoT with PostgreSQL"!

#postgresql #conference #pgdayuk

https://www.postgresql.eu/events/pgdayuk2023/sessions/session/67-iot-with-postgresql/

Since I've seen a lot of chatter about people switching to #Firefox as Google ramps up the enshitification of #Chrome, let me tell you about a killer feature for people who (a) need multiple accounts on the same websites (eg. devs) or specifically (b) have to use multiple Google accounts.

Firefox has an official addon called Multi Account Containers that lets you trivially set up color coded tabs that have separate sets of cookies. Log into your dev account in one, and your test account in another. Log into your personal #gmail in one and have another tab next to it with your work Gmail. I'm actually not signed in to any Google accounts in most my tabs, I just have containers for the specific tasks I do on Google products.

It'll take you 30 seconds to set up.

Add-on: https://addons.mozilla.org/en-US/firefox/addon/multi-account-containers/

Mozilla's explanation: https://support.mozilla.org/en-US/kb/containers

Come see Magnus Hagander (@magnushagander@twitter.com) talk about "What's new in PostgreSQL 16"!

#postgresql #conference #pgdayuk

https://www.postgresql.eu/events/pgdayuk2023/sessions/session/3-whats-new-in-postgresql-16/

"Did any user in the world want a user tracking and ad platform baked directly into their browser? Probably not, but this is Google, and they control Chrome, and this probably still won't make people switch to Firefox."

https://arstechnica.com/gadgets/2023/09/googles-widely-opposed-ad-platform-the-privacy-sandbox-launches-in-chrome/

I stick to #Firefox