The Daily WTF: Curious Perversions in Information Technology

Read the Comments

by Remy Porter in CodeSOD on 2021-10-25

Many many years ago, when I took my first programming course in high school, our instructor had… opinions. One of those opinions was that you should manually syntax check your code and not rely on compiler errors, because back in her day, you had to punch your program into cards, drop it off in the computer lab, wait for the technician to run your batch, and then pick up the results on the printer. It needed to work the first try or you might be waiting a whole day before you could try again.

One of her other opinions was that your code should contain as many comments as it contained lines of code. Everything needed comments. Everything. Which brings us to this code from Doug.

5 comments - Last comment @ 07:01

Outages, Prices, and Catastrophe

by Remy Porter in Error'd on 2021-10-22

Shaun F noticed an outage.

cloudflare's website demonstrating a cloudflare outage.

"Maybe," Shaun writes, "they should use the Cloudflare Always Online service."

26 comments - Last comment @ 06:06

Performance Tuning for Exabyte Queries

by Remy Porter in Feature Articles on 2021-10-21

While NoSQL databases have definitely made their mark and have an important role in applications, there's also still a place for RDBMSes. The key advantage of an RDBMS is that, with a well normalized schema, any arbitrary query is possible, and instead of optimizing the query, you optimize the database itself to ensure you hit your performance goals- indexes, statistics, materialized views, etc..

The reality, of course, is wildly different. While the execution plan used by the database shouldn't be dependent upon how we write the query, it frequently is, managing statistics and indexes is surprisingly hard, and when performance problems crop up, without the right monitoring, it can be difficult to track down exactly which query is causing the problem.

25 comments - Last comment @ 2021-10-24

A Ritual Approach

by Remy Porter in CodeSOD on 2021-10-20

Frequent contributor Russell F stumbled across this block, which illustrates an impressive ability to make a wide variety of bad choices. It is written in C#, but one has the sense that the developer didn't really understand C#. Or, honestly, programming.

if (row["Appointment_Num"].ToString() == row["Appointment_Num"].ToString())
{
    bool b1 = String.IsNullOrEmpty(results.messages[0].error_text);
    if (b1 == true)
    {
        row["Message_Id"] = ($"{results.messages[0].message_id}");
        row["message_count"] = ($"{results.message_count[0] }");
        row["message_cost"] = ($"{results.messages[0].message_price }");
        row["error_text"] = ($"{results.messages[0].error_text }");
        row["network"] = ($"{results.messages[0].network }");
        row["to"] = ($"{results.messages[0].to }");
        row["status"] = ($"{results.messages[0].status }");
        row["communicationtype_num"] = ($"1");
        row["Sent_Date"] = (String.Format("{0:yyyy-MM-dd hh:mm:ss}", DateTime.Now));
        row["Sent_Message"] = row["Sent_Message"].ToString();
    }

    if (b1 == false)
    {
        row["Message_Id"] = "0000000000000000";
        row["message_count"] = ($"{results.message_count[0] }");
        row["message_cost"] = ($"{results.messages[0].message_price }");
        row["error_text"] = ($"{results.messages[0].error_text }");
        row["network"] = ($"{results.messages[0].network }");
        row["to"] = ($"{results.messages[0].to }");
        row["status"] = ($"{results.messages[0].status }");
        row["communicationtype_num"] = ($"1");
        row["Sent_Date"] = (String.Format("{0:yyyy-MM-dd hh:mm:ss}", DateTime.Now));
        row["Sent_Message"] = row["Sent_Message"].ToString();
    }
}

24 comments - Last comment @ 05:17

Low (Quality) Code

by Remy Porter in CodeSOD on 2021-10-19

Like the tides, the popularity of low-code development environments comes in ebbs and flows. With each cycle, the landscape changes, old tools going away and new tools washing up on shore. One one hand, democratizing access to technology is good, on the other, these tools inevitably fail to actually do that. Instead, we get mission critical developed by people who don't understand how to develop, and are thus fragile, and released on platforms that are almost certainly going to be on legacy support in the next cycle.

I don't want to imply that low-code tools are automatically bad, or insult non-developers who want to give developing in a low-code environment a shot, though. Especially when professional developers can't really do any better.

35 comments - Last comment @ 2021-10-21

An Hourly Rate

by Remy Porter in CodeSOD on 2021-10-18

When someone mentioned to Abraham, "Our product has an auto-sync feature that fires every hour," Abraham wasn't surprised. He was new to the team, didn't know the code well, but an auto-sync back to the server sounded reasonable.

The approach, however, left something to be desired.

28 comments - Last comment @ 2021-10-21

Joining the Rest of Us

by Remy Porter in CodeSOD on 2021-10-14

Using built-in methods is good and normal, but it's certainly boring. When someone, for example, has a list of tags in an array, and calls string.Join(" ", tags), I don't really learn anything about the programmer as a person. There's no relationship or connection, no deeper understanding of them.

Which, let's be honest, is a good thing when it comes to delivering good software. But watching people reinvent built in methods is a fun way to see how their brain works. Fun for me, because I don't work with them, probably less fun for Mike, who inherited this C# code.

30 comments - Last comment @ 2021-10-21

Supporting Standards

by Remy Porter in CodeSOD on 2021-10-13

Starting in the late 2000s, smartphones and tablets took off, and for a lot of people, they constituted a full replacement for a computer. By the time the iPad and Microsoft Surface took off, every pointy-haired-boss wanted to bring a tablet into their meetings, and do as much work as possible on that tablet.

Well, nearly every PHB. Lutz worked for a company where management was absolutely convinced that tablets, smartphones, and frankly, anything smaller than the cheapest Dell laptop with the chunkiest plastic case was nothing more than a toy. It was part of the entire management culture, led by the CEO, Barry. When one of Lutz's co-workers was careless enough to mention in passing an article they'd read on mobile-first development, Barry scowled and said "We are a professional software company that develops professional business software."

33 comments - Last comment @ 2021-10-18