PythonInstall Python Packages Without Root Permissions with VirtualEnvOne great aspect of Python is that its available in all major distributions of Linux. Another awesome aspect is the plethora of packages…
Creating a Rest API Effortlessly with Spring Rest RepositoriesIf you have been swayed away from Java since web frameworks like Django, Rails, Sinatra, and Flask started popping up to fulfil your Restful…
VBAExport Microsoft Access Data to ExcelFor this example, we will be using a simple table with a list of beer names. Our goal is to export the contents of this table into an Excel…
VBAExport Microsoft Access Data to ExcelFor this example, we will be using a simple table with a list of beer names. Our goal is to export the contents of this table into an Excel…
VBAAdd a File Selection Dialog To Your VBA CodeThere are times in Microsoft Excel or Access when you may require user input regarding the location of a file. For example, you may need to…
PythonCounting Instances of String in Multiple Files Using PythonThis morning I came across a task which required me to count all instances of a particular element within multiple XML files in a directory…
AntBasics of Apache AntWhile build tools like Maven and Gradle are the dominant choices for many Java developers today, I would argue that sometimes the best…
Teaching My Girls to CodeAs the proud father of two incredible girls, I’ve been anxiously waiting for the right time to introduce them to programming. Today was…
GhostListing Tags on Home Page in Ghost CMS 1.0As a disclaimer, this feature utilizes the experimental Ghost public API. The public API allows access to your blog’s public data, such as…
.NET CoreConnecting to a Sqlite Database using .Net CoreRequirements In order to follow along with this post, you will need: .Net Core SDK (version 3.1.0 used here, but example should work for any…
Java 8 Lambdas - Syntactic Sugar for InterfacesAll About Assigning Function Definitions To Variables While languages such as Python support using functions as a type, Java must work…
WeblogicProgrammatically Deleting Messages from Queue in WeblogicAlthough I found many examples of this online, none of them were complete enough to “just work” for me with Weblogic. The snippet below is…
PythonBasic REST API Using Flask and MySQL - GETThe example below returns not only the results as JSON, but also conveniently includes the database table’s column names in the result. The…
GitGIT Remote Server SetupThis should work on any remote server with ssh enabled. I specifically use it on my Synology NAS (with GIT application installed).…
DockerDocker Basics1. Install (Ubuntu 16.04) For other distributions/OSes: Official Installation Instructions 2. Download Image List Installed Images 3. Create…
DockerDocker Cross Container CommunicationDocker allows communications between containers, provided the container’s port is exposed. The example below creates an NGINX container…
DockerBasic Flask API with Docker1. Create Flask File ./apy.py 2. Create pip requirements.txt File ./requirements.txt 3. Create Dockerfile ./Dockerfile 4. Create Image…
DockerRun Docker without SUDOBy default, Docker requires sudo privileges to run. In order to execute commands without prepending “sudo” every time, simply run the two…
ruby on railsSuper Easy REST API Creation with Rails 5Without a doubt, my favorite feature of Ruby on Rails is scaffolding. With a single command, one can create the controller, model, and…
DockerDocker Master ResetUse With Caution! The following command does the following (in order): Stop all containers Delete all containers Delete all images Delete…
PythonPython snake_case to CamelCase and hungarianI have recently been working on a Flask application, and needed a systematic way to convert the snake case (underscored) column names being…
DockerDocker Wordpress SetupSince the Docker Wordpress image does not contain its own copy of MySQL, the setup requires a few more steps than most other containers…
letsencryptGenerate Let's Encrypt Cert For Your Domain Without Root PrivilegesIt was not too long ago when anyone wanting SSL/TLS for their domain would need to pay a cert authority (CA) for something which today we…
Spring BootUsing Spring Boot with Visual Studio CodeIf you have not yet tried Visual Studio Code, I highly recommend that you do. This lightweight editor created by Microsoft is quickly…
kotlinBasic Read and Write Excel Using KotlinThis post is a very simple example of reading and writing to Excel using Kotlin. Thanks to its Java interoperability, we can utilize the…
Creating a Rest API Effortlessly with Spring Rest Repositories - Kotlin Edition!I’ve been recently experimenting with Kotlin, and I am absolutely hooked. Its concise syntax and fix of most Java “annoyances” makes it the…
mavenFilter Results of Maven Archetype:GenerateOne of my favorite features of Maven is being able to utilize archetypes to provide me with a starting point for my projects. As most…
ruby on railsResolving Missing Rails Executable After Gem InstallAfter a fresh install of Rails using Gem recently, I was surprised to see the following message: After rebooting just to make sure, the…
Git Basicsinitialize some required globals: Open Git Bash: Will create keys in ~/.ssh: Open id_rsa.pub (public key) and paste contents into https…