theCodingInterface

theCodingInterface

Providing quality software engineering content in the form of tutorials, applications, services, and commentary suited for developers.

Developer's Guide to PostgreSQL on Linux: Changing the Default Data Directory

PostgreSQL

In this fifth article demonstrates how to change the default data directory of a PostgreSQL database cluster running on the Linux Ubuntu 18 LTS and Centos 7 operating systems. This article shifts focus to improving the scalability, robustness and, performance made possible by moving the data directory to it's own area of the file system. Isolating the data directory also reduces file access contention with other OS activities and allows for easier resizing.

Read more
By Adam McQuistan on 10/06/2019
psql PostgreSQL Databases CentOS Ubuntu Linux

Developer's Guide to PostgreSQL on Linux: Creating Accounts and Making Connections

PostgreSQL

This is the third article of a series featuring a collection of useful tasks for administering PostgreSQL on the Linux operating systems Ubuntu 18 LTS as well as CentOS 7. For those unfamiliar, PostgreSQL is a powerful and robust Object Relational Database which is freely available as open source software and widely popular. In this article I cover how to create user accounts and establish connections with these accounts.

Read more
By Adam McQuistan on 10/05/2019
psql PostgreSQL Databases CentOS Ubuntu Linux

Developer's Guide to PostgreSQL on Linux: Creating Databases

PostgreSQL

This is the third article of a series featuring a collection of useful tasks for administering PostgreSQL on the Linux operating systems Ubuntu 18 LTS as well as CentOS 7. For those unfamiliar, PostgreSQL is a powerful and robust Object Relational Database which is freely available as open source software and widely popular. In this article I show how to create databases using both SQL statements along with the createdb utility program.

Read more
By Adam McQuistan on 09/30/2019
psql PostgreSQL Databases

Developer's Guide to PostgreSQL on Linux: psql shell

PostgreSQL

This is the second article of a series featuring a collection of useful tasks for administering PostgreSQL version 11 on the Linux operating systems Ubuntu 18 LTS as well as CentOS 7. For those unfamiliar, PostgreSQL is a powerful and robust Object Relational Database which is freely available as open source software and widely popular. In this article I introduce the psql interactive shell using the default postgres user.

Read more
By Adam McQuistan on 09/29/2019
psql PostgreSQL Databases Linux

Developer's Guide to PostgreSQL on Linux: Installation

PostgreSQL

This is the first article of a series featuring a collection of useful tasks for administering PostgreSQL on the Linux operating systems Ubuntu 18 LTS as well as CentOS 7. PostgreSQL is a powerful and robust Object Relational Database which is freely available as open source software and widely popular. In this article I cover how to install and initialize the PostgreSQL database cluster. I also cover the key configuration files as well as their purpose.

Read more
By Adam McQuistan on 09/27/2019
PostgreSQL Databases CentOS Ubuntu Linux

Updating Linux GNU Tar from Source on CentOS

Linux

I was recently tasked with migrating a GitLab instance from one ContOS Linux server to another which required creating a backup of the existing system via the gitlab-backup CLI utility. When I read the GitLab docs on creating backups I learned that gitlab-backup requires at least a version of 1.3 for GNU Tar. As of this writing it turns out this is not possible using the yum package manager so, in this article I walk you through how to upgrade the tar compression utiltity from source.

Read more
By Adam McQuistan on 09/26/2019
CentOS Linux

Text Operations in Java using String, StringBuilder and StringJoiner

Java

In this article go through some fundamental Java techniques to work with textual data via the String, StringBuilder and StringJoiner classes. My use "text" is deliberate when referring the the type of data because I want to make clear when I'm talking about a kind a data (data as a sequence of char primitives) as opposed to the String class which is an abstraction of text data as strings.

Read more
By Adam McQuistan on 09/19/2019
Java

Navigation

theCodingInterface