John Pili - Software Developer, Blogger and an aspiring Entrepreneur.

I have a LUKS encrypted volume that I only need from time to time.

Accessing psql sudo -i -u postgres psql Create a new database and user Create a new user: CREATE USER theusername WITH PASSWORD 'thepassword'; Create a new database: CREATE DATABASE thedatabase; Grant privileges: GRANT ALL PRIVILEGES ON DATABASE th…

In this code snippet, I would like to run an application with a URL payload based on date and time.

Use OpenSSL generate a self-signed certificate for Golang.

Use Linux diff command to compare files line by line.

Creating or cloning a Repository git init Initializes a new Git repository in the current directory git clone https://git[.]johnpili[.]com/path/to/repo.git Clones a repository using HTTPS protocol from a remote location git clone ssh://git[.]johnpili[.]co…

Let’s say you have an existing Microsoft SQL data and want to move it to a different disk or directory.

Delete files with specified file extension recursively.

You can use Unix Domain Socket aka AF_UNIX for your interprocess communication.

I am developing a repository as a service application.

Background I would like to share my experience using Vue 2 without a build step in my project and the key factors behind this approach.

Use http.MaxBytesReader to limit and control the size of the HTTP request body.

If you prefer to boot up your Linux machine with the boot messages rather than the distro splash screen.

Let’s start a React project without using create-react-app (CRA).

A sound bite from The Pragmatic Programmer: Your Journey To Mastery, 20th Anniversary Edition (2nd Edition) Interested?

Reduce SSH brute force attacks by changing your default SSH server (sshd) port from port 22 to a different one.

Some Linux servers were security hardened by changing the default SSH port from port 22 to a different port number.

Google’s reCAPTCHA is one of the tool we can use to stop malicious internet bots from abusing our web applications.

The go:embed feature was introduce in Go 1.16.

I am backing-up a large number of files to another computer when this idea came to me to write a Python script that generate and validate batch MD5 checksum.

Do you want to rename a number of files that begins with a specific name or string?

I was creating an Active Directory (AD) security auditing tool in Go and Python when I stumbled upon the UserAccountControl flags.

If your SSH connection to your Raspberry Pi is freezing or unstable, it could be because of OpenSSH TOS (Type of Service).

Setting up a static IP address in Debian Linux is straightforward.

In some situation, we may want to delegate a sudo capability to Linux users or groups without completely giving them full access to the operating system.

I would like to share the Golang’s build flag to remove the source path (GOPATH) from panic stack trace output.

In this blog post, I’ll share how to generate text to image in Go programming language (Golang).

Systemd is a Linux software suite that handles system services (daemon) and timers; it enables you to start, stop and restart your application using systemctl command.

Systemd is a Linux software suite that handles system services (daemon) and timers; it enables you to start, stop and restart your application using systemctl command.

Setting up a static IP address in your RHEL or CentOS is straightforward.

In some MySQL installation in Ubuntu.

Let say that you wanted to create a MySQL user for example johnpili and assign privileges.

You may need to setup an SSH keys or environment variables to your Jenkins installations.

You build your first Golang web application and running in a remote server via SSH.

To randomly create a time.Sleep in Golang you can use the code snippet below.

In response to this facebook post.

Suppose you want to retrieve a list of products that are not in promotion.

Do you ever wanted to have an HTML drop-down with default selected value (placeholder) that the user cannot re-select once they selected any valid value options?

I was building a multi-module project and I faced with this annoying problem with maven that keeps using old version of the maven project even though I uses mvn install -U.

You can easily create an Android Studio shortcut by creating an desktop entry using the following the steps below.

Did you enabled the full disk encryption (LUKS) on Ubuntu 18.04?

Revive your old laptop back in service using Lubuntu a light-weight version of Ubuntu.

You may want to completely erase the partition table of your USB flash drive, including the boot record.

Overview I started my homelab journey in 2017, set up a small server to host my files and to test my web applications.

In this post, I will show you a simple example how to use SQLite in Go (Golang).

Today, I will show you how you can generate image and add text using Python.

In this post I will show you how to access Windows Shared folders from Ubuntu Linux.

In this guide I will teach you how to create a bootable Ubuntu USB on macOS with UNetbootin.

I saw neofetch on reddit.

Part of my work is to screen record (screencast): software demos and programming tutorial.