The following docker-compose.yml file setups a local WordPress docker instance alongside a MySql server and an Adminer web app which can be used as an alternative to PhpMyAdmin. version: '3.9' services: wp_mysql: image: mysql:latest container_name: wp_mysql command: mysqld --character-set...
How to create your own reverse geocoding API using OpenStreetMap Docker, Osimium and Nominatim
During my master’s at the University of Twente and for the course Managing Big Data, I worked with three other students on a very interesting project in the field of big data. We measured global internet speed and latency changes between 2019 and 2022 (Covid period). The dataset we used for...
How to let Avada Post Cards element fetch posts from the database based on a value of a custom field in the posts
Context In the last couple of months, I have been working on the website of Stichting Civic. Stichting Civic is a Dutch foundation committed to improving the Dutch civic integration policy for refugees and other newcomers. The foundation aims at 1) collecting and stimulating socio-scientific and...
A fully automated Filezilla installer bash-script on Ubuntu Linux 20.04
Almost five years ago, I wrote this blog post Making an installer/updater for Filezilla on Ubuntu Linux Today in this blog post, I present a fully automated bash script based on my earlier script. This script automatically pulls the latest version of FileZilla tarball from Filezilla project website...
How to change the prefix of WordPress database tables using MySql in phpMyAdmin
In this article you will learn how to change the name of all MySql (WordPress) database tables in one shot to save you time and maybe money too :)
How to use Google Workspace Gmail server alongside other mail server
A step-by-step guide on how to setup a split-delivery to use Google-Workspace email service and your traditional mail service offered by your hosting provider
How to check/uncheck all checkboxes on a web page using vanilla Javascript
A couple of years ago I wrote this short post about checking/selecting all checkboxes on a web page using jQuery. However, how would we do that if we can’t included jQuery on the page or if we want to do it only with Javascript! To uncheck all checked checkboxes on a web page using only...
How to trigger a specific code after a new product is created via WooCommerce REST API
I ran yesterday into a situation where I needed WordPress to perform a specific action after a product is inserted into WooCommerce database using the REST API endpoint POST /wp-json/wc/v3/products I have searched online for a couple of hours and I found multiple solutions, but non of them worked...
How to make Windows the default OS to boot into instead of Ubuntu Linux on a computer with dual-boot
Like many developers, I run Windows 10 alongside Ubuntu 20.04. I use both of them regularly, but I use Windows most of the time since I work with a couple of programs that are only available on Windows. When I boot up my computer, the following screen is being displayed on the monitor. As you can...
How to reduce the size of wp_icl_strings table in my wordpress database
Just like a lot of WordPress users, I use for a client WPML to make the website multilingual. The plugin is a magical plugin, and it enables you to translate everything on your website. To make the translation process more easier for the user, WPML just tracks down every single added string to the...