Time to expand on my previous post. If you are going to do synchronous standups, which you should think about what is this achieving that is not available from a written format and how will you differentiate it from a status meeting. I will summarize the original purpose of the

What are the goals of code review? This is to me a subjective question. In my opinion they are the following. * Finding missing conceptual issues * Shared understanding of the system * Identification for future enhancements that will be documented or exist in the reviewer/reviewee common framework * A desirable goal is

Need to change the text of nested HTML element with specific class names and thought this was a good use of document.querySelector. This way I can use CSS type selectors to find the element and then modify the text as needed Example: I have the following <div class=

Happy Times

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

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

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

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

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

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/

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,

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.

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|

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

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

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:

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(

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&

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,

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

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.

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

* 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

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