The Wiert Corner – irregular stream of stuff

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

  • My badges

  • Twitter Updates

  • Pages

  • All categories

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

    Join 1,854 other subscribers

Archive for the ‘Software Development’ Category

Hashes and their uses – The Isoblog.

Posted by jpluimers on 2020/04/09

A nice introduction to [WayBackHashes and their uses – The Isoblog covering:

  • Checksums
    • Digit sums as simple, weak checmsums
    • Better checksums: ISBN-10 as an example
    • Proper CRC checksums
  • Hashes for storage
    • Building dictionaries
    • Breaking dictionaries
    • Handling collisions
  • Cryptographic hashes

Via [WayBack] I needed to explain Bitcoin. In order to explain Bitcoin, I needed to explain Proof-of-Work and Hash structures. In order to explain Proof-of-Work and H… – Kristian Köhntopp – Google+

–jeroen

 

Posted in Algorithms, Development, Software Development | Leave a Comment »

Delphi: OldCreateOrder in inherited TDataModule might suddenly become True

Posted by jpluimers on 2020/04/08

Interesting observation that might have been in Delphi for more than a decade: [WayBack] Found something strange in Delphi again which I’ve been trying to fix for days until I discovered it’s probably a Delphi issue… – Stefaan Lesage – Google+.

I think the summary is that if you have inherited TDataModule instances, then the descendant will always have OldCreateOrder set to True.

It is reported as RAD StudioRSP-20016 TDatamodule.OldCreateOrder always resets to true on descendants, but it is present in at least Delphi 7, so likely is in the old QC database:

Uwe Raabe:
I can track this error down to Delphi 7 (really)! Cannot check Delphi 6, but Delphi 5 just doesn’t have that property.
The reason lies in TDataModule.ReadState where

FOldCreateOrder := not ModuleIsCPP;
is set.

These might be related:

–jeroen

Posted in Delphi, Development, Software Development | Leave a Comment »

Common SMTP message size limits

Posted by jpluimers on 2020/04/08

After a 2018 discussion with a “zorgkantoor” (Dutch for office that arranges for special long term health care needs, successor of AWBZ) about their very low (10 megabyte) SMTP message size limit – even though they expect scanned PDF documents.

Their web-care team posed this limit as normal, so I made a list of limits in their peer group, common world-wide and well-ranked Dutch internet providers.

My plan is to check the progression of these limits over time.

Note these are the bruto message sizes including encoded attachments. Since encoding in [WayBack] MIME Base64 – Wikipedia has a overhead of at least 37% (encoded size is at least 1.37 the original size), the unencoded maximum size is less than 73% of what is listed below.

References:

2018

Read the rest of this entry »

Posted in base64, Communications Development, Development, eMail, Encoding, Internet protocol suite, MIME, Power User, Python, Scripting, SMTP, SocialMedia, Software Development, TCP | Leave a Comment »

Rendering SVG on gitea and gitlab

Posted by jpluimers on 2020/04/07

At the time of writing:

<!DOCTYPE svg PUBLIC "-//W3C//DTD SVG 1.1//EN" "http://www.w3.org/Graphics/SVG/1.1/DTD/svg11.dtd">

–jeroen

Posted in Development, DVCS - Distributed Version Control, git, gitea, GitHub, GitLab, Software Development, Source Code Management | Leave a Comment »

Debugging Delphi applications inside a Windows Docker container – yeiei.net

Posted by jpluimers on 2020/04/07

A docker container that pulls the PA server for Windows and steps how to attach to it and a video showing how to do this: [WayBackDebugging Delphi applications inside a Windows Docker container – yeiei.net

Cool if you do Delphi server side stuff.

Via: [WayBack] Hi delphi friends! If you are planning to use Windows Docker Containers and Delphi, you’ll need to read this: https://yeiei.net/en/debugging-delphi-appl… – Juan Antonio Ruzafa – Google+

–jeroen

Read the rest of this entry »

Posted in Delphi, Development, Software Development | Leave a Comment »

In SQL Server use `SET NOCOUNT ON` so tools taking the last modified record count won’t be confused by your trigger.

Posted by jpluimers on 2020/04/07

Interesting read: Time eating bug of the day… – Fabian S. Biehn – Google+.

TL;DR: in SQL Server use SET NOCOUNT ON so tools taking the last modified record count won’t be confused by your trigger.

Source: [WayBackTime eating bug of the day: I used a TADOQuery.ExecSQL (on Berlin) for an Up…

Related: [WayBack] sql server – ADODB affected rows return trigger’s affected rows – Stack Overflow

–jeroen

Posted in Database Development, Delphi, Development, Office VBA, Scripting, Software Development, SQL, SQL Server | Leave a Comment »

Hightlight active row/column in Excel without using VBA? – Stack Overflow

Posted by jpluimers on 2020/04/02

According to [WayBack] Hightlight active row/column in Excel without using VBA? – Stack Overflow: no, but you do not need much code.

On my list of things to try is to combine both answers there into one.

–jeroen

Posted in Development, Excel, Office, Power User, Software Development | Leave a Comment »

For my link archive: Python – Handling command-line arguments

Posted by jpluimers on 2020/04/02

The article is dense but goes way deeper than straightforward sys.argv[1:] handling: [WayBack10.6. Handling command-line arguments.

–jeroen

Posted in Development, Python, Scripting, Software Development | Leave a Comment »

Cool Delphi IDE idea: when moving a project, not just adjust absolute file paths but also search paths

Posted by jpluimers on 2020/04/02

The IDE already owns and modifies your .dproj and .dpr files (of which many users complain, but I think it is a good thing), so this is a great suggestion: [WayBack] Possibly slightly obvious but nonetheless a minor little tip to bear in mind when moving a project (.dproj/.dpr) by saving it to a new location (which I… – Walter Prins – Google+

Possibly slightly obvious but nonetheless a minor little tip to bear in mind when moving a project (.dproj/.dpr) by saving it to a new location (which I encountered this morning):

While the IDE will automatically adjust form/pas file paths for files included in the project in the .dpr for you, what it will not however do is also adjust the project “Search path” in a similar fashion, even though moving the project is guaranteed to break the project if it has project relative search paths and hence they would require adjusting.

That is to say, if you have project relative search folders specified in the “Search path” (and indeed the output folders), you will need to manually go and edit these paths in the project by hand when you change the project’s location.

(I’d argue that the IDE ought to update relative paths in the project options automatically given that it does so already for the .dpr; it would be the intuitive and graceful thing to do.)

–jeroen

Posted in Delphi, Development, Software Development | Leave a Comment »

Forde’s Tenth Rule, or, “How I Learned to Stop Worrying and ❤ the State Machine”

Posted by jpluimers on 2020/04/01

It is important to look beyond your own comfort zone to see what other languages can support: [WayBack] Forde’s Tenth Rule, or, “How I Learned to Stop Worrying and ❤ the State Machine”.

The article is about implementing finite state machines in JavaScript with as little usage of string literals as possible.

Via: [WayBack] How I Learned to Stop Worrying and Love the State Machine – Adrian Marius Popa – Google+

–jeroen

Posted in Development, JavaScript/ECMAScript, Scripting, Software Development | Leave a Comment »