Adrien Nayrat
Adrien Nayrat
@anayrat.info
@postgresql Expert & Freelance. Opinions are mine. Baremetal native
@anayrat@framapiaf.org
Reposted by Adrien Nayrat
Today is the DBA Appreciation Day!

Bring your DBAs a cake and a coffee, please. And don't drop any tables in production, pretty please. It's weekend ...

#PostgreSQL #SQLServer #Oracle #DB2 #MySQL #MariaDB #Snowflake #SQLite #Teradata #Aerospike #ApacheSpark #Clickhouse #WarehousePG #Greenplum
July 4, 2025 at 5:51 PM
Reposted by Adrien Nayrat
25 years ... since #PostgreSQL 7.0 was released.

Major feature included: Foreign Keys, no data integrity without it.
And SQL92 joins. Also important.

Did you use 7.0 in production?
May 8, 2025 at 6:36 AM
Reposted by Adrien Nayrat
The content on my websites are 100% AI-free. Just sayin'.

All mistakes were manual labor ;)
March 5, 2025 at 4:28 PM
Reposted by Adrien Nayrat
The Slides from my talk at the Incontro DevOps 2025 in Bologna are now available!
Check out the JSONB capabilities in PostgreSQL 17 here!

speakerdeck.com/the4thdoctor...

#PostgreSQL #JSONB #DevOps #IncontroDevOps #Bologna #Databases
Leveraging PostgreSQL 17's JSONB for Enhanced Data Modeling and Performance
JSONB has been part of PostgreSQL since the ancient version 9.4. PostgreSQL 17's lates JSONB improvements provides a flexible and efficient way to store…
speakerdeck.com
March 19, 2025 at 10:05 AM
Reposted by Adrien Nayrat
Leveling up! Sleek new web app for the Postgres Compatibility Index is live. Big thanks to Contributors: @gunnarmorling.dev , @tudor.golubenco.org , Frank Pachot, Deepak Mahto , Matt Cornillon and Akash.

Postgres.Is 🚀✨ 🐘

Blog => tinyurl.com/3wr3vy5x
February 17, 2025 at 4:37 AM
Reposted by Adrien Nayrat
Bonjour la France qui a "vérifié" son compte Bsky en indiquant son site Internet en lieu et place de son handle de base.

Si vous pouvez le faire, faites-le.

Surtout si votre compte est celui d'une personne morale, ou d'une personnalité.

A priori le handle de base vous reste réservé.
January 28, 2025 at 8:11 AM
Reposted by Adrien Nayrat
Tesla Gigafactory, Berlin - right now!

In cooperation with @ledbydonkeys.org
January 22, 2025 at 8:40 PM
Reposted by Adrien Nayrat
Utiliser les bases de données PostgreSQL éphémères pour les tests en Go

👉 michael.stapelberg.c...
November 20, 2024 at 8:43 PM
Reposted by Adrien Nayrat
December 10, 2024 at 8:13 PM
Reposted by Adrien Nayrat
Sneak Peek:
… Is Json [Array|Object|Scalar]
Test for Valid JSON, Distinguish between Arrays, Objects and Scalars

modern-sql.com/caniuse/is-j...

See it first on Blue Sky. The others have to wait ;)
… IS JSON [ARRAY|OBJECT|SCALAR]
Check JSON syntax in SQL, test for Arrays, Objects or Scalars
modern-sql.com
March 22, 2024 at 6:11 PM