placeholder

CTEs as lookup tables

In the past I’ve had to write queries to convert data in a table into user-friendly display text. One way to do this is with CASE expressions. For example, let’s say you have a table with a column being a country code, and you want to add the country name in the final result.

Click to view the original at misfra.me

Hasnain says:

Bookmarking this for the future - I wish I’d known about this earlier!

“In the past I’ve had to write queries to convert data in a table into user-friendly display text. One way to do this is with CASE expressions.”

Posted on 2023-01-17T02:18:02+0000

placeholder

Reverse Engineering a Neural Network's Clever Solution to Binary Addition

There's a ton of attention lately on massive neural networks with billions of parameters, and rightly so. By combining huge parameter counts with powerful architectures like transformers and diffusion, neural networks are capable of accomplishing astounding feats.

Click to view the original at cprimozic.net

Hasnain says:

Great read. The author asks a neural network to learn a common but complex function (binary addition) and then keeps making the model smaller until it’s explainable - and then discovers the solution is quite unexpected. Great visualizations and explanation.

“Even if this particular solution was just a fluke of my network architecture or the system being modeled, it made me even more impressed by the power and versatility of gradient descent and similar optimization algorithms. The fact that these very particular patterns can be brought into existence so consistently from pure randomness is really amazing to me.”

Posted on 2023-01-16T16:09:37+0000

placeholder

A corrupt file led to the FAA ground stoppage. It was also found in the backup system

An FAA system outage caused massive delays and cancellations across the United States on Wednesday. Here's what happened, according to a source familiar with the Federal Aviation Administration operation.

Click to view the original at cnn.com

Hasnain says:

Great example for that “software bugs cost real money” post from a few weeks ago.

“The source said the NOTAM system is an example of aging infrastructure due for an overhaul.

"Because of budgetary concerns and flexibility of budget, this tech refresh has been pushed off," the source said. "I assume now they're going to actually find money to do it."

Posted on 2023-01-12T09:07:29+0000

placeholder

The companies that churn through young workers

Some employers look to hire and continually turn over junior employees – sometimes harming young workers’ careers before they’ve even begun.

Click to view the original at bbc.com

Hasnain says:

“Sarah, for her part, did recognise that her job had pushed her to the breaking point and left. But instead of moving within the industry, she took another path. She now works for a creative agency outside of fashion. She says she's much happier in her new role that offers clear progression, challenging work and varied daily tasks. “[Fashion] may have sounded like an impressive place to work,” she says, “but I realised it’s more important to have a fulfilling job than a cool name on a CV.””

Posted on 2023-01-12T07:57:24+0000

placeholder

JP Morgan Says Startup Founder Used Millions Of Fake Customers To Dupe It Into An Acquisition

JP Morgan is suing the founder of a Mark Rowan-backed startup it acquired, claiming the fintech, Frank, had sold the financial giant on a “lie.”

Click to view the original at forbes.com

Hasnain says:

This is amazing.

“It alleges that Javice and Amar first asked a top engineer at Frank to create the fake customer list; when he refused, Javice approached “a data science professor at a New York City area college” to help. Using data from some individuals who’d already started using Frank, he created 4.265 million fake customer accounts—for which Javice paid him $18,000—and had it validated by a third-party vendor at her direction, JP Morgan alleges. The complaint includes screenshots of the professor’s invoices and claims that Javice went to notable lengths to ensure documentation of this work was either destroyed or altered to avoid raising eyebrows. Amar, meanwhile, spent $105,000 buying a separate data set of 4.5 million students from the firm ASL Marketing, per the complaint. Amar and ASL Marketing did not yet respond to a request for comment.”

Posted on 2023-01-12T06:41:25+0000

placeholder

Renato Athaydes

Unison is a pure functional programming language that comes with a few revolutionary ideas. Seriously, it makes everything we’re used to, like long builds, dependency version conflicts, tests that run every single build even when nothing checked by them has changed, manual encoding and serializati...

Click to view the original at renato.athaydes.com

Hasnain says:

This was pretty eye opening! Not something I’ll use soon; but worth thinking about the ideas expressed here.

“Unison is an amazing new programming language that I am sure will not only start being used, very soon, in the niches that can mostly benefit from its purely functional nature and distributed computing friendliness, but it is also set to fundamentally influence what is expected of software development UX in the years to come.

It solves problems that most of us didn’t even know were problems that could be solved. And it’s just a very nice language all around. I found it quite a lot easier to grasp than Haskell, for example, while still feeling that it gives me more than enough power to write clean, reliable code without subjecting me to some hassle that most other languages would (long, complex builds, unreliable tests, dependency version conflicts…).”

Posted on 2023-01-11T05:53:29+0000

placeholder

Exclusive: Surveillance Footage of Tesla Crash on SF’s Bay Bridge Hours After Elon Musk Announces “Self-Driving” Feature

Musk has said Tesla’s problematic autopilot features are “really the difference between Tesla being worth a lot of money or worth basically zero.”

Click to view the original at theintercept.com

Hasnain says:

Still eagerly waiting for the day when this feature is banned and someone faces criminal penalties for this.

“The video and new photographs of the crash, which were obtained by The Intercept via a California Public Records Act request, provides the first direct look at what happened on November 24, confirming witness accounts at the time. The driver told police that he had been using Tesla’s new “Full Self-Driving” feature, the report notes, before the Tesla’s “left signal activated” and its “brakes activated,” and it moved into the left lane, “slowing to a stop directly in [the second vehicle’s] path of travel.””

Posted on 2023-01-11T02:51:32+0000

placeholder

Hasnain says:

Great analysis of bias in news media. I’ve often felt some of these biases at play and this does a good job of breaking them down, questioning the assumptions that lead to them, and then highlights the point with data.

“When doing systemic justice work, those of us to who talk to the media a lot know that the onus is always on us to come up with a new angle to make the story seem different. This is really a bad situation if the story you really need to tell in high volume is that our society continues to do a lot of the same things every day that are really really bad and that harm the world’s vulnerable people, animals, and ecosystems in basically the same ways every day.”

Posted on 2023-01-10T03:06:05+0000

placeholder

Noma, Rated the World’s Best Restaurant, Is Closing Its Doors

The Copenhagen chef René Redzepi says fine dining at the highest level, with its grueling hours and intense workplace culture, has hit a breaking point: “It’s unsustainable.”

Click to view the original at nytimes.com

Hasnain says:

Isn’t this a place where people fly to Denmark just to eat at? This treatment is unacceptable - even for pay. The stories are horrifying. This also puts “The Menu” into a different light for me.

“Mr. Redzepi, who has long acknowledged that grueling hours are required to produce the restaurant’s cuisine, said that the math of compensating nearly 100 employees fairly, while maintaining high standards, at prices that the market will bear, is not workable.”

Posted on 2023-01-09T16:53:54+0000

placeholder

Things they didn't teach you about Software Engineering

As always, a disclaimer before we start, this is purely subjective. Whether you are a seasoned professional or just starting out in the field, I hope

Click to view the original at vadimkravcenko.com

Hasnain says:

Great read on what software engineering careers are like.

“Although it may sound surprising, the primary focus of a software engineer's job is not writing code but rather creating value through the use of software that was written. Code is simply a tool to achieve this end goal. Code -> Software -> Value.”

Posted on 2023-01-08T15:15:27+0000