Providing quality software engineering content in the form of tutorials, applications, services, and commentary suited for developers.
In this How To tutorial I demonstrate how to perform file storage management with AWS S3 using Python's boto3 AWS library.
In this How To article I discuss and demonstrate techniques for sorting Python collections (lists, dictionaries, tuples) in simple to moderate use cases.
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.
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.
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.
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.