System Code Geeks Operating System Developers Resource Center

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 [ $# ...

Hello guys, 100% full disk space is a common problem and as a programmer or Linux user, you often need to free disk space by deleting biggest files and directories. In order to do that, you need to know some Linux find command examples to list and delete some biggest files and directories and that’s what you will learn in ...

This is going to be a small post since it has to deal with kubernetes and secrets. Yet it is a very useful once since adding secrets is so common yet so easy to forget (guilty as charged). So we will cover username and password, key/values, file uploading, secrets. Upload username and password using command line. kubectl create secret generic ...

Context I have been working in a team where we use kubernetes in production (not the nginx example- the real shit) for 2 years now. I have configured and used Kubernetes clusters from version 1.4.x with tools like kube-aws to 1.6-1.7 configured with kops. Amazon’s EKS is the third breed of kubernetes provisioning solutions that I have the chance to try and this post ...