code - Empty Space

Cascading Style Sheets Spinner

MySql Common Table Expression with Coalesce

Previously I wrote here about MySql recursive Common Table Expressions CTE However now I want to do a summation against available records with COALESCE functionality to find unpaid bookings and then join that against users and this is a simplified query of what I needed Table assumptions Given the following

code

Parameterized PowerShell API test script

Need to test an XML API that uses basic authorization. Created this script with the assumption you have real cURL installed and to allow for automated parameterization of the script output. param ($externalId, $inputBaseUrl, $inputUser, $inputApiKey) function formatXml([string]$xmlcontent) { $xmldoc = new-object -typename system.xml.xmldocument $xmldoc.loadxml($xmlcontent) $sw

code

Map Image Share Prototype

Created this map image sharing prototype source here using various technologies Components used * Nodejs (Hapijs framework): To handle the uploads and reading of data * DataStore (AirTable spreadsheet): Picked this option because AirTable has numerous options with images, graphics, and sharing * Map (Mapbox) * Digital Ocean file storage (S3 compatible library): This

code

Altering href anchor links targets

Working through an issue where the data contents of the HTML has href anchor links that are not consistently target to open in a blank window. The reason to do this is that the original HTML content is web view of an email, therefore having it follow links instead of

code

Show more options Windows 11

Windows 11 hides the full right click context menu by default and if you want to get the properties of a file (something I am constantly doing) you need to click Show more Options which turns into 2 clicks. I hate it. Along with the locking of the taskbar to

code

PowerShell Script Grab Random Pet Picture

Need to grab a random picture for validation inputs from the command line. This script will pull down a random pet picture (cat/dog) $second = (Get-Date).Second $url = "" if (((($second /2) - [math]::Truncate($second / 2)) * 10) -eq 5) { $url = (Invoke-WebRequest "https://api.thecatapi.com/v1/images/

code

Create local DynamoDB Service

Need to create a local DynamoDB service within Ubuntu on Windows Subsystem for Linux 2 Setup the latest Java Runtime Environment for your distribution 1. java -version Command 'java' not found, but can be installed with: sudo apt install openjdk-11-jre-headless # version 11.0.20.1+1-0ubuntu1~22.04,

code

Visual Studio 2022 .vsconfig settings

Posting my Visual Studio .vsconfig settings, (I use jetBrains Rider). I do not normally use Visual Studio, so this is for reference and backup, { "version": "1.0", "components": [ "Microsoft.VisualStudio.Component.CoreEditor", "Microsoft.VisualStudio.Workload.CoreEditor", "Microsoft.Net.Component.

code

Disable MySql Foreign Key Checks Temporarily

Fighting with numerous tables in MySql and all I want to do is clear a few records, but the foreign key checks are preventing deletes. Disable the foreign key checks temporarily to get around this to fix this SET FOREIGN_KEY_CHECKS = 0; delete from |ChildTable| where |ParentTableId| > |LastInsertId|

code

Unicode character as Favicon

Trying to create a minimal external dependency webpage and for the favicon, I found you can set a Unicode character as your favicon (some restrictions apply) First pick a standard Unicode character and make sure it is valid. I at first tried to a comet character, but the rendered component

code

Google Sheets Highlight Row

I wanted to make a row obviously highlighted and time sensitive as it was part of a on-call rotation so prominence in stressful situations is of paramount importance. Steps * Highlight all cells in the Google sheet. * Create a custom formula with the highlighting of your choice * Put this formula as

code

MapBox Map Starter Template

Creating a web map item and was using MapBox and decided to create a basic template for working with MapBox+JavaScript+HTML and came up with this <!DOCTYPE html> <html> <head> <title>Map Test</title> <style> .mapboxgl-popup { max-width:

code

MySql Trim DateTimes

Time portions of datetimes from time to time get inserted or updated into database columns that are intended to be purely date only. The TIME and MAKETIME functions can fix this, with for example you have a database table with two date columns {Arrival, Departure} UPDATE TargetTable set Arrival = DATE(

code

Fetch Direct Examples

Fetch examples for various situations that have come up Post: File data as form data (async/await) <script> async function extractZipFile(zipFile) { try { const formData = new FormData(); formData.append("upload_file", zipFile); const response = await fetch(`https://<taregt_url>/extract_details`, { method: "POST&

code

MySql JSON Encoded Column Notes

Need to extract a search against a JSON encoded column in MySql and then update from one JSON property to another in that encoded column (TargetTable.RelatedItems) JsonSourceProperty -> TargetProperty SELECT JSON_SET(RelatedItems, '$.JsonTargetProperty', JSON_EXTRACT(RelatedItems, '$.JsonSourceProperty')) FROM TargetTable; SELECT JSON_EXTRACT(RelatedItems,

code

GitHub automatically create + publish Docker workflow guide

If you have a working Dockerfile defined in your GitHub repository means that you can automatically create and publish your Docker image for others to use and view from the repo. At first I used DockerHub from Docker, but do to changes in their policies there are now size restrictions

code

Playwright Scraping a Website

Previously I documented using Puppeteer to scrape a website, but this doesn't work well with Pipedream (it times out unexpectedly because of Pipedream limitations) Therefore a better solution I have come up with is to create a FastAPI Dockerified version using Playwright instead to do the same thing.

code

MySql Recursive Common Table Expressions (CTE)

Working with a thorny denormalized table that contains id references to itself in a Parent column that indicates a tree hierarchical structure and had to bring out the recursvie Common Table Expressions (CTE) Simplified table example create table TaskLookup ( Id int unsigned auto_increment primary key, ParentId int unsigned, Body

code

The 5 Stages of Software Development

* Shock and Denial ⛔ I don't believe this will work, We won't build this ⛔ * Anger 😡 Why is everything broken! 😡 * Bargaining 🙏 I can make this work somehow if I keep trying 🙏 * Depression 😭I can't make this work no matter what I try 😭 * Acceptance 😔 This is my

code

JavaScript async/await warnings

TLDR; NEVER EVER EVER USE map, filter, reduce with async/await Frustrated over why a segment of code was not working which looked like this Example const results = inputs.map(async z => { return { id: getId(z), result: await sendId(z) } }); The structure and formatting is correct and you would

code

NPM node validate expected version

Use package.json and add the lines { ... "scripts": { "start": "node index.js", "test": "lab tests/api.tests.js", "preinstall": "node checkNodeVersion" }, "engines": { "node": ">=20", "npm": "^10&

code

Webhook debugging with ngrok

There are several tools to reroute external webhook urls to local dev. Ngrok is one of the easier options and works with multiple host header files locally with some commands. There are alternatives like localtunnel * Sign up for a free ngrok account * Download the mechanism you wish to run ngrok

code

Recursive CTE (Sqlite) for generate_series substitute

In large modern databases you usually have a function available called generate_series that is useful for creating an inline series numbers, dates, etc Example SELECT * FROM generate_series(2,4); Produces the results of generate_series ----------------- 2 3 4 You can also combine this with dates and date

code

Command line zip and submit to an API

Expanding on automating sending data and getting results from the FastAPI I wrote here, that is deployed here. Tied some command line processing tools together to build out a nice script automation one liner (a long line, but still works) to achieve the goal of zip up a set of