Wait #postgresql 18 has OAuth authz? https://www.postgresql.org/docs/18/auth-oauth.html

#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 cœur sur tes mentions)

https://www.welcometothejungle.com/fr/companies/communaute-beta-gouv/jobs/data-back-end-pour-ecobalyse-mte-ademe_paris

Upgraded a PostgreSQL server from Debian 12 to 13, and got hit by this bug:

https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=960789

resutling in the new postgresql version running with the wrong configuration after running pg_upgradecluster.

PostgreSQL Basics : lire un plan d'exécution comme un·e pro (ou presque) https://www.journalduhacker.net/s/revswz/postgresql_basics_lire_un_plan_dex_cution https://blog.capdata.fr/index.php/postgresql-basics-lire-un-plan-dexecution/ #postgresql

New blog post Bits of engineering wisdom from a year of the #TalkingPostgres #podcast

featuring highlights from 13 episodes in the past year with amazing #PostgreSQL guests including: Tom Lane, Bruce Momjian, Daniel Gustafsson, David Rowley, Melanie Plageman, Robert Haas, Affan Dar, Andrew Atkinson, @BajoranEngineer, Peter Cooper, Peter Farkas, Pino de Candia, & Shireesh Thota

Hope y'all enjoy it! And big +1 to @asw for co-producing this monthly pod with me https://techcommunity.microsoft.com/blog/adforpostgresql/bits-of-wisdom-from-a-year-of-talking-postgres/4434622

We're always looking for speakers for our virtual Meetups! Got something to share? We'd love to hear from you! Drop us a DM on Meetup and you could be our next speaker!

https://www.meetup.com/postgresql-1/

Streaming Database Rows in Real-Time with Quarkus, Mutiny, and Hibernate Reactive
Learn how to stream PostgreSQL rows to your browser.
https://myfear.substack.com/p/real-time-streaming-quarkus-java-reactive
#Java #Quarkus #Reactive #Hibernate #PostgreSQL

wellp, we're on a brand new database *again* .. because I wanted to use a hardened version of the OS that the database cluster was on. We're also only running one database server now, but with mirrored vdevs (raid 10) .. which will hopefully make the instance even more snappy. Of course, I've slogged the dog, so that's there too on the SSD.

And you fuckers never even knew it went down, so I did my job right.

Fabien COELHO (Mines Paris) nous présente "Comment se débarasser de Full Page Write?". A retrouver sur https://www.youtube.com/watch?v=ACXQiDCB5Io .

New episode 29 of the #TalkingPostgres #podcast is out!

Shireesh Thota (CVP of Azure Databases at Microsoft) once dreamed of driving a bus. Instead, he fell for math, BASIC, and engineering—and now leads all database work at Microsoft.

We talk about:

The shift from developer to manager (if only people came with documentation)
Why databases are a microcosm of computer science
Why Microsoft must contribute to #PostgreSQL open source—not just consume it
Whether Shireesh has a favorite database?
A new #VSCode extension for Postgres

You should listen! You will enjoy it:

https://talkingpostgres.com/episodes/how-i-got-started-leading-database-teams-with-shireesh-thota
https://youtu.be/jP8a_S2MjtY?si=d9USWZ90l5IbOWfz

Please boost so your Postgres friends will discover the episode

And if you subscribe, you'll never miss an episode: https://talkingpostgres.com/subscribe

Also: Big thanks to @asw of Microsoft who co-produces this show with me and is amazing to work with!

*Takes a deep breath*

#MariaDB might be the best general database engine ever and it sucks that the for-profit company using the name kept stepping on rusty rakes over and over again so that people in suits who can't distinguish the corp from the foundation pushed for other platforms.

Side note: #PostgreSQL, I want to love you, but I have so many similar feelings about you as I do about coding in rust. You're too pedantic for your own good.

Analyzing #Database Trends Through 1.8 Million Hacker News Headlines #mongo #mysql #postgresql #duckdb https://camelai.com/blog/hn-database-hype/

On Wed Jul 9 at 10am PDT, we're doing a LIVE recording of Ep29 of the #TalkingPostgres #podcast with guest Shireesh Thota—to talk about how he got started leading database teams.

Join us on Discord to be part of the parallel live text chat. Cal invite with instructions on how to join the Discord: https://aka.ms/TalkingPostgres-Ep29-cal

#PostgreSQL #community #opensource #Microsoft #Azure #Postgres
As always, boosts appreciated

Les contrats coûteux spécifiques aux fournisseurs peuvent être remplacés par une license #PostgreSQL, 100 % open source, garantissant la propriété et le contrôle complet de vos données (même lorsque vous optez pour une assistance pour démarrer ou pour gérer les services en continu). 


Vous songez à faire un pas dans cette direction ? Contactez notre équipe à l'adresse contact@data-bene.io - nous sommes là pour vous aider.

https://www.lemondeinformatique.fr/actualites/lire-coup-de-froid-sur-le-marche-francais-des-services-it-97258.html

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/

Example:
https://l1em.catmaid.virtualflybrain.org/?pid=1&zp=108250&yp=82962&xp=54211&tool=tracingtool&sid0=1&s0=3&help=true

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

From Scripture to Semantic Search: Build an AI-Powered Bible Explorer with Quarkus
Turn centuries of translations into a live NLP playground using Langchain4j, pgvector, and lean Java code.
https://myfear.substack.com/p/ai-bible-explorer-quarkus-langchain4j-pgvector
#Java #Quarkus #PGVector #Postgresql #NLP

Speeding up PostgreSQL dump/restore snapshots

Link: https://xata.io/blog/behind-the-scenes-speeding-up-pgstream-snapshots-for-postgresql
Discussion: https://news.ycombinator.com/item?id=44473888

PostgreSQL's `timestamp with time zone` aka `timestamptz` is easily misunderstood. It just stores the timestamp in UTC, it doesn't store the timezone.

UTC timestamps should be the default on most timestamps, yet libraries like Drizzle default to non-UTC `timestamp`.

Spent the afternoon using vim to edit out a schema design plus notes.

What a relief it is to not have to go back and “fix” the intended spellings and inadvertent capitalizations for each line.

Stupid AI

I can type almost as fast as my brain using muscle memory and vim.

(Yeah, yeah emacs if you prefer)