🐱💤 Woken by a cat and armed with ChatGPT Pro, our hero decides to cram a QR code generator into a single
#SQL statement, because who needs practicality when you have insomnia? 😂 Oh, and it runs faster on PostgreSQL 17, because clearly that's the version everyone is using for their enterprise-grade QR code needs. 🚀
https://tanelpoder.com/posts/generate-qr-code-with-pure-sql-in-postgres/ #InsomniaCoding #QRcode #PostgreSQL17 #ChatGPTPro #HackerNews #ngatedpqr.sql: Generate QR Codes with Pure SQL in PostgreSQL - Tanel Poder Blog
As my cat woke me up way too early for a Saturday morning, I decided to put all this extra time (and my ChatGPT Pro subscription) into good use and generated a QR-code generator for PostgreSQL, written as a single pure SQL statement. No external libraries or Postgres extension installation needed!
The pqr.sql example usage is simple:
$ psql -qf pqr.sql -v payload='Hello, World!' There’s also a bit more complex version pqrsafe. - Linux, Oracle, SQL performance tuning and troubleshooting training & writing.
Aparentemente se les fue la olla a los de #Fedora con la actualización a #Fedora43 si se tiene instalado #PostgreSQL.
#Fedora42 trae #PostgreSQL_16, mientras que la v43 trae #PostgreSQL_18. Entonces, al actualizar el SO, todo peta, porque no puedes usar `postgresql-setup --upgrade`, ya que tu cluster es v16 y el upgrade sólo sirve de v17 a v18.
Más info y solución, aquí: https://discussion.fedoraproject.org/t/cant-upgrade-postgres-after-f42-f43/171071/4
#Linux #Databases #PostgreSQL16 #PostgreSQL18 #PostgreSQL17
Can't upgrade postgres after f42->f43
Unfortunately there are a few issues. Fedora does not allow to install multiple versions of Postgres, which makes this a bit more complicated. Luckily the postgres-upgrade packages include the “old” (n-1) binaries. There are a few options available how to do the upgrade. I am trying to find a nice solution that is the least error prone. e.g. if you are not careful you might end up with things like old cluster does not use data checksums but the new one does. An upgrade always replaces your c...
Après un coup d’œil dans le rétro de 2024, vos rendez-vous avec #PostgreSQL en 2025 => https://dali.bo/202501_voeux
Merci aux collègues pour leurs contributions communautaires et coopératives, quel que soit leur métier. 💐
#PostgreSQL17 #DBA #SGBD
#pgday #formation #workshop
#bienDansMaScop
Setup Read Replica (master-slave) Database on Postgresql 17
Setup read-replica for your postgresql 17 Database
Il y a un mois sortait #PostgreSQL17. Benoit, l'un de nos #DBA consultants, vous fait un rapide résumé de ses nouveautés => https://dali.bo/202410_postgresql17
#PostgreSQL #SGBD
#opensource #logicielsLibres
Comprehensive Guide: Setting Up PostgreSQL 17 on Ubuntu 24.04 – SQLpassion
Comprehensive Guide: Setting Up PostgreSQL 17 on Ubuntu 24.04 – SQLpassion
PostgreSQL 17 now available in Cloud SQL
PostgreSQL: PostgreSQL 17 Press Kit
PostgreSQL 17がやってくる(3) ログインイベントトリガ - Qiita
はじめににゃーん今回は、PostgreSQL 17develに入っている「ログインイベントトリガ」を簡単に調べてみた。調査バージョン今回の調査では、2024-04-19時点のPostgreS…
N-gated Hacker News
Carl von Lesquereux
Dalibo
Harisankar P S
Klaus Aschenbrenner
Brightbox
Qiita - 人気の記事