In psql, null values are displayed as blank strings by default, which can be confusing to read. However, you can customize this behavior by setting a specific character to represent null values, making your output more readable and easier to interpret: \pset null '-x-' All null values will become -x-, which is much more convenient. anderson=# select * from test1; name | surname ------+--------- A | -x- (1 row) Bonus It’s possible to choose an emoji as a replacement: ...

I have a new ls replacement! I was using eza (see Eza on Fedora 42 ) for a while, but I’ve found something even better: lsd. This tool is a nice because it displays icons for file types, making it so much easier to navigate files directories. The default settings are great, but the date format mm/dd/yyyy is a bit odd. Changing this is the only modification needed to make the tool perfect. ...

In my previous post, I wrote about using Eza on Fedora 41, which works well and it can be installed via dnf. This week, I upgraded my main computer to Fedora 42 and noticed that the Eza package is no longer available and couldn’t be installed using dnf. I looked into the rust-eza and discovered that the maintainer has orphaned it due to time constrains. To keep using Eza, I downloaded the latest release from the project’s Github page, and installed the binary directly to the /usr/local/bin ...

Eza is a modern replacement for ls, it’s written in Rust, small, fast and just a single binary. How to replace in Fedora with Fish Shell sudo dnf install eza alias --save ls eza Done!

I often have to merge data from different tables in PostgreSQL, this is a code snippet I use: MERGE INTO users u USING new_users n ON u.user_uuid = n.user_uuid WHEN NOT MATCHED THEN INSERT VALUES (n.user_uuid, n.first_name, n.last_name) WHEN MATCHED THEN UPDATE SET first_name = n.first_name, last_name = n.last_name RETURNING u.*;

I’ve streamlined my blogging process using Hugo by automating tasks with the Fish Shell. I created a simple script that saves me a few minutes each time I write a new post. It automatically starts a new Hugo post and opens it in Helix editor, allowing me to write, save, and publish with ease. File name: new_til.fish function new_til -d "Create a new Today I learned post on Hugo" set blog_path ~/sites/blog set date_str (date +%Y-%m-%d) cd $blog_path hugo new til/$date_str-$argv[1].md hx content/til/$date_str-$argv[1].md end Just save the script into ~./config/fish/functions and to start a new Today I Learned post, just type $ new_til post_title

This is a short snippet to run PostgreSQL using Podman with a volume. The snippet has been tested on Fedora 41. Create the Podman volume $ podman volume create psqldevel Run PostgreSQL $ podman run -d -p 5432:5432 -v psqldevel:/var/lib/postgresql/data -e POSTGRES_PASSWORD=xx --name psqldevel postgres:latest

As I continue to explore the world of Data Engineer, Linux, Fedora and other intersting topics, I often find small but interesting topics, that don’t deserve a full blog post, but I don’t want to let these discoveries to go away. In this section, I’ll be documenting and sharing short snippets of knowledge, tips and tricks that I’ve learned along the way. These posts will be bite-sized, easy to digest and hopefully, useful to others who may be on a similar journey.