From Google Sheets you can add an “App Script” from the “Extensions” menu. This will allow you to do a few things, such as code and test an App Script. Here we most importantly need a way to sync some rows from a sheet that we can consider as events…
Let’s say you need a handful of users for testing out multiple SFTP accounts. Additionally, you do not want the users to be able to login via SSH and you want everything else about the users to be identical (ie, password, content of home directory, etc). The following script will…
Let’s say you have a JSON file and in it is an array of values. Each value has a few properties you need to pick from to ultimately create a file name. Here is an example using bash, jq, in2csv and xargs that can be strung together in one line…
The previous version of Unique Bird Feeder From Upcycled Used Military Ammo Box was allowing to much water into the openings I cut out. Despite drilling small drain holes in the bottom it seems like the water was causing the bird seed to get spoiled or moldy. Since magnets work…
Let’s say you encounter a situation where you have a Map of Maps where the nested Map has a value of Object. These were the cards I was dealt while refactoring a bit of code recently. This case may be a bit too generic and likely warrants a more specific…
If you use a pool cover over the winter, you likely watch it fill up with water and snow as the season goes by. You should take care to drain this water off the cover once in a while. Of course, there are countless ways to drain the water, such…
Let’s say you want iterate over a series of sequential numbers with Bash. If so, then you could do the following: Now, let’s say you want to loop over a sequence of numbers, but you want to skip over by 10 each time: Supposedly, this syntax should work, but it…
I was looking to make a simple low-cost, but unique bird feeder from an ammo box. Some of the reasons for using an ammo box include that it is watertight, will hold a large amount of birdseed, and will be long-lasting due to being made of metal. Also, it is…
Many website hosting services provide a tool to manage your websites via CPanel. Normally, your website hosting company will also provide cheap or free database hosting for MySQL. One such example is the award-winning hosting company DailyRazor. Create MySQL Database via CPanel CPanel makes it very easy to create a…
Let’s say you are using Spring Data and you have a “Composite Key” (ie, a tuple or EmbeddedId). Generally, you may want to query by the whole composite key (ie, by ID), which is generally fairly straightforward with a JPA “query method” (still not sure that is the official name)….