Relational databases are built on the concept of entities and their relationships to each other. From time to time the relationship between tables is a Table1 < N – N> Table2 or table 1 data relates to table2 data in a non unique form. In this case a bridging table

Given the prompt of some amount less than the smallest bill available calculate the remaining coins to distribute. This is also ok for bill amounts as well if you wanted to reuse it. This is also how you would do pagination as well as it is the first pass of

A moving average is a calculation using a subset of a larger set that is index centered and bounded by a N adjacent values. For example say you have the following values date_time stock_price 2023-08-08 13 2023-08-09 18 2023-08-10 10 2023-08-11 10 2023-08-12 8 2023-08-13 2 2023-08-14 6

C# * Classic recursive public static int CalculateFactorialRecursive(int number) { return number == 0 ? 1 : number * CalculateFactorialRecursive(number - 1); } * Iterative public static int CalculateFactorial(int number) { return number == 0 ? 1 : Enumerable.Range(1, number).Aggregate(1, (current, i) => current * i); } Python def calculate_factorial(input_number: int, recursive: bool = False)

Need to make a ParallelForEachAsync that works independently and runs in C#, inspiration from JavaScript way to handle async/await is like so async function Promise1() { throw "Failure!"; } async function Promise2() { return "Success!"; } const [Promise1Result, Promise2Result] = await Promise.allSettled([Promise1(), Promise2()]); console.log(Promise1Result); // {status: "

Passing functions as arguments to other JavaScript functions or creating higher order functions is something you may want to do or even be encouraged to do. JavaScript is notorious for callback hell, but I would like to demonstrate the situation with respect to async function parameter passing. Synchronous Steps Take

Push text into the clipboard. Use the following function async function copyToClipboard(text) { try { await navigator.clipboard.writeText(text); } catch (error) { console.error(error.message); } } copyToClipboard("Text injected to clipboard"); The embedded script will request permission to write to your clipboard like so You will need to allow

HTML was originally created to work from a distributed network with documents moving and editing across that network. This key concept slowly has evaporated from public consciousness that every view from the a HTML page has a Document Object Model underlying it. Key point to focus here is the Document

Doing a convert a line of text into a 2 dimensional array choice.  In this case I will show the answers in C# and Python Given the problem Convert this line input "5.0,100,5.5,99,6.0,101:L10;5.0,18,5.5,98,6.

Google Vacation Rentals has proposed a linked data JSON format to setup properties for search indexing across their various platforms: search engine, maps, etc. The details of the format are below Vacation Rental Schema Markup | Google Search Central | Documentation | Google for DevelopersVacation listing structured data can help people find your

Wrote the following as an email (anonymized names) to Cornelius (supervisor) to advocate for Portia (worker in question) to get better hardware to perform her work tasks better and faster. She did get the improved hardware and was able to perform her work tasks with marked efficiency and improvement. Hello

Suppose you are given the following string to parse out as a mathematical operation in postfix notation 3 4 + 5 6 + * to parse out That is in normal infix notation (3 + 4) * (5 + 6). Therefore the answer for both should be 77 To do this you should create a stack

Doing some zen like programming tasks by patching together utilities and pipes for a task of taking a GeoJSON dataset and finding all the elements of a particular county. Example data set format { "type": "FeatureCollection", "name": "Weather_Stations", "crs": { "

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