System Code Geeks Operating System Developers Resource Center

Here at System Code Geeks we know how much you love books about system administration; we are geeks ourselves. After all, a geek that respects himself should always have his face in a book, he has to keep up with the latest technologies and developments. For this reason, we have decided to distribute 6 of our books for free. You ...

In the category of “niche blogposts”, this is probably the “nichest”. But it might be useful, so I’ll share it. Recently I had to interface an IBM i system (think “mainframe”, though not exactly) from a command-line-only Linux environment. The interesting part is that you can access the IBM i files through SQL syntax, as they are tabular in nature. ...

I decided to up my command line game, so this a ‘remember how to do stuff‘ post for me. I do acknowledge that there are tons of different ways on doing things, especially when you have to deal with the command line. So don’t shoot the pianist. Step 0: I do use brewUse brew to manage a lot of command ...

Hello guys, today, I am going to share one of the useful tips to find out how long a particular process is running in Linux. This is very useful while you are troubleshooting an issue and want to know whether your process or service is restarted fine on a daily or weekly basis. So you checked your process is running ...

The command-line based “PostgreSQL interactive terminal” known as psql is handy for manipulating and accessing data in a PostgreSQL database. Because of its command-line nature, psql is particularly well suited for use in scripts. One of the psql features that makes it even more useful in scripting contexts is its support for “meta-commands”. As the psql documentation states, “Anything you ...

It is easy for someone who is new to PostgreSQL and who uses PostgreSQL’s terminal editor psql to confuse the commands \set and SET. This post contrasts these commands and provides a brief overview of other commands that include the word “set”. The easiest way to remember how to differentiate \set from SET is to keep in mind that the ...

During the last four years, until the early part of 2018, I worked on a MacBook. Sometime in the second quarter of last year, I shifted to a Windows 10 laptop. The transition has been quite smooth and delightful. There were two Rails applications that I had to write and maintain. The first application, let’s call it webapp-1, was coded ...

PostgreSQL‘s psql interactive terminal tool provides several useful “backslash list commands” such as \d (lists “relations” such as tables, views, indexes, and sequences), \dt (lists tables), \di (lists indexes), \ds (lists sequences), \dv (lists views), \df (lists functions), \du (lists roles), and \? (displays help/usage details on backslash commands). These commands are concise and much simpler to use than writing ...

In a previous tutorial, we talked about expect command and we saw how to automate scripts in Linux using its scripting language. Today, we will take a step further in our automation techniques and talk about a tool that automates tasks more professionally and for different platforms, this tool is Ansible. We will also talk about some Ansible features such ...

Here some git related functions in my .bachrc. Is mostly a backup for me, but it might also be useful for someone else. Cloning a git repo Because I usually clone repos from my github account, this is a shortcut that allows me to just type clone *repo_name* and it will create the URL. function clone { if [ $# ...