Chris Petrilli<p>Wait <a href="https://hachyderm.io/tags/postgresql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>postgresql</span></a> 18 has OAuth authz? <a href="https://www.postgresql.org/docs/18/auth-oauth.html" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://www.</span><span class="ellipsis">postgresql.org/docs/18/auth-oa</span><span class="invisible">uth.html</span></a></p>
#postgresql
4 posts4 participants1 post today
Upgrading (and trying to plan downtime to upgrade) #PostgreSQL clusters to version 17 at work, along with switching to the built-in C.UTF-8 locale (--locale-provider=builtin for initdb, --locale C.UTF-8 for initdb or pg_createcluster), which is available since that version, and does not depend on libc or libicu, so there is no version mismatch even if there are different underlying systems, which is good for WAL-based replication. While C.UTF-8 is a generally good locale: predictable and easy collation, sensible formats, commonly available, and with UTF-8 support.
Two open positions in my lab to develop scientific software with python and javascript.
Software: CATMAID
Documentation:
https://catmaid.readthedocs.io/en/stable/
Source code:
https://github.com/catmaid/CATMAID/
If you have experience with #SQL (#postgresql), #python and its many libraries (particularly #django), #rust, and #javascript, write to me and let's discuss.
Examples of open issues: https://github.com/catmaid/CATMAID/issues
catmaid.readthedocs.ioWelcome to CATMAID — CATMAID 2021.12.21 documentationThe Collaborative Annotation Toolkit for Massive Amounts of Image Data. Used for image viewing, neuron reconstruction, ontology based annotations and more.
After the plv8 #PostgreSQL extension had to be removed from #Debian and apt.postgresql.org in 2017/2018 because the build system was just too complex and impossible to package properly, its successor pljs has just entered the repository again. Welcome back!
GitHubGitHub - plv8/pljs: PLJS - Javascript Language Plugin for PostgreSQLPLJS - Javascript Language Plugin for PostgreSQL. Contribute to plv8/pljs development by creating an account on GitHub.
Den franske 
by Lyon dropper Microsoft til fordel for #opensource -kontor og samarbejdsværktøjer i fremtidens softwaresalat Lyonnaise vil omfatte #Linux, #PostgreSQL og #OnlyOffice
Republikkens 3. største by og næststørste økonomiske centrum skrev tirsdag et om at reducere afhængigheden af 
software, forlænge levetiden for sin hardware og derfor reducere sin miljøpåvirkning og styrke den teknologiske suverænitet i sin offentlige service
https://www.theregister.com/2025/06/26/lyon_leaving_microsoft/
https://www.lyon.fr/actualite/action-municipale/la-ville-de-lyon-renforce-sa-souverainete-numerique
The Register · French city of Lyon ditching Microsoft for open source office and collab tools
AUTHOR UNBOXING: PostgreSQL Mistakes and How to Avoid Them! To celebrate the release of my book, you can use code PBAngelakos for 50% OFF until July 1st!
https://youtube.com/shorts/zopxHP1dznY
Order the book here from @ManningPublications 
http://mng.bz/D9mR
youtube.com- YouTubeEnjoy the videos and music you love, upload original content, and share it all with friends, family, and the world on YouTube.
Continued thread
Heads up #Sharkey #admins when #upgrading...
If you have a lot of #data in your #instance #database, running pnpm run migrate might fail because one or more of the ALTER TABLE... statements might actually timeout on your #PostgreSQL server!
To fix this, attach yourself to your sharkey database and enter the following...
ALTER DATABASE sharkey SET statement_timeout = '10min';
ALTER ROLE sharkey SET statement_timeout = '10min';pnpm run migrate command again.#SharkeyAdmin #InstanceAdmin @sharkey@sharkey.team
Labelbox is hiring Senior Software Engineer, AI Platform - Data Infrastructure
#java #kotlin #python #typescript #react #node #redux #graphql #aws #azure #gcp #kafka #kubernetes #mongodb #mysql #nosql #postgresql #seniorengineer
East Bay, California; North Bay, California; San Francisco, California; South Bay, California
Full-time
Labelbox
Job details https://jobsfordevelopers.com/jobs/senior-software-engineer-ai-platform-data-infrastructure-at-labelbox-com-mar-1-2025-b00e69?utm_source=mastodon.world&utm_medium=social&utm_campaign=posting
#jobalert #jobsearch #hiring
Continued thread
And why does `substr()` in #PostgreSQL treat `1` as the first character, instead of `0`, LIKE EVERYTHING ELSE?!
We want all voices to be heard in our community and the PgUS Diversity Committee is hard at work ensuring that happens!
Test Postgres in Python Like SQLite : A #Python testing library that provides seamless integration between PGlite and Python test suites. Get the full power of PostgreSQL in your tests without the overhead of a full PostgreSQL installation.
GitHubGitHub - wey-gu/py-pglite: PGlite wrapper in Python for testing. Test your app with Postgres just as lite as SQLite.PGlite wrapper in Python for testing. Test your app with Postgres just as lite as SQLite. - wey-gu/py-pglite
Yesterday I upgraded my Mastodon instance to go from PostgreSQL 15 PostgreSQL 17. The whole process was so simple that it almost seems silly to blog about it, but I did it anyway, in case anyone is interested:
https://blog.thms.uk/2025/06/upgrade-postgres-15-17-mastodon?utm_source=mastodon
Special thanks to @ruud who told me about link mode in pg_upgradecluster which was the missing piece I needed in oder to get the upgrade done with my limited disk space.
blog.thms.ukUpgrading Mastodon from PostgreSQL 15 to PostgreSQL 17 - blog.thms.ukUpgrading Mastodon’s database from PostgreSQL 15 to 17 on Ubuntu 24.04 is fast and easy using `pg_upgradecluster` with link mode. Here’s a quick guide with steps, tips, and cleanup.
Guild is hiring Staff Software Engineer (Remote)
#c #python #typescript #react #node #graphql #aws #postgresql United States Full-time Guild
Job details https://jobsfordevelopers.com/jobs/staff-software-engineer-remote-at-guild-com-may-16-2025-e83b93?utm_source=mastodon.world&utm_medium=social&utm_campaign=posting
#jobalert #jobsearch #hiring
I wrote a thing about a somewhat bizarre CPU behavior observed during #PostgreSQL benchmarks on large systems. Seems related to cores being too idle, but hard to "prove" these internal CPU behaviors :-( Also, not sure how to mitigate it.
Tomas Vondra · Benchmarking is hard, sometimes ...Benchmarking complex systems can be difficult. Here's a problem I'm currently investigating, possibly related to process scheduling.
Continued thread
On a totally unrelated note: Anyone got experience upgrading Postgres 15 to 17? Specifically for mastodon?
Good idea? Bad Idea? Easy? Hard?
Do people over here like #MongoDB? I think I kinda like the concept/tech, including the way to do queries as just JSON matchers. But in the end people are just using documents w/ a forced structure anyways and could have gone #PostgreSQL in the first place?
Web scale something something?
So... here we go again!
#Heroku has deprecated #PostgreSQL 14, which we use in 7 of our apps hosted with them, so from today until end of the times they will be nagging us to upgrade to PostgreSQL 15 otherwise they will upgrade us to PostgreSQL 17 on Oct 28, 2025
Announcement:
--- Heroku Postgres 14 deprecation
https://devcenter.heroku.com/changelog-items/3237