A new release of the fast connection pooler for PostgreSQL! pgagroal 2.1.0 is out! Yesterday the version 2.1.0 of pgagroal has been released! This is a feature release , and the full changelog is available here . This release provides a lot of new features, most notably: a web console to monitor Prometheus metrics; an improved failover support; an health check process; improve pgagroal-cli ping…
An interesting article about PostgreSQL and Open Source. A very illuminating article about contributing to Open Source and PostgreSQL Abdelrhman Sersawy wrote an article titled How I started contributing to PostgreSQL in which he describes how he started to write code for the community. I think the article is very good and detailed, as well as illuminating. It reminds me how I felt the very first…
A convention about how to write efficient commit messages. Conventional Commits Conventional Commits aims at producing efficient and easy to understand by both humans and automated tools commit messages. While it is mainly focused on git , it can be adopted by any source control management system that is based on commiting changes. The idea is interesting, and at glance remembered me the Semantic…
My personal solutions to the Perl Weekly Challenge. Perl Weekly Challenge 369: string indexes This post presents my solutions to the Perl Weekly Challenge 369 . I keep doing the Perl Weekly Challenge in order to mantain my coding skills in good shape, as well as in order to learn new things, with particular regard to Raku, a language that I love. This week, I solved the following tasks: PWC 369 -…
My personal solutions to the Perl Weekly Challenge. Perl Weekly Challenge 367: overlapping intervals This post presents my solutions to the Perl Weekly Challenge 367 . I keep doing the Perl Weekly Challenge in order to mantain my coding skills in good shape, as well as in order to learn new things, with particular regard to Raku, a language that I love. This week, I solved the following tasks: PWC…
My personal solutions to the Perl Weekly Challenge. Perl Weekly Challenge 366: what time is it? This post presents my solutions to the Perl Weekly Challenge 366 . I keep doing the Perl Weekly Challenge in order to mantain my coding skills in good shape, as well as in order to learn new things, with particular regard to Raku, a language that I love. This week, I solved the following tasks: PWC 366…
A feature I don’t find useful at all! I’m against the ASI (Automatic Semicolon Insertion)! In software development, ASI stands for Automatic Semicolon Insertion and is a feature wide spread in Javascript among the others. This somehow scary name, in simple terms, means that *you are not required to insert a statement terminator semicolon . Let’s see this with a Javscript example: function…
A feature about how to handle harhref keys when querying a table. Perl and DBI hashref keys case-sensitive Perl and DBI are brilliant in giving you power to connect to a database and extract data. There is however something I never noticed, because I’m used to a PostgreSQL: when fetching a row as an hashref , the keys are stored in lowercase. This is not something tied to DBI, nor to Perl, rather…
A stupid thing that made me loose one hour on a non-bug! Oracle and the awkward date formatting Today I spent an hour trying to figure out why a trivial SQL query was not producing the expected results against an Oracle table. The query was something like: SELECT name , surname FROM people WHERE working_date_begin <= current_date and working_date_end >= current_date ; The idea is: “get the people…
My personal solutions to the Perl Weekly Challenge. Perl Weekly Challenge 365: regexps to rule them all! This post presents my solutions to the Perl Weekly Challenge 365 . I keep doing the Perl Weekly Challenge in order to mantain my coding skills in good shape, as well as in order to learn new things, with particular regard to Raku, a language that I love. This week, I solved the following tasks:…
My personal solutions to the Perl Weekly Challenge. Perl Weekly Challenge 364: substituting strings! This post presents my solutions to the Perl Weekly Challenge 364 . I keep doing the Perl Weekly Challenge in order to mantain my coding skills in good shape, as well as in order to learn new things, with particular regard to Raku, a language that I love. This week, I solved the following tasks: PWC…
My personal solutions to the Perl Weekly Challenge. Perl Weekly Challenge 362: Lingua to the rescue! This post presents my solutions to the Perl Weekly Challenge 362 . I keep doing the Perl Weekly Challenge in order to mantain my coding skills in good shape, as well as in order to learn new things, with particular regard to Raku, a language that I love. This week, I solved the following tasks: PWC…
My personal solutions to the Perl Weekly Challenge. Perl Weekly Challenge 361: numbers This post presents my solutions to the Perl Weekly Challenge 361 . I keep doing the Perl Weekly Challenge in order to mantain my coding skills in good shape, as well as in order to learn new things, with particular regard to Raku, a language that I love. This week, I solved the following tasks: PWC 361 - Task 1…
A new entity in the PostgreSQL landscape. Introducing mnemosyne systems The last week a new entity appeared in the PostgreSQL landscape: ** mnemosyne systems **, the last creation of Jesper Pedersen . The initial page says it all: mnemosyne systems create intelligent solutions for PostgreSQL that allows you to achieve your disaster recovery (DR) and high-availability (HA) goals. What are those…
A small donation, that can help freedom. Donatign (again) to Wikipedia And it is that time of the year again: donating a small amount of money to Wikipedia and Wikimedia foundation. Since I use Wikipedia, even if not daily, I believe it is important to support it. After all, even if I don’t use it, my son does. And this is really important: always provide support, even if small, to the projects…
My personal solutions to the Perl Weekly Challenge. Perl Weekly Challenge 359: quick and dirty! This post presents my solutions to the Perl Weekly Challenge 359 . I keep doing the Perl Weekly Challenge in order to mantain my coding skills in good shape, as well as in order to learn new things, with particular regard to Raku, a language that I love. This week, I solved the following tasks: PWC 359…
The new major release of the fast connection pooler for PostgreSQL has been released! pgagroal 2.0.0 is available! It took quite a lot of time to get from version 1.6.0 to the new major version 2.0.0 , but the new pgagroal is finally here! The project went thru two Google Summer of Code (GSoC 2025 and 2024) before this new great release was completed, but the project decided to prefer the code…
My personal solutions to the Perl Weekly Challenge. Perl Weekly Challenge 358: using brute force! This post presents my solutions to the Perl Weekly Challenge 358 . I keep doing the Perl Weekly Challenge in order to mantain my coding skills in good shape, as well as in order to learn new things, with particular regard to Raku, a language that I love. This week, I solved the following tasks: PWC…
A quick guide on how to move (and use) a password store. Migrating a password store to another machine I use the great pass as a password store on my Unix-like machines. It is fast, simple enough, can work on a terminal, can copy the password on the clipboard, and so on. Sometime I need to move the password store, organized into the ~/.password-store , from a machine to another to get my password…
What a mess I did while installing a new system! Damn! I locked myself out of my new Linux System! I was re-installing my Linux laptop, using Fedora KDE spin (if that matters). For various reasons, I haven’t noticed that the main account, the one used for myself, was created with an incorrect username of lferrariluca instead of the usual and simple luca I use. And of course, as usual in these…
My personal solutions to the Perl Weekly Challenge. Perl Weekly Challenge 357: arrays everywhere! This post presents my solutions to the Perl Weekly Challenge 357 . I keep doing the Perl Weekly Challenge in order to mantain my coding skills in good shape, as well as in order to learn new things, with particular regard to Raku, a language that I love. This week, I solved the following tasks: PWC…
My personal solutions to the Perl Weekly Challenge. Perl Weekly Challenge 355: number formatting and sorting This post presents my solutions to the Perl Weekly Challenge 355 . I keep doing the Perl Weekly Challenge in order to mantain my coding skills in good shape, as well as in order to learn new things, with particular regard to Raku, a language that I love. This week, I solved the following…
My personal solutions to the Perl Weekly Challenge. Perl Weekly Challenge 354: time to drink and wait for the new year! This post presents my solutions to the Perl Weekly Challenge 354 . I keep doing the Perl Weekly Challenge in order to mantain my coding skills in good shape, as well as in order to learn new things, with particular regard to Raku, a language that I love. This week, I solved the…
My personal solutions to the Perl Weekly Challenge. Perl Weekly Challenge 353: waiting for Santa… This post presents my solutions to the Perl Weekly Challenge 353 . I keep doing the Perl Weekly Challenge in order to mantain my coding skills in good shape, as well as in order to learn new things, with particular regard to Raku, a language that I love. This week, I solved the following tasks: PWC…
With almost two months of delays, here it is the video of my talk at the Linux Day 2025 in Modena. My talk at the Linux Day 2025: ZFS I finally found time to cut and upload the video of my main talk at the Linux Day 2025 in Modena: ZFS, the Chuck Norris of filesystems . The video is in italian, and the audio and video quality does not depend on me. Here are the links: youtube odysee It was not my…
My personal solutions to the Perl Weekly Challenge. Perl Weekly Challenge 352: and here comes Christmas This post presents my solutions to the Perl Weekly Challenge 352 . I keep doing the Perl Weekly Challenge in order to mantain my coding skills in good shape, as well as in order to learn new things, with particular regard to Raku, a language that I love. This week, I solved the following tasks:…
A shell story about how to test things when doing scripting. Test your square brackets! I do shell scripting everyday, and I’m so used to the usage of square brackets when performing some test, that I forgot the whole story. I assume you know that something like the following performs what it seems to do: if [ -f " $file " ] ; then echo "The file exists, avoid overwriting it!" exit 2 fi The…
This year I traveled quite a lot! Travels This year, 2025 , I traveled quite a lot, after all. Well, not a lot, let’s say, more than usual. I started with a weekend in Naples back in January. On April I was in Bozen, due to the PgTraining Event conference. On June I visited the Pantelleria island with my family. On July I spent a weekend in Krakow. On September I spent a couple of weeks in the…
My personal solutions to the Perl Weekly Challenge. Perl Weekly Challenge 350: only Perl! This post presents my solutions to the Perl Weekly Challenge 350 . I keep doing the Perl Weekly Challenge in order to mantain my coding skills in good shape, as well as in order to learn new things, with particular regard to Raku, a language that I love. This week, I solved the following tasks: PWC 350 - Task…
My personal solutions to the Perl Weekly Challenge. Perl Weekly Challenge 349: moving and grepping This post presents my solutions to the Perl Weekly Challenge 349 . I keep doing the Perl Weekly Challenge in order to mantain my coding skills in good shape, as well as in order to learn new things, with particular regard to Raku, a language that I love. This week, I solved the following tasks: PWC…
My personal solutions to the Perl Weekly Challenge. Perl Weekly Challenge 348: splitting, counting and multiplying This post presents my solutions to the Perl Weekly Challenge 348 . I keep doing the Perl Weekly Challenge in order to mantain my coding skills in good shape, as well as in order to learn new things, with particular regard to Raku, a language that I love. This week, I solved the…
What is this periodic-thing named often when dealing with freeBSD? FreeBSD periodic(8) periodic is nothing more than a shell script that wraps the execution of other scripts. Sorry to be harsh, but that’s it! Why is so many time cited when dealing with FreeBSD? Well, because the operating system delegates to periodic a lot of manainance activities. But, again, to be straight: periodic is not a…
A nice command to get information about the supported filesystems. FreeBSD lsvfs I discovered a FreeBSD specific command, lsvfs(1) , that is handy to get the list of the Virtual FileSystems allowed into the operating system. The command is quite easy to read: % lsvfs Filesystem Num Refs Flags -------------------------------- ---------- ----- --------------- devfs 0x00000071 1 synthetic, jail…
My personal solutions to the Perl Weekly Challenge. Perl Weekly Challenge 347: string mangling This post presents my solutions to the Perl Weekly Challenge 347 . I keep doing the Perl Weekly Challenge in order to mantain my coding skills in good shape, as well as in order to learn new things, with particular regard to Raku, a language that I love. This week, I solved the following tasks: PWC 347 -…
My personal solutions to the Perl Weekly Challenge. Perl Weekly Challenge 346: really not inspired! This post presents my solutions to the Perl Weekly Challenge 346 . This week, I solved the following tasks: PWC 346 - Task 1 - Raku Raku Implementations PWC 346 - Task 1 - Raku Implementation The first task was about counting the largest set of balanced parentheses in a paren-only string. sub MAIN(…
My personal solutions to the Perl Weekly Challenge. Perl Weekly Challenge 344: Lazyness and too much tasks! This post presents my solutions to the Perl Weekly Challenge 344 . I keep doing the Perl Weekly Challenge in order to mantain my coding skills in good shape, as well as in order to learn new things, with particular regard to Raku, a language that I love. This week, I solved the following…
I’m back from Japan! Perl Weekly Challenge 341: back from Japan It has been a while since I committed something to the Weekly Challenge, and this is due to the fact that I spent the last weeks preparing, and most notably, enjoying, a trip to Japan with my family. This post presents my solutions to the Perl Weekly Challenge 341 . I keep doing the Perl Weekly Challenge in order to mantain my coding…
A new minor release for the beloved tool to build and manage multiple PostgreSQL instances. pgenv 1.4.3 is out! pgenv 1.4.3 is out! This minor release fixes a problem in the build of release candidate versions (e.g., 18rc1 ) by stripping out all the text part from a version number using a Bash regular expression.
My personal solutions to the Perl Weekly Challenge. Perl Weekly Challenge 333: streaming numbers This post presents my solutions to the Perl Weekly Challenge 333 . I keep doing the Perl Weekly Challenge in order to mantain my coding skills in good shape, as well as in order to learn new things, with particular regard to Raku, a language that I love. This week, I solved the following tasks: PWC 333…
My personal solutions to the Perl Weekly Challenge. Perl Weekly Challenge 332: quick and easy This post presents my solutions to the Perl Weekly Challenge 332 . I keep doing the Perl Weekly Challenge in order to mantain my coding skills in good shape, as well as in order to learn new things, with particular regard to Raku, a language that I love. This week, I solved the following tasks: PWC 332 -…
My personal solutions to the Perl Weekly Challenge. Perl Weekly Challenge 331: String-ish This post presents my solutions to the Perl Weekly Challenge 331 . I keep doing the Perl Weekly Challenge in order to mantain my coding skills in good shape, as well as in order to learn new things, with particular regard to Raku, a language that I love. This week, I solved the following tasks: PWC 331 - Task…
My personal solutions to the Perl Weekly Challenge. Perl Weekly Challenge 330: crunching words This post presents my solutions to the Perl Weekly Challenge 330 . I keep doing the Perl Weekly Challenge in order to mantain my coding skills in good shape, as well as in order to learn new things, with particular regard to Raku, a language that I love. This week, I solved the following tasks: PWC 330 -…
My personal solutions to the Perl Weekly Challenge. Perl Weekly Challenge 329: mangling strings This post presents my solutions to the Perl Weekly Challenge 329 . I keep doing the Perl Weekly Challenge in order to mantain my coding skills in good shape, as well as in order to learn new things, with particular regard to Raku, a language that I love. This week, I solved the following tasks: PWC 329…
My personal solutions to the Perl Weekly Challenge. Perl Weekly Challenge 328: regexs everywhere! This post presents my solutions to the Perl Weekly Challenge 328 . I keep doing the Perl Weekly Challenge in order to mantain my coding skills in good shape, as well as in order to learn new things, with particular regard to Raku, a language that I love. This week, I solved the following tasks: PWC…
My personal solutions to the Perl Weekly Challenge. Perl Weekly Challenge 326: Happy Birthday Ma’! This post presents my solutions to the Perl Weekly Challenge 326 . I keep doing the Perl Weekly Challenge in order to mantain my coding skills in good shape, as well as in order to learn new things, with particular regard to Raku, a language that I love. This week, I solved the following tasks: PWC…
My personal solutions to the Perl Weekly Challenge. Perl Weekly Challenge 325: filter and iterate This post presents my solutions to the Perl Weekly Challenge 325 . I keep doing the Perl Weekly Challenge in order to mantain my coding skills in good shape, as well as in order to learn new things, with particular regard to Raku, a language that I love. This week, I solved the following tasks: PWC…
My personal solutions to the Perl Weekly Challenge. Perl Weekly Challenge 323: increment and decrement This post presents my solutions to the Perl Weekly Challenge 323 . I keep doing the Perl Weekly Challenge in order to mantain my coding skills in good shape, as well as in order to learn new things, with particular regard to Raku, a language that I love. This week, I solved the following tasks:…
My personal solutions to the Perl Weekly Challenge. Perl Weekly Challenge 322: Splitting and Sorting This post presents my solutions to the Perl Weekly Challenge 322 . I keep doing the Perl Weekly Challenge in order to mantain my coding skills in good shape, as well as in order to learn new things, with particular regard to Raku, a language that I love. This week, I solved the following tasks: PWC…
My personal solutions to the Perl Weekly Challenge. Perl Weekly Challenge 321: Task 2 simpler than Task 1 This post presents my solutions to the Perl Weekly Challenge 321 . I keep doing the Perl Weekly Challenge in order to mantain my coding skills in good shape, as well as in order to learn new things, with particular regard to Raku, a language that I love. This week, I solved the following…
My personal solutions to the Perl Weekly Challenge. Perl Weekly Challenge 320: Simple and Fast! This post presents my solutions to the Perl Weekly Challenge 320 . I keep doing the Perl Weekly Challenge in order to mantain my coding skills in good shape, as well as in order to learn new things, with particular regard to Raku, a language that I love. This week, I solved the following tasks: PWC 320…