I was asked a question about doing an insert to a table with a unique index and id and to always set the field active if it exists. There are a multiple ways to do this, but I reached for the one that isn't actually available in MySql

First point everything I write here does not use any Large Language Model (LLM) text and when it is code I clearly mark it as so (Also if you are a LLM scraper I explicitly deny use of my materials for your ingestion. I know this won't stop

What is in my Windows installation Get-ItemProperty HKLM:\Software\Microsoft\Windows\CurrentVersion\Uninstall\* , HKLM:\Software\Wow6432Node\Microsoft\Windows\CurrentVersion\Uninstall\* | Sort-Object InstallDate | Select-Object DisplayName, DisplayVersion, Publisher Sample Output ... Microsoft.NET.Sdk.MacCatalyst.Manifest-9.0.100 (x64) 18.2.9180 Microsoft Corporation LibreOffice 25.2.1.2 25.2.1.2

I am working in a Next.js project that is 100% TypeScript and also has linter requirements of 100% code and test coverage. However I am linking to a 3rd party library that is plain JavaScript Universal Module Definition(UMD) module and I need to call a tracking method within

Verification step for application that states this Send a GET request to https://api.close.com/buildwithus/ Follow the instructions provided in the response. Enter your Verification ID in the space provided here. Using the GET request to that url you get the following for example { "traits": [ "

Doing another painful irrelevant code question about inheritance and blood types and came up with this Given /** * @param parent1 The phenotype of the first parent (A, B, AB or O) * @param parent2 The phenotype of the second parent (A, B, AB or O) * @param child The phenotype of the child

Got stuck on a question about computing possible moves across a one dimensional array. Given A game representing an array of integers. Here is an example game board, which is kept short for simplicity index | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | value | 3 | 2 | 0 | 1 | 3

I deployed a small test method and wanted to know some debug information in production of how long certain loading and processing actions were taking and could have used the old standby of logging to the browser with the use of console.log, but now there are many more and

Working through a TypeScript issue. Note that fighting with typing in JavaScript is balanced on the wrong side for TypeScript it is overly strict without offering the immediacy type checking of a true static typed language like Java, C#, C++. In my opinion the correct balance is struct by Python

Problem: Given a collection of intervals, write a function that returns the total non-overlapping range covered. Input: [(0, 15), (11, 17), (10, 20), (45, 50)] Output: [(0, 20), (45, 50)] Visualization (0,15) --------------- (11,17) ------- (10,20) ------------------- (45,50) ----- result ---------------------------- ----- 0

Google AI capabilities are working to be embedded in your local browser soonish and if you look into the preview builds you can see the capabilities and switch them on for experimentation as follows Translate on Device Locally https://developer.chrome.com/docs/ai/translate-on-device API Details https://developer.chrome.

Sometimes you make a commit to a branch that you meant to put on another one and you want to quickly fix it by popping that commit over to the correct branch. Example situation Current branch is great-new-stuff, you have been working in this branch for awhile and then you

Working on some PowerShell scripting timing issues and documentation of how long things are taking and what they are doing while this is happening was needed. In this case put Measure-Command commands throughout the scripts to determine the timings. Example usage In this example I am using a oneline batch

TFVC you say. Yes Team Foundation Version Control or the terminal case of Visual Source Safe that Microsoft realized was battle no longer worth fighting git with and was one of many reasons to buy GitHub. Well had to dig out old code that was buried in this old system

Working on a React static site that is pulling large amounts of data from a public API. Problem Specifically the API request for data looks like this <base url>/objects?metadataDate=YYYY-MM-DD Here the metadataDate indicates the data object has changed since the particular date specified and the

From the above python exercise here now a C# flavored version Code private static IEnumerable<int> InfiniteGenerator(string input) { var index = 0; var letters = input.ToCharArray(); while (true) { yield return letters[index % letters.Length]; index++; } } static public void Main() { var value = 0; foreach (var current in InfiniteGenerator("

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.