There are two kinds of pipes in Linux: named and unnamed. Here's a detailed look at pipe redirection.| Linux Handbook
Redirection is an essential concept in Linux. Learn how to use stdin, stdout, stderr and pipe redirection in Linux command line.| Linux Handbook
No more headache with copy-pasting huge plans from psql to explain.dalibo.com and explain.depesz.com|
Have an index idea for a large table? Get a sneak peek of how SQL plan will look like using Joe's new command, "hypo", that provides support of hypothetical indexes|
Postgres.ai team is proud to present version 0.5.0 of Joe bot, an SQL query optimization assistant|
On 29th of July 2025, David Rowley committed patch:| select * from depesz;
This Linux Basics guide teaches you everything important associated with UID in Linux.| Linux Handbook
You see an s instead of x in the file permissions? Linux has some special file permissions called SUID, GUID and Sticky Bit. Know more about them.| Linux Handbook
What is the difference between useradd and adduser commands in Linux? Which one is better and which one should you be using. This article answers all these questions.| Linux Handbook
One of the special device files in Linux, /dev/zero is used for creating files filled with zeroes.| Linux Handbook
Both /dev/random and /dev/urandom are used for generating random numbers in Linux. Learn more about them.| Linux Handbook
What is AUR in Arch Linux? How do I use AUR? Is it safe to use? This article explains it all.| It's FOSS
That’s that. I’ll leave this website up, if for no other reason than to annoy…| Shoot Film, Ride Steel
Contax? On my Leica?| Shoot Film, Ride Steel
Work took most of my time the last few months, but personal projects are moving to fruition.| Shoot Film, Ride Steel
It’s film price update time! Every so often I’ll run these numbers to see what has changed. If you have a hypothesis, you have to experiment to verify it, and then you have to repeat it to see if it stands up. Or so some science prof told me once a long time ago.| Shoot Film, Ride Steel
/dev/null is the blackhole equivalent of Linux systems. What is it and why it used?| Linux Handbook
This detailed tutorial tells you what are symbolic links, how to create a symbolic links and other important things associated with symlinks.| Linux Handbook
Linux file permissions explained in simpler terms. Also learn how to change the file permissions and ownership in Linux in this detailed beginner's guide.| Linux Handbook
What is inode in Linux? What is it used for? Why is it important and how to check inode in Linux? This guide explains all the important aspects of inodes.| Linux Handbook
Let's see what are the various kinds of file timestamps in Linux, how to see the timestamps for a file and how to change the timestamps.| Linux Handbook
This tutorial explains the Linux directory structure. You'll learn the Linux filesystem hierarchy along with the purpose of the various directories on a Linux system.| Linux Handbook
On 21st of February 2025, Robert Haas committed patch:| select * from depesz;
A look into the structure and abstract machines of intermediate languages, with examples in stack-based and register-based machines.| Musing Mortoray
Learn the concept of hard links in Linux and its association with inodes in this tutorial.| Linux Handbook
In this essential Linux learning chapter, know about the relative and absolute paths in Linux. What's the difference between them and which one should you use.| Linux Handbook
On 11st of December 2024, David Rowley committed patch:| select * from depesz;
Holidays are odd times, this one especially so. This morning the power of an image has me thinking. Here's to a better, brighter year to come.| Shoot Film, Ride Steel
There are too many ways to represent unknown or missing data and this can lead to defects.| Musing Mortoray
The form a compiler producers before it emits machine code or runs on a virtual machine| Musing Mortoray
These are some of the best software demo videos around, along with commentary on what makes each of them so effective, memorable, and unique. Get inspired!| Wyzowl
We’ve compiled 20 of the best product demo videos out there so you can gather some inspiration and make your video one of the best yet!| Wyzowl
Looking for the right tracks for your film, explainer video, app or video game? We’ve compiled this guide to the 20 best royalty free music sites in 2024.| Wyzowl
Case study videos help to increase trust and can ultimately result in more sales for your business. Here’s how to make one in 10 simple steps.| Wyzowl
With so many great (and not so great) video editing apps vying for your attention, we’ve curated the 24 best ones available for Android, iPhone and iPad.| Wyzowl
Do you ever feel like our attention spans are getting shorter? New research has revealed that human beings are, indeed, flakier than ever before!| Wyzowl
Grep is perhaps one of the most used commands in Linux. Learn why it was created and how it s used in this explainer article.| Linux Handbook