lingo.lol is one of the many independent Mastodon servers you can use to participate in the fediverse.
A place for linguists, philologists, and other lovers of languages.

Server stats:

66
active users

#postgresql

2 posts2 participants0 posts today

Pleased to have had the opportunity to use my brain on a programming (#SQL) task.

It was a bit like working out compound interest, when the interest rate changes every year. The task was:

In a manufacturing process, there are various losses of material at each step. Each input component has a cost per kg, so when the mass of the final output is less, the cost per kg of items produced goes up (using costs from the original materials).

Now each processing step has a known loss (e.g. 5% for one step, 6% for the next). The loss acts on what's left from the step before, so is compound.

We want a report of the amount of money lost at each step of the way, with a final total at the end.

The solution involved creating a new #Postgresql operator to do a cumulative multiplication (Postgres can do cumulative sums but not multiplications out of the box) and Window functions, so made my day 🙂

Glad to have the help of colleagues as well.

One of France's largest cities has now also ditched Microsoft for open source software

「 In an online memo, Lyon's office explained it would be transitioning away from Microsoft software towards OnlyOffice, developed by a group of Latvian developers, as well as Linux and PostgreSQL.

As part of the move, Territoire Numérique Ouvert is also being adopted as an alternative for video conferencing and office automation 」

techradar.com/pro/one-of-franc

TechRadar · One of France's largest cities has now also ditched Microsoft for open source softwareBy Craig Hale

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
theregister.com/2025/06/26/lyo

lyon.fr/actualite/action-munic

The Register · French city of Lyon ditching Microsoft for open source office and collab toolsBy Simon Sharwood
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';
...and try the pnpm run migrate command again.

#SharkeyAdmin #InstanceAdmin @sharkey@sharkey.team

Message de service : notre instance #mobilizon est en maintenance depuis 3 jours.

Contexte : suite à la dernière mise à jour mineure, on a découvert que la version minimum de #PostgreSQL est passée de 11 à 13. On doit donc mettre à jour notre cluster PGSQL pour régler le problème.

Just starting to watch some of the videos from the #PostgreSQL @posetteconf conference. The first I've watched is interesting - a story telling way of showing how to think of schema design. This is something that anyone developing in Agilebase will be very familiar with and as such maybe this sort of thing could be a good introduction for new people.

The audience is different - the video is talking to developers, whereas our audience will be no-coders. The requirements for how to think about a problem though are exactly the same. When building an app to model a chess tournament, what things do we model? How do they relate to each other? What are the data integrity guarantees we need?

Although watching it the role-playing can feel a little contrived, I really like that Sarah and Boriss took that approach.

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.

github.com/wey-gu/py-pglite

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

Next week, #PosetteConf is happening Jun 10-12. Free & virtual

✅ Newly-published, this "ultimate guide" blog post will help you navigate the 4 livestreams & 42 #PostgreSQL talks at POSETTE: An Event for Postgres (or to figure out where the virtual hallway track is happening) 🐘

POSETTE is now in its 4th year. It's organized by the Postgres team at Microsoft, and our team's goal (in partnership with the amazing speakers) is to delight all of you who care about Postgres

🚀 Boosts appreciated. Don't let your #Postgres friends miss out.

techcommunity.microsoft.com/bl

TECHCOMMUNITY.MICROSOFT.COMUltimate Guide to POSETTE: An Event for Postgres, 2025 edition | Microsoft Community HubA guide to help you navigate all 42 talks at the 4th annual POSETTE: An Event for Postgres, a free and virtual developer event happening Jun 10-12, 2025.