andy81

8 ms·

61.
by andy81 3y ago
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. yyyyMMd
62.
by andy81 3y ago
You could do that in Excel, but Data Tables are the better way.
63.
by andy81 3y ago
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.
64.
by andy81 3y 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/compatib
65.
by andy81 3y ago
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 floa
66.
by andy81 3y ago
I'm surprised at this take, since so far AI has mainly reduced the cost of creating content similar to what already exists.
67.
by andy81 4y ago
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 suppl
68.
by andy81 4y ago
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.
69.
Blockchain – Innovation or Illusion? (Offical – Full Documentary)(youtube.com)
1 points by andy81 4y ago|1 comments
70.
by andy81 4y ago
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 ra
71.
by andy81 4y ago
.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 unstru
72.
by andy81 4y ago
Exactly. It differentiates e.g. gore from pornography.
73.
by andy81 4y ago
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.
74.
by andy81 4y ago
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.
75.
by andy81 4y ago
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.
76.
by andy81 4y ago
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 documentat
77.
by andy81 4y ago
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 w
78.
by andy81 4y ago
Link to stream highlights - https://www.youtube.com/watch?v=3BgVe_Jp4Ys That Kf8 really is the move of somebody living in another universe.
79.
by andy81 4y ago
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.
80.
by andy81 4y ago
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 pe
81.
by andy81 4y ago
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 k
82.
by andy81 4y ago
Every RDMBS has this, including SQLite.
83.
by andy81 4y ago
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.
84.
by andy81 4y ago
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
85.
by andy81 4y ago
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
86.
by andy81 4y ago
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
87.
by andy81 4y ago
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 individu
88.
by andy81 4y ago
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.
89.
by andy81 4y ago
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 certainl
90.
by andy81 4y ago
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 an

More ›