Posted by jpluimers on 2025/01/09
Recommended reading: [Wayback/Archive] MySQL: GIPK (InnoDB and Primary Keys) | Die wunderbare Welt von Isotopp
(Based on his Twitter thread archived at [Wayback/Archive] Thread by @isotopp on Thread Reader App – Thread Reader App that started with his tweet below).
Via [Wayback/Archive] Kris on Twitter: “blog.koehntopp.info/2022/08/23/mysql-gipk.html In which we have a look at MySQL 8.0.30 and Generate Invisible Primary Key”.
--jeroen
Posted in Database Development, Development, MySQL | Leave a Comment »
Posted by jpluimers on 2025/01/08
Directly after a new Windows installation, I want to have my cloned git repository of batch files in the PATH persistently so that it gets searched after rebooting or opening a new console window.
At that moment, there is not much of a 1024 PATH character limitation, but be aware about that limit if you try this yourself.
This is my add-current-directory-to-path-at-end.persistent-and-limit-to-1024-characters.bat:
:: https://serverfault.com/questions/664180/can-i-permanently-add-to-path-in-windows-using-batch
:: https://superuser.com/questions/812754/how-to-recover-from-path-being-truncated-to-1024-characters-by-setx
:: global environment
setx PATH "%PATH%;%CD%"
:: local process
:: https://superuser.com/questions/975605/add-current-directory-to-path
set PATH=%PATH%;%CD%
I execute it from within the cloned git directory.
Oh: you need to double-quote the SETX parameters, otherwise you get an error message: “ERROR: Invalid syntax. Default option is not allowed more than '2' time(s).“.
More links than the above ones from the batch file, especially on the 1024 character limitation:
Posted in Batch-Files, Development, Power User, Scripting, Software Development, Windows | Leave a Comment »
Posted by jpluimers on 2025/01/08
(All below statements were run elevated as Administrator)
I had arp -d fail with any parameter combination on one of my systems always throwing the error The ARP entry deletion failed: The parameter is incorrect..
Luckily I found out that this did clear the ARP cache correctly:
netsh interface ip delete arpcache
I found that via [Wayback/Archive] “The ARP entry deletion failed: The parameter is incorrect.” – Recherche Google:
Posted in Batch-Files, Development, Power User, Scripting, Software Development, Windows, Windows 10, Windows 11, Windows 7, Windows Development | Leave a Comment »
Posted by jpluimers on 2025/01/07
Since every now and then, like testing software developed with older tools, you need to run older software.
This always works: [Wayback /Archive] Deploy .NET Framework 3.5 by using Deployment Image Servicing and Management (DISM) | Microsoft Learn
DISM /Online /Enable-Feature /FeatureName:NetFx3 /AllUse
/Allto enable all parent features of the specified feature.
(The /All is needed because software requiring .NET Framework 3.5 also require the parent features).
Notes:
dotnet3.5 fails on Windows 11 (have not tried on Windows 10) with the classical red on black PowerShell default error theme*:
ERROR: The term 'wmic' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again.
The install of DotNet3.5 was NOT successful.
Error while running 'C:\ProgramData\chocolatey\lib\DotNet3.5\Tools\ChocolateyInstall.ps1'.
Posted in .NET, .NET 3.0, .NET 3.5, C#, Chocolatey, Development, Power User, PowerShell, Software Development, Windows, Windows 10, Windows 11 | Leave a Comment »
Posted by jpluimers on 2025/01/07
For my link archive: [Wayback/Archive] MySQL: Row Literals | Die wunderbare Welt von Isotopp
Question on the Libera/#mysql IRC channel:Is there a way to split a simple select into multiple returned rows? For example,select 1, 2, 3to be returned as rows?This is actually asking for a table literal notation. I know of four ways to construct a table literal in MySQL:
They are based on UNION ALL, JSON_TABLE and VALUES statement (the latter in two forms). I knew about the first (which I used in other database environments), not about the others.
Posted in Database Development, Development, MySQL, SQL | Leave a Comment »
Posted by jpluimers on 2025/01/02
While moving from ancient hardware to more modern hardware, somehow Visual Studio Code had updated itself to a version that didn’t support the underlying operating system any more. Bummer!
Normally I would get the list of extensions through this command (which is listed in many places, like in my blog post How can you export the Visual Studio Code extension list? (via: Stack Overflow), but also for instance answered in the below question by [WaybackSave/Archive] Benny Ng):
code --list-extensions
That obviously would not work, but thanks to [Wayback/Archive] How can you export the Visual Studio Code extension list? – Stack Overflow (thanks [Wayback/Archive] Andrew and [Wayback/Archive] MarkP) I now could do this:
ls -alh ~/.vscode/extensions
(That directory obviously is also in various forms of official documentation like in the the Your Extensions Folder section of [Wayback/Archive] Publishing Extensions | Visual Studio Code Extension API.
A comment to the above question pointed me to an interesting way to automate extension installs on various machines: pack the installed extension list into its own .vsix file:
Posted in Development, Software Development, vscode Visual Studio Code | Leave a Comment »
Posted by jpluimers on 2025/01/02
For my link archive: [Wayback/Archive.is] Converting Phono Inputs to Line-Level
It shows for some receiver models how to have the Phono input signals bypass the preamplifier (preamp) so they effectively become Line level inputs and there is no need for an extra devices that undoes RIAA equalisation.
If that fails, then you need something like the [Wayback/Archive.is] Line level to phono input converter diagram:
Or get you a [Wayback/Archive.is] iRIAA2 – Inverse RIAA Filter – Hagerman Audio Labs
Posted in Development, Hardware, Hardware Development, Power User | Leave a Comment »
Posted by jpluimers on 2025/01/01
I wrote a two earlier blog posts around puns in programming book indices before:
In the last one, I promised to list more occurrences which I now finally had time for to do.
But let me first elaborate more on the observation that modern computer books (like for instance on C# and Delphi beyond version 1) lack these kinds of index pun.
On the Delphi side, the index entry joke for recursion got removed no later than Delphi 3 (I am still looking for a Delphi 2 version of the Object Pascal Language Guide, see further below) even before the book being fully redone electronically and the index pages generation being automated in
I think I even understand why that is: the process of creating of indices. By the start of this century, more and more indices were automatically being generated and for the last 2 decades or so, all of them are. Back in the days however, indices were mostly done by hand. Nowadays, with everything automated, it is actually pretty tricky in most environments to add such an “infinite loop” index entry like in the Turbo Pascal book, as it would require two things at once:
Posted in .NET, C, C#, C++, Conference Topics, Conferences, Delphi, Delphi 1, Delphi 2, Development, EKON, Event, History, LaTeX, LifeHacker, LISP, Mathematics, Pascal, Perl, PL/I (a.k.a. PL/1), Power User, science, Software Development, Turbo Pascal, Typesetting | Tagged: 1, 7 | 4 Comments »
Posted by jpluimers on 2025/01/01
For my link archive as it will help me when ready to step up my Python skills: [Wayback/Archive] Uncommon Uses of Python in Commonly Used Libraries.
Via: [Wayback/Archive] Julia Evans on Twitter: “i love this kind of researchy blog post (“i read a bunch of python libraries, here’s what i learned!”)
Posted in Development, Python, Scripting, Software Development | Leave a Comment »
Posted by jpluimers on 2024/12/31
A small introduction is the Pentium FDIV bug – Wikipedia article which already has some of the highlights..
Ken Shirriff however went all the way in, and used a microscope to focus in on to the actual cause.
He wrote two Mastodon threads on it watching (most recent first, with a link to his blog post) making a good year’s end read:
In 1994, a math professor discovered that Intel’s Pentium chip sometimes gave the wrong answer when dividing. Fixing this “FDIV” bug cost Intel $475 million. I analyzed the Pentium chip and found the bug. 1/N
…
[Wayback/Archive] Intel’s $475 million error: the silicon behind the Pentium division bug
…
In 1994, a math professor discovered that Intel’s Pentium chip sometimes gave the wrong answer when dividing. Fixing this “FDIV” bug cost Intel $475 million. I analyzed the Pentium chip and found the bug. 1/N
…
And there is of course this, that predated his microscope work [Wayback/Archive] Ken Shirriff: “I recently saw an amazing Navajo rug…” – OldBytes Space – Mastodon Read the rest of this entry »
Posted in 8086, Development, Hardware Development, History | Leave a Comment »
The Wiert Corner - irregular stream of stuff 