The Wiert Corner – irregular stream of stuff

Jeroen W. Pluimers on .NET, C#, Delphi, databases, and personal interests

  • My badges

    Mastodon

  • Twitter Updates

  • My Flickr Stream

    20140508-Delphi-2007--Project-Options--Cannot-Edit-Application-Title-HelpFile-Icon-Theming20140430-Fiddler-Filter-Actions-Button-Run-Filterset-now20140424-VMware-Fusion-6.0.3.-no-reclaimable
    More Photos

  • Pages

  • All categories

  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 1,862 other subscribers

Archive for January, 2025

« Previous Entries
Next Entries »

Delphi Discord servers

Posted by jpluimers on 2025/01/09

Besides the Delphi Praxis servers (the [Wayback/Archive] German one has existed for what seems eternity, the [Wayback/Archive] English one took over the Google Plus Delphi group – see Google is sunsetting Google+ by August 2019; DelphiPraxis might start English forums and have RSS – and de-facto the dead Embarcadero forums as the old newsgroup servers went dead, and the new ones weren’t known for their high up-time [Wayback/Archive] community.embarcadero.com’s forums – General Help – Delphi-PRAXiS [en]), nowadays – with the shortened attention span of many people – Discord has a few Delphi servers as well:

They are chat based, and suffer from messages and threads disappearing, just like the Delphi newsgroups and forums suffered from, and archiving content can be difficult or impossible (not just because of the Wayback Machine being down).

Queries:

Read the rest of this entry »

Posted in Chat, Delphi, Development, Discord, SocialMedia, Software Development | Leave a Comment »

Kristian Köhntopp on MySQL primary keys

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

Read the rest of this entry »

Posted in Database Development, Development, MySQL | Leave a Comment »

Adding entries to the PATH persistently (be aware of the 1024 character limit of SETX)

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:

Read the rest of this entry »

Posted in Batch-Files, Development, Power User, Scripting, Software Development, Windows | Leave a Comment »

On Windows, `arp -d` sometimes fails but `netsh` comes to the rescue

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:

Read the rest of this entry »

Posted in Batch-Files, Development, Power User, Scripting, Software Development, Windows, Windows 10, Windows 11, Windows 7, Windows Development | Leave a Comment »

Deploy .NET Framework 3.5 by using Deployment Image Servicing and Management (DISM) instead of Chocolatey and some notes on PowerShell colours

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 /All

Use /All to 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:

  • Tested on Windows 10 and Windows 11 in 2022.
  • It can take a really long time (more than just a few minutes!) even on fast connections.
  • Installing through Chocolatey with `choco install 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'.

Read the rest of this entry »

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 »

MySQL: Row Literals | Die wunderbare Welt von Isotopp

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, 3 to 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.

Read the rest of this entry »

Posted in Database Development, Development, MySQL, SQL | Leave a Comment »

The links I used to search for a refurbished M-Series Apple Silicon MacBook Pro

Posted by jpluimers on 2025/01/06

Having used the fully loaded Intel 15″ Retina MacBook Pro machines (the ones without dreaded touch-bars or butterfly keyboards – note the IBM ThinkPad 701 butterfly keyboard – also known as TrackWrite – was perfectly fine) from 2015 for 9 years, it was finally time to upgrade to an Apple Silicon one, but again: not the touch bar models.

My work is mainly CPU and disk intensive and often based on remote logon to more powerful equipment, so GPU cores and performance only marginally matter for web-browsing and local electron based applications (hello vscode!).

Going from 4 hyperthreaded CPU cores (8 parallel threads) to at least 8 full CPU cores, I didn’t want to pay full price like back in the days, and wanted it to be less than my car (EUR ~4000), so these links helped me find refurbished ones in The Netherlands:

Read the rest of this entry »

Posted in Apple, Apple Silicon, M1 Mac, Mac, MacBook, MacBook Retina, MacBook-Pro, Power User | Tagged: | Leave a Comment »

Dumpsterdiving for network access :: Jilles.com

Posted by jpluimers on 2025/01/06

[Wayback/Archive] Dumpsterdiving for network access :: Jilles.com

Just scaring people by telling them I could simply login to your network when you throw away you broken Smart light was not very credible. And eventhough people were kindly speaking up for me I would still like to illustrate how simple it is.

Read the rest of this entry »

Posted in Power User, Red team, Security | Leave a Comment »

The famous Shiv Ramdas Twitter thread about his brother in law getting quite a bit more than a bucketload of rice…

Posted by jpluimers on 2025/01/03

Since archiving Tweets has become so much harder over time, and Threadreaderapp not having the complete thread either, here are some links for your enjoyment:

  1. [Wayback/Archive] Shiv Ramdas on Twitter: “OMG my brother in law, the gift that never stops giving, was tired of being sent to get rice every day so he decided buy in bulk, talked to the shop about it, wires got crossed, now there is a literal TRUCK FILLED WITH RICE outside the house and my sister is losing her shit lmfao”
  2. [Wayback/Archive] Shiv Ramdas Traing To Rite Buk on Twitter: “If you have never heard a woman destroy a man with one sentence 25 times in a row you should meet my sister. She’s terrifying rn, I’m on the phone and I’m scared and she isnt even angry at me lol”
  3. [Wayback/Archive] Thread by @nameshiv on Thread Reader App – “To clarify, this is India so when I say truck, I don’t mean SUV, IT IS A LITERAL LORRY FILLED WITH RICE” … (which has the read of the thread)

Then some direct links that stitch most of the thread together on Twitter itself:

Read the rest of this entry »

Posted in SocialMedia, Twitter | Leave a Comment »

iTerm2 logged passwords: immediately upgrade to 3.5.11 and delete any /tmp/framer.txt on your systems – via isotopp Kris at Infosec Exchange

Posted by jpluimers on 2025/01/03

[Wayback/Archive] Kris: “iTerm2 logged passwords …” – Infosec Exchange

iTerm2 logged passwords

If you are running iTerm2 on MacOS with ssh integration (it2ssh or Settings -> General -> Profiles, set to SSH instead of Command) you want to
  1. Upgrade
  2. Find /tmp/framer.txt on all systems you generally log into and delete it
If you manage systems with MacOS users, good luck.

[Wayback/Archive] https://iterm2.com/downloads/stable/iTerm2-3_5_11.changelog affected versions:

Read the rest of this entry »

Posted in Apple, Mac OS X / OS X / MacOS, Power User | Leave a Comment »

« Previous Entries
Next Entries »