Oracle Random Data Generation Guide This guide explains how to generate random data in Oracle using PL/SQL. It includes: A reusable function generate_random_data for creating random values. A...

SQL Pagination with Materialized View and Pipelined Table Function in Oracle Overview This guide explains how to implement snapshot-based pagination in Oracle using: A Materialized View (MV) to...

Using Github Actions for Deployments Setup Github Actions for Deployment Action to deploy PRs made against main branch (in my case Development). Action to deploy to QA, Production, etc. after t...

Homelab Series - Bootstrap Objectives for this Homelab Series: Lay out an easy to follow guide to setup a homelab, with repeatable and scripted actions where possible. The homelab repo on githu...

Rainbow CSV with queries My tool of choice for big-but-not-too-big text files that need viewing and maybe a bit of filtering is Rainbow CSV extension in VS Code. This works well as long as the fil...

Pandas vs Rainbow Query Language My tool of choice for “big” text files that need viewing and maybe a bit of filtering is Rainbow CSV extension in VS Code, and writing some quick queries with its...

Portainer Deployment Options Two different approaches on how to deploy Portainer, and Docker containers within Portainer. Option 1: Ansible I’m a big fan of ansible, and try to build all my infra...

Keepalive Configurations Keepalive install sudo apt install keepalived libipset13 Configuration for High Availability Configuration should be done on the two nodes, setting one as master and one ...

Restore Repository using a Git Mirror If you followed the guide on setting up a mirror as a real-time backup, you may now be wondering how can I restore a lost or corrupt repository using the mirr...

Mirror a Gitlab repository to Github Git repository mirrors can be useful to create a real-time copy of a repository for backup purposes, or as a transitional step when moving from one git platfor...