Posted by jpluimers on 2025/07/30
The video is from a while back, but very relevant and shows in Delphi what I have been advocating to software developers for a very long time:
This holds for any environment, so .NET / C#, Python, Delphi and many others as well:
Posted in Conferences, Delphi, Development, EKON, Event | Leave a Comment »
Posted by jpluimers on 2025/07/30
Via [Wayback/Archive] Angie Jones on Twitter: “Chart by Forrest Brazeal” I found the original at [Wayback/Archive] Forrest Brazeal on Twitter: “Just saying. “ Read the rest of this entry »
Posted in AI and ML; Artificial Intelligence & Machine Learning, Conference Topics, Conferences, Development, Event, Software Development, Technical Debt | Leave a Comment »
Posted by jpluimers on 2025/07/24
:strip_exif()/i/2007644484.jpeg?f=imagegallery)
The leak was short enough for Google to index the imagery and this text:
WHY2025 nam het zekere voor het onzekere door een ESP32-controller, een lora-chip en een kraakhelder scherm in zijn badge te verwerken. Tweakers …
Edit 20250727: two days later the page got reinstated without in their “Gathering of Tweakers” portion of the site a clarification why it was taken off-line for two days. It is still at the same URL, so I re-archived it: [Wayback/ArchiveBad] Dit is de WHY2025-badge met twee ESP32’s en een loramodule (need to re-archive in Archive.is as their IP got blocked)
The page now is a nice 404: [Wayback/Archive] Dit is de WHY2025-badge met twee ESP32’s en een loramodule
Not sure why the page got retracted, as the specs got released on LinkedIn a month ago at [Wayback/Archive] 🚀 Officially public launched: the WHY2025 Badge! | Jelmer Lopes Terto:
Posted in Conferences, Development, ESP32, Event, Hardware Development, WHY2025 | Leave a Comment »
Posted by jpluimers on 2025/07/24
[Wayback/Archive] Julia Evans on Twitter: “after the bug is fixed: write a postmortem”
–jeroen
Posted in Conference Topics, Conferences, Debugging, Development, Event, Software Development | Leave a Comment »
Posted by jpluimers on 2025/07/21
This started out ad a post to make things easier for my mentally brother, but then I figured it makes it so much easier for myself as well: getting rid of the evern returning Windows nag screens. Not just the ones after logon during initial Windows install that get back about every other Windows 20H update (thank god they stepped away from 19## version numbering that felt so, ehm, last millennium), but also the various “suggestions” in start menu, on the taskbar and elsewhere.
I understand that basically giving Windows 10 and 11 for free to many Windows 7/8 licensed machines or Windows-preinstalled machines induces Microsoft to see Windows as an advertising environment, but hey: many users can do without these distractions.
It is hard to solve, as even the underlying registry settings seem to be reset every once in a while, and solving it globally is not an option: the settings are a per-user one. Which means you need to run script early during every Windows logon to overwrite these settings.
Posted in Batch-Files, CommandLine, Conference Topics, Conferences, Development, Event, Power User, PowerShell, PowerShell, Registry Files, Scripting, Software Development, Windows, Windows 10, Windows 11, Windows Development | Tagged: 48 | Leave a Comment »
Posted by jpluimers on 2025/07/16
As a keyboard person, I prefer to live on the CLI (command-line interface), so when possible I prefer command-line tools over GUI tools (especially since command-line tool are way easier to script).
In the past on non-Windows systems I used gist (see below), but that is not available on Windows unless you have a Ruby environment.
Some notes on Windows to install and authenticate GitHub CLI (gh) and GitLab CLI (glab), both of which I previously mentioned in Tribal Knowledge? Getting the public keys from github and gitlab users from their username.
For me, installing is easiest through Chocolatey (version numbers from the time of writing; the non-archived URLs point to the most current version available):
This was my install script:
Posted in Conference Topics, Conferences, Development, DVCS - Distributed Version Control, Event, git, GitHub, GitLab, Power User, Software Development, Source Code Management | Tagged: 233 | Leave a Comment »
Posted by jpluimers on 2025/07/08
While writing Some SQLite things I recently learned a while ago I bumped into SQLite extending the SQL syntax allowing SELECT column aliases in WHERE and ON conditions of JOIN clauses whereas standard SQL only allows it in the HAVING clause (some other DMBS allow this as well).
It reminded I never wrote a blog post about WHERE versus HAVING, which can be phrased into just two points:
WHERE is applied before the SELECT is assembledHAVING is applied after the SELECT is assembledThis also means WHERE has a lot more influence on performance than HAVING, so using HAVING just so you can use aliases there instead of in the WHERE clauses is not a smart idea unless you verify in the query plan and query optimisation output of our DBMS this has no influence (some DBMS even allow you to see the results of query rewriting which you can use to verify if two queries really are equivalent from the DBMS perspective).
Since HAVING can be used without GROUP BY, many people work around the WHERE alias limitation. Given the above effects on performance, this is not a wise idea, despite the same end-results. See the example below that uses the [Wayback/Archive] MySQL :: Sakila Sample Database: customer table.
Luckily there has been enough other material explaining WHERE versus HAVING, so I can reference it from here, for instance (note note limited to MySQL/MariaDB) [Wayback/Archive] mysql – WHERE vs HAVING – Stack Overflow (thanks [Wayback/Archive] baloo and [Wayback/Archive] Fishdrowned):
Posted in Conference Topics, Conferences, Database Development, Development, Event, MariaDB, MySQL, SQL, SQLite | Tagged: 1054, this | Leave a Comment »
Posted by jpluimers on 2025/07/03
Indeed: DOOM in Pascal. Not Delphi: Free Pascal.
Repository: [Wayback/Archive] GitHub – PascalCorpsman/FPC_DOOM: FPC Port of DOOM
It is based on [Wayback/Archive] GitHub – fabiangreffrath/crispy-doom: Crispy Doom is a limit-removing enhanced-resolution Doom source port based on Chocolate Doom..
Hopefully, this summer I can play around with it a bit.
Via [Wayback/Archive] International Pascal Congress on X: “DOOM in Pascal!! 😍👏👏 Do you want to play or compile it? 😉 #Pascal #ObjectPascal …”.
--jeroen
Posted in Conference Topics, Conferences, Delphi, Development, Event, FreePascal, Pascal, Power User, Retrocomputing, Software Development | Tagged: ObjectPascal, pascal | Leave a Comment »
Posted by jpluimers on 2025/06/26
From a while back: [Wayback/Archive] Undergraduate Upends a 40-Year-Old Data Science Conjecture : programming which has a “TL;DR for non CS people” and a “Here’s an explanation” well worth reading.
It’s about the work of Andrew Krapivin with co-authors Martín Farach-Colton and William Kuszmaul.
A young computer scientist and two colleagues show that searches within data structures called hash tables can be much faster than previously deemed possible.
Reminder to self to find any real world implementations of this new hashing algorithm.
Materials are the “easier” article [Wayback/Archive] Undergraduate Upends a 40-Year-Old Data Science Conjecture | Quanta Magazine which refers to the actual paper:
Posted in Algorithms, Conference Topics, Conferences, Development, Event, Software Development | Tagged: DeepSeek, hashtable, innovation | Leave a Comment »
Posted by jpluimers on 2025/06/25
The manual process of getting back to the earliest commit of a GitHub repository is easy for small repositories, but for a large one it is very tedious.
TL;DR: there are various ways, but the easiest was the INIT Bookmarklet below.
Note: 2 weeks before the scheduled post made it to the front of the queue, I got a report¹ that it started to fail. Here it still works.
It’s hard to debug because of the functional programming approach taken.
Posted in Bookmarklet, C, Conference Topics, Conferences, Development, DVCS - Distributed Version Control, Event, git, GitHub, Go (golang), JavaScript/ECMAScript, Power User, Scripting, Software Development, Source Code Management, Web Browsers | Tagged: 1, 18, 7 | Leave a Comment »
The Wiert Corner - irregular stream of stuff 