andy81

This bit sounds plumber-y from the article.

> Simon Orrell: My first exposure to “The Plumber Problem” was sitting in a theatre with my dad in 1973 watching “Emperor of the North” and my dad leans over to whisper, “They didn’t make culvert pipe like that back in the ’30s. It was plate, not corrugated.”

The worst localization bug I'm aware of is the default conversion of string to datetime in MS SQL Server.

If the session language is non-US, the ISO formatted string '1991-02-03' becomes 2rd March rather than 3rd Feb. yyyyMMdd works as expected.

You could do that in Excel, but Data Tables are the better way.

Once it's on Windows you can add it as a shell in Windows Terminal.

You might be mixing up cmd with windows terminal though. Cmd is truly crap which is why it was replaced with powershell 20 years ago.

The rise of targeted advertising is the main culprit of bad UX.

Everywhere there's dark patterns, performance overhead, mandatory updates degrading user experience, unnecessary JS and walled gardens breaking accessibility/compatibility, online-only etc.

You can expect data to be destroyed when automatically parsing csv/tsv (default behaviour), especially because it's dependent on the last settings used in the text-to-columns wizard.

Then there's all well-known bugs like floating point addition and locale-dependent function names and 1904 dates.

Conditional formatting accidentally pasting is all over the place.

I'm surprised at this take, since so far AI has mainly reduced the cost of creating content similar to what already exists.

GPU mining died last year.

There's so little liquidity post-merge that it's only worth mining as a way to launder stolen electricity.

The bitcoin people still waste raw materials, and prices are relatively sticky with so few suppliers and a backlog of demand, but we've already seen prices drop heavily since then.

Final Fantasy 3-4 is the big example for this.

Remade in 3d, then remade again in 2d to appeal to nostalgia for that style.

In-depth crypto hit piece by a well known poster on r/buttcoin.

The production quality is rough in some sections (I found the female echo-voice particularly grating near the start), so if you're looking for a specific highlight rather than watching the whole thing 36:25-42:37 has a nice example of the "oracle problem" that underlies many of web3's issues.

.NET has something close in standard libraries, in that you can try converting a string to System.Net.IPAddress and other similar classes.

It's for parsing rather than search though, you'd still need regex if e.g. searching unstructured logs for IPs.

e.g. (powershell syntax for easy reproduction) returns parsed, or throw if invalid. [uri]"\\ServerName1\Folder\UserName" [version]'1.2.3.4' [ipaddress]'1.1.1.1'

Exactly. It differentiates e.g. gore from pornography.

Firefox wasting time on re-implementing every pointless Chrome feature is half the reason we're in this space to begin with.

A browser doesn't need to be an operating system.

I'm no expert on web dev, mostly working in BI/DBA.

Running commands over WinRM or SSH can return objects of any type from remote machines. In the background I believe it's converting them to serialized CLIXML over the wire.

e.g. $RemotePSVersion = Invoke-Command -ComputerName 'SomeOtherComputer' -ScriptBlock {$PSVersionTable}

Rather than the variable $RemotePSVersion being a string it's an object with the type "System.Management.Automation.PSVersionHashTable", just like if you ran $PSVersionTable locally.

For anything that returns text (e.g. external tools like curl/robocopy) you'll usually convert to an object in your script before further processing. That way it can be passed into whatever next steps in a generic way.

e.g. curl https://catfact.ninja/fact | ConvertFrom-Json | Export-Csv '.\HighlyImportantInfo.csv'

curl https://catfact.ninja/fact | ConvertFrom-Json | Out-Gridview

That's less important when working interactively, but one major difference between Powershell/Bash is the relative focus on scripting vs interactive terminal use.

That's the one.

It's for wrappers around existing CLI tools.

Still feels experimental, but it's a nice idea to get objects from e.g. robocopy without dropping into regex and parsing it yourself.

It feels solved in raw Powershell functions, but running external CLI tools inevitably returns text and ruins the workflow.

"Crescendo" has been marketed as a solution and looks cool, but it means relearning the tool or documentation being less useful. The sheer amount of existing time people spent learning arcane git syntax means they're not going to switch to a hypothetical "New-GitCommit" function, even if it accepts arrays or PSCustomObject as input.

It would be absolutely impossible to 100% ban mining.

They could seize assets of miners big enough to need specialised energy deals, which would get rid of 90% of mining in the USA.

They could crack down on exchanges banking in USD, which would get rid of 90% of mining worldwide.

Stopping a single person running an algorithm on a single ASIC in a home environment is the impossible tail-end. I don't know if they even care about those, I'm not too worried about them.

Link to stream highlights - https://www.youtube.com/watch?v=3BgVe_Jp4Ys

That Kf8 really is the move of somebody living in another universe.

The other important factor is permissions.

Truncate in MSSQL requires alter permissions, so a user that can wipe a table can also change its definition. Not true with delete.

Of course.

You've got a list of countries and are pulling each country's national flower, national bird, largest port city etc.

Without outer joins, Liechtenstein with no ports doesn't show in the list at all. Sad news for people who want to know all countries, or Liechtenstein's national bird (eagle).

A better option in many cases is to check the primary key.

e.g.

select questions.Id , questions.Text , answers.Id , answers.Text

from questions left join answers on answers.QuestionId = Questions.Id

answers.Id is non-nullable as a primary key, so if answers.Text is null but answers.Id is not null they've declined to answer.

Every RDMBS has this, including SQLite.

English also has that "mezzanine" concept, for partial floors with a balcony over the main floor. You see it sometimes on elevators as an M.

Card games. e.g. MtG or LoR.

You've got to deal X damage to win.

You could directly cast spells at an opponent each turn.

Or instead you can play units or destroy enemy units to affect the amount of damage being done each turn.

Certain cards even increase the amount you can increase your damage each turn, e.g. by reducing costs, drawing cards on future turns, or improving deck contents.

Many people's only computer is locked to programs from a single source owned by the operating system developer, and adware impossible to remove without defating the device's security.

Where downloading apps from another source is possible, multiple levels of popups are triggered with warning messages optimised through A/B testing to minimise clickthrough rates.

Widewine and similar hardware DRM are now standard.

General purpose computing is still alive, but it's taken serious hits.

IBM i on modern Power machines is fine as far as performance goes.

The hideous frontend of greenscreen RPG programs is optional, you could replace them with Java if anyone cared enough about UX for internal tools (they don't).

The hard part with that stack is getting RPG devs - most of them are 50+ and expensive.

That feels overly pedantic, since bitcoin does function as a ponzi from the investors' perspective if not a textbook one.

The difference is that miners are constantly pulling dollars out of the system rather than some sinister individual constantly pulling dollars out of the system. Hopefully we'll end up with a new word for "decentralized ponzi" to differentiate them in future.

Obviously there are actual ponzis involving bitcoin (e.g. Tezos/Nexo/BlockFi/Crypto.com, possibly USDT/USDC) but those aren't bitcoin itself. Maybe that's part of the confusion.

N=3 is an absurd sample size to base hiring or investment decisions on, especially considering that each halving will have a smaller effect than the previous.

Web3 has also been used to describe web pages designed for easy parsing.

Reader view, tools for the visually impaired, and browser automation are actually useful and commonly used, so that definition win the title for me.

There are certainly useful distributed web tools (e.g. email, TOR, IRC, Matrix, self-hosting, bittorrent), but they're the opposite of recent trends towards monopoly.

The distributed meaning is absolutely poisoned by blockchain at this point.

You'd be competing against others who steal their electricity or have it subsidised (including pollution, resource depletion, regulatory arbitrage, financial crime and other externalities).

If you can take advantage of some of those and don't mind that the money isn't being generated so much as taken from other people then it's a great idea.