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:

59
active users

#postgresql

6 posts6 participants0 posts today

#JeRecrute un•e ingénieur•e data/backend #Python / #PostgreSQL pour Ecobalyse, la startup d’État qui calcule combien coûtent à la planète les mer^Wtrucs qu'on achète

PS: ça va faire super malpoli/yolo mais je me casse en vacances ce soir et j'ai vraiment besoin d'un gros break donc je laisse mes adorables collègues dont @vjousse vous filer toutes les infos complémentaires dont vous auriez besoin (désolé copain)

welcometothejungle.com/fr/comp

www.welcometothejungle.comData back-end pour Ecobalyse (MTE/ADEME) - beta.gouv.fr - Freelance - Télétravail totalbeta.gouv.fr recrute un(e) Data back-end pour Ecobalyse (MTE/ADEME) !
Replied in thread

@domm: Oh fsck, #mst died? Very sad to hear. 😢 I still remember that he offered help and advise when I took over #Lintian, especially about the web backend (which the previous Lintian maintainer started to rewrite from scratch but never finished) where mst seems to have been involved from the #PostgreSQL side. He was also often present in #Debian's #Perl IRC channels and we chatted occasionally, not always about Perl. I think I also met him IRL once, but I'm no more sure where.

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