Archive for the ‘Development’ Category
Posted by jpluimers on 2025/07/10
Below is a really cool tool-set for Visual Studio Code of which its development started when I was recovering from life-saving bowel-surgery during the series of procedures to get rid of my metastasised rectum cancer.
It supports decompilation of various languages (.NET C# and F#, GO, Rust and clang) into either x86 assembler or IR (Intermediate Representation, on the .NET side often also called IL for Intermediate Language) to research how well a compiler stack behaves.
[Wayback/Archive] badamczewski/PowerUp: ⚡ Decompilation Tools and High Productivity Utilities ⚡:
Read the rest of this entry »
Posted in .NET, C#, C++, Development, F#, Go (golang), Rust, Software Development | Leave a Comment »
Posted by jpluimers on 2025/07/09
I wasn’t aware that [Wayback/Archive] [OpenWrt Wiki] MikroTik was available. Many devices are incomplete in support, but it is good to know there is an alternative to the buggy scripting interface of RouterOS.
For the hEX series, support seems good enough to give it a try this summer, but I need to figure out of the hEX PoE RB960PGS is supported. I have good hopes as other models of the RB9* series are.
A few warnings from the below links:
- First Things First: Don’t Lose Your RouterOS License
- OpenWrt is not compatible with the bootloader of RouterOS v7. Do NOT upgrade the firmware on your device to RouterOS v7 or, if you did, downgrade to RouterOS Firmware v6 before installing OpenWrt. RouterOS doesn’t allow to downgrade below factory firmware version, but OpenWrt boots and works fine with versions up to 6.49.10 or beyond. Confirmed working: 6.47.10 (tested on SXTsq 5 ac), 6.49.10 (tested on SXTsq 2nD).
- If the installation fails, you might need to upgrade/downgrade to RouterOS 6.49.2
- Warning: Don’t upgrade RouterOS packages & bootloader to 7.2.1 otherwise ‘sysupgrade image’ install will fail!
- If latested release of RouterOS does not work, try an older version. 6.45 is reportet to work as a first debrick, you can upgrade later with the Winbox Software to latest release
These hEX related models are supported on the web-site (which also explains major differences with Fast Ethernet (100 Mbit/s) and Gigabit Ethernet (1 Gbit/s) models:
Read the rest of this entry »
Posted in Development, Hardware, MikroTik, Network-and-equipment, Power User, routers, Scripting, Software Development | 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/07
It was pretty hard to find any model/part-number information on optional video boards for the Dell 3060/5060/7060 Micro series (also known as Regulatory Model D10U and Regulatory Type D10U003).
These models by default had HDMI (version 1.4) and full-size DisplayPort (version 1.2) and additionally could ship with these configurations:
There was (seems not available any more) a serial port (:
Further below are some links I found, but first a ink to a good post on differences between 3060/5060/5070:
Read the rest of this entry »
Posted in Dell Optiplex 3060/5060/7060 Micro, Development, Hardware, Hardware Interfacing, HDMI, Power User | 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/07/03
Almost 3 years ago, I wrote about some database/SQL fiddle sites in Database fiddle sites (which covers [Wayback/Archive] two different [Wayback/Archive] dbfiddle sites and the [Wayback/Archive] SQL Fiddle site).
In the meantime, I figured out that [Wayback/Archive] Toolbox for Developers has a few fiddle pages and database/SQL tools online (in their order, which is not alphabetical):
Read the rest of this entry »
Posted in Database Development, Development, JavaScript/ECMAScript, MariaDB, MongoDB, MySQL, NoSQL, PHP, PostgreSQL, Scripting, Software Development, SQL Server, SQLite, TypeScript | Leave a Comment »
Posted by jpluimers on 2025/07/02
Since I keep forgetting which DBMS uses which method to select just a plain value without a table. I always remember it as my search phrase [Wayback/Archive] SELECT from DUAL, but actually better titled like the question below:
[Wayback/Archive] sql – SELECT from nothing? – Stack Overflow
Posted in Access, Database Development, DB2, Development, Firebird, InterBase, MariaDB, MySQL, OracleDB, PL/SQL, PostgreSQL, SQL, SQL Server, SQLite | Leave a Comment »
Posted by jpluimers on 2025/07/02
Always learning, I put this book on my wish list for reading: [Wayback/Archive] Effective Software Testing as from what I read it is a pragmatic book aimed at developers and suitable for teaching. That sounds right the niche I am in.
From [Wayback/Archive] Using the book in classroom:
Read the rest of this entry »
Posted in Agile, Development, Software Development, Testing, Unit Testing | Leave a Comment »
The Wiert Corner - irregular stream of stuff 