Working through a python example and presented with the problem Write a one-line Python generator or iterator expression that returns the infinite sequence of increasing integers generated by repeatedly adding the ascii values of each letter in the word “Close” to itself. 67, 175, 286, 401, 502, 569, 677, 788,

The title is controversial, but if you think about it is true. Using a common refrain I have observed that a segment of software is experiencing scope creep, as in this is taking longer because what it means is not comprehensive or complete with respect to the end goal. Baseline

Ran into the need to recursively flatten a JavaScript object and came up with this function flatten(obj, prefix = '') { return Object.keys(obj).reduce((results, z) => { const currentPrefix = prefix.length ? prefix + '_' : ''; if (typeof obj[z] === 'object' && obj[z] !== null)

JavaScript objects can have numerous levels of properties that are set to null and posting them through fetch requests can lead to strange behavior if you are not checking for nulls. Why not clear out those fields? Function * Take the current object and check if is is coalesced loosely to

Trying to add a new unique key to a table and on of the fields allows nulls and there are already duplicate records that need to be adjusted now. This is the perfect case for using row_number to order the ids Here is an example table create table LocationApplicability

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(