HNHacker News
TopNewBestAskShowJobs

LikesPwsh

291 karma · joined November 2, 2022

submissionscomments
LikesPwsh··on Firefox search update
Firefox mobile is still the hotness for that same reason.
LikesPwsh··on Generate code for declarative language instead of programming language
You could make that same argument for any parallelism - your CPU queues some inputs and processes them in an arbitrary order after considering dependencies.

There's a long way between hand-writing CPU instructions to make sure it does the same thing between runs, and the other extreme of writing a terraform yaml config and letting the engine decide how to get there.

Excel is so far from SQL/YAML that I can't lump them all together as "declarative". "Column from examples" comes to mind as a more declarative Excel feature than formulas in general.

LikesPwsh··on Best Buy Geek Squad employees report mass layoffs
Phones with docked keyboard and mouse seems almost inevitable.
LikesPwsh··on macOS Finder is still bad at network file copies
That used to be the case for me, but the Explorer right-click changes in Win11 are insane.

It only shows the common options (i.e. the ones where you would use a keyboard shortcut rather than mouse), hiding anything you might actually have wanted.

Even for less skilled users, mixing horizontal/vertical icons got me a confused tech support call from my elderly father.

LikesPwsh··on Scientists rename genes to stop Microsoft Excel from misreading them as dates (2020)
For your workaround you'd need to open the CSV in a text editor, set Excel types in a blank sheet, then paste.

Not a problem for someone who understands the issue, but it is a slow/confusing way to open files.

The real problem is the default behaviour of double-clicking a CSV in Explorer and destroying the contents.

LikesPwsh··on Scientists rename genes to stop Microsoft Excel from misreading them as dates (2020)
Same for Power Query and Text to Columns.
LikesPwsh··on Show HN: Detecting adblock, without JavaScript, by abusing HTTP 103 responses
You'd need someone willing to actually buy the cryptocurrency generated from nothing on the other side of that transaction.
LikesPwsh··on Microsoft is ending support for the Windows Subsystem for Android (WSA)
It's integrated with winget, but that hasn't caught on much either.
LikesPwsh··on Python datetime pitfalls, and what libraries are (not) doing about it
That bug is probably because of someone opening a CSV in Excel.

It's a common one, sadly. Anyone using the US date format for transfer or storage (debatably also display) should consider it a bug.

LikesPwsh··on Anyone elses company executives losing their shit over GenAI?
I had a look and couldn't find a serious journalistic source with numbers to back my personal opinion.

Lots of whiny Reddit threads, but only anecdata.

My own experience is that Dungeons & Dragons character art can be better (and more personally) created by writing your own stablediffusion prompts than by hiring an artist.

I've seen most local tables shift towards that.

LikesPwsh··on Anyone elses company executives losing their shit over GenAI?
On killer feature or art commissions?
LikesPwsh··on Anyone elses company executives losing their shit over GenAI?
This will be harder. Blockchain is entirely useless for legal activities, "AI" is broad enough that it includes useful things.

E.g. Obscuring copyright breaches is the number one killer app for genAI so far. It's decimated the cottage industry of personal art commissions.

LikesPwsh··on Yann LeCun: Human-level artificial intelligence is going to take a long time
Getting good enough that it's impossible to tell whether it contains a particular copyrighted (or GPL) work.

That's made them effectively immune to copyright enforcement so far; I'd go as far as saying the main function of llm/diffusion models is obfuscation of copyright breaches.

LikesPwsh··on Spot Bitcoin ETF receives official approval from the SEC
3AC was doing the same arb on GBTC (with an extended lock-in before redemption), but GBTC had no mechanism for selling BTC once their premium reversed.
LikesPwsh··on Spot Bitcoin ETF receives official approval from the SEC
Any cryptocurrency investment is a bucket shop, not just exchanges. There's no underlying positive cash flow to return to investors.
LikesPwsh··on Spot Bitcoin ETF receives official approval from the SEC
Bitcoin did the same, to be fair.

https://news.bitcoin.com/bitcoin-history-part-10-the-184-bil...

LikesPwsh··on Spot Bitcoin ETF receives official approval from the SEC
Seven TPS was a theoretical maximum, it normally ranges from three to six.
LikesPwsh··on I'm skeptical of low-code
Generally low-code are those gui-driven development tools.

E.g. You can write a data pipeline in SSIS by just dragging boxes around and entering connection details.

Sometimes the abstraction doesn't expose something you'd like, so you add a bit of code (SQL/C# for SSIS), but that's the "escape hatch" rather than the default workflow.

You've also got the approaches like Power Query, where a frontend action is automatically recorded as code (M in that case) , but the code is largely hidden from the end user and only used for source control/escape hatch.

LikesPwsh··on Developers are not happy with .NET MAUI, but nobody in the team cares about it
MS don't seem entirely on the same page there. Azure Devops was their first choice for Power BI integration for some reason.

https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=020078...

LikesPwsh··on US Seeks More Than $4B from Binance to End Criminal Case
Dollar-denominated bank accounts are a bigger factor for binance.
LikesPwsh··on Use Timestamps
Mmm doesn't localise well either.

E.g. French has Juin and Juillet, both "jui" start.

Better to just use yyyy-mm-dd everywhere. I see so many bugs from people still using US date format in 2023.

LikesPwsh··on Farming families who use more water from Colorado River than some states
http://www.climate.gov/news-features/featured-images/groundw...

"Aquifer depletion" is worth searching if you want to read in detail.

LikesPwsh··on Linux and TPMs with systemd measured boot [video]
Like most ordinary folks, my threat model is the use of TPM for DRM.

Netflix playing at lower resolution for example.

Widespread TPM is actively harmful for most people, and the biggest blow to general purpose computing in recent years.

LikesPwsh··on YouTube's ad blocker crackdown is getting harder to dodge
Those are just as adversarial as adblockers.

If Google ever makes a serious attempt at breaking compatibility like they're doing now (or we've seen from reddit/twitter), you'll see degraded ux.

LikesPwsh··on BP to purchase $100M in Tesla Superchargers
It's easier to get a home EV charger than a personal gas station, which helps.
LikesPwsh··on A Slower Urgency
Allocating all the environmental cost to the first owner is an issue with your accounting model, not electric cars.

It would make more sense to amortise over vehicle lifetime regardless of owner.

That said, electric cars are greenwashed beyond belief.

Being slightly better for the environment than combustion doesn't make them better than bike/train/bus.

LikesPwsh··on Microsoft completes $69B deal to buy Activision Blizzard
Randomness is a big mitigator.

In MtG or LoL, a worse player than the opponent might still win 40% of games (luck of the draw or teammates), even ignoring matchmaking systems.

Players can aim for losing less over time, while still having a chance to win any particular game.

In SC or chess any chance of success against a better player is effectively zero.

LikesPwsh··on SQL reserved words – An empirical list
You can compare the database schema in source control against what's been deployed, and automatically generate deployment scripts.

https://learn.microsoft.com/en-us/sql/tools/sqlpackage/sqlpa...

The APIs were historically part of Visual Studio, and only split out into dacfx recently.

Someone braver than me could consider automated deployment from github actions etc.

The hard part is that a lot of database schema changes cause data truncation (e.g. reducing the size of a column or re-ordering columns).

You still need someone to review the generated code if it throws an error for potential data loss.

LikesPwsh··on Tell HN: Please don't print –-help to stderr in your CLI tools
Here's a funny bug caused by stderr being used for information.

Windows Powershell gives you the detail of git push in scary red text.

https://stackoverflow.com/questions/12751261/powershell-disp...

LikesPwsh··on SQLite Functions for Working with JSON
That project looks great.

The MSSQL equivalent would be DbaTools, in case anyone is looking.

https://docs.dbatools.io/Write-DbaDbTableData.html

← PreviousPage 3 of 4Next →