Archive for the ‘Conferences’ Category
Posted by jpluimers on 2025/08/01
A few notes after I helped updating [Wayback/Archive] Chocolatey Software | SetACL (Portable) 3.0.6.0 to version 3.1.2.0 and [Wayback/Archive] Updates glab from 1.22.0 to 1.24.1; fixes #2 by jpluimers · Pull Request #3 · corbob/ChocoPackages.
As the burden on maintainers (not just Chocolatey ones) is high, not all packages get updated soon after new underlying software versions arrive.
Which means the maintainers are often very happy when an occasional user helps and preferably sends in a pull request.
That brings me to the an important point IN DOCUMENTATION DO NOT LIMIT EXAMPELS TO ONLY ABBREVIATED PARAMETERS OR VERBS as that scares away occasional and novice users of your software.
Chocolatey documentation is no exception on this, hence this blog post meant for people other than maintaining chocolatey packages on a day to day base.
Read the rest of this entry »
Posted in CertUtil, Chocolatey, CommandLine, Conference Topics, Conferences, Development, Event, Power User, PowerShell, PowerShell, Scripting, Software Development, Windows | Tagged: 2, 2850, 3, 309, 561 | Leave a Comment »
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:
- when timestamping use UTC
- when storing the timestamp store both the UTC timestamp and optionally the UTC timezone/offset and optionally daylight saving indicator of the region it was recorded from
This holds for any environment, so .NET / C#, Python, Delphi and many others as well:
Read the rest of this entry »
Posted in Conferences, Delphi, Development, EKON, Event | 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:
Read the rest of this entry »
Posted in Conferences, Development, ESP32, Event, Hardware Development, WHY2025 | 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.
Read the rest of this entry »
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:
Read the rest of this entry »
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 assembled
This 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):
Read the rest of this entry »
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
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:
Read the rest of this entry »
Posted in Algorithms, Conference Topics, Conferences, Development, Event, Software Development | Tagged: DeepSeek, hashtable, innovation | Leave a Comment »
The Wiert Corner - irregular stream of stuff 