HNHacker News
TopNewBestAskShowJobs

whizzter

3,057 karma · joined May 5, 2015

https://whizzter.woorlic.org (yeah old https cert for the time being)
submissionscomments
whizzter··on Adding Window Functions to a Spreadsheet
Not entirely uninteresting, wrote some thoughts in your main comment thread.
whizzter··on Adding Window Functions to a Spreadsheet
"random business calculations in random cells" is what a lot of quick business stuff lives on, putting a few formulas instead of an entire application is what you need (not even AI's can keep up with that once you're used to it).

The danger as always, is when it becomes the entrenched business process, and as you say, being able to automatically pull out the logic when formalizing it is the win.

whizzter··on Adding Window Functions to a Spreadsheet
I kind-of like it, spontaneously taking tables from CSV files doesn't seem to be there (there's a mention of parquet via dataframes so perhaps it's supported implicitly, but maybe add that documentation?).

I see that import/export pipelines are there, so transform pipelines should be simple, and I guess that's a quick-n-dirty usecase it's there for (the spreadsheet part of "taco-bell programming" ala Dziuba ?).

Personally though for me often, the spreadsheet's interactive and quick recalcs is the important part, the exploratority quick checks with numbers updating, now if it can take arbitrary sheets and get out all "unstructured" calculations so one can edit them more properly later it's a win, or am I missing other major usecases?

whizzter··on Adding Window Functions to a Spreadsheet
Oh, so this is something Grist specific rather than something inherited from Excel? (I remember reading sometime back that MS was replacing VBA with Python)
whizzter··on Adding Window Functions to a Spreadsheet
What parts are Python and how does one know where the classic Spreadsheet functionality ends and Python starts ?
whizzter··on Adding Window Functions to a Spreadsheet
I think it's an push in Spreadsheets to become more "DB-alike" for less arbitrary results (like in the problem example the article starts out with) but kind-of misguided since it's complicated to do "easy things".

The root issue is that there's almost 50 years of spreadsheet syntax to consider and not colliding with.

whizzter··on Handles are the better pointers (2018)
Sounds like a misunderstanding/misusage? I'm thinking that the handles are to be opaque indicies, think typed variation of void pointers or filehandles in classic C api's. Thus, the handle is subsystem specific and it owns _all_ resources of a type, thus you're not meant to know or be able to send the "owner", it's merely a way to have a reference to something you use.
whizzter··on Pray for Chaos
The internet will be around, it just won't be open anymore.

Already the trolls,etc were a nuicance enough that anonymous social-media,etc is starting to become outlawed. Sure people will hack,etc but the easy exploitation of today will be a fleeting thing once we patch the fundamentally broken stuff.

Remember how Windows machines were wormed in the early 00s? MS got their act together and today the primary target is via browsers or Excel-files,etc. The recent Linux RCE while bad and probably not alone, is still not the common case.

whizzter··on Ask HN: Which TV do you recommend for privacy?
It's a scale of convenience/shittyness.

TV manufacturer OS < Apple/Google OS < user OS

Most people don't really care for their TV being a computer display even if you do.

whizzter··on Ask HN: Which TV do you recommend for privacy?
Even if I never connected my TV to WiFi , Windows and my iPhone can find it somehow and connect, so there's other protocols that are exposed and probably vulnerable without updates.
whizzter··on BioWare co-founder: game execs "have never made a game" and don't get it
That kind of stuff is why the film industry has cycles of actors starting production companies, overturning the hierarchy with their money and successes, followed by them getting bored, selling out, the business becoming more businesslike until they start forking enough money to actors again that they again can produce their own stuff.

Netflix and co, might upend or stall that cycle, same as Steam/MS/etc can stagnate the games business.

I think games still has a cycle or two before being totally stagnant though, but regulators are working hard to fix that.

whizzter··on BioWare co-founder: game execs "have never made a game" and don't get it
Indie games often cater to whatever the devs found fun as kids, that kind of creates it's own kind of stagnation.

The indie boom of the late 00s and early 10s was to a certain degree the result of odd creatives working the Flashgame community (cut-throat in itself) being forced out onto other platforms as it died combined with other platforms providing monetization possibilities.

As with everything, once there was money to be found the vultures moved in.

whizzter··on Roblox downloaded 145GB models from us (including adult content) without asking
Right, I can agree to a certaint extent that the model itself can be equated to storage.

I think you misjudged my intent with that initial comment, it was mostly that I'd be feeling easier about AI usage if I knew the models WEREN'T trained on GPL'ed code, people producing GPL'ed software has historically been quite profilic in certain areas and the odds of copyrightable parts of GPL'ed code not showing up in AI code managing certain fileformats is definetly nonzero.

Ie, I'd be happier using Claude Code-nogpl, I'd be fine with adding BSD,etc copyright notices if given provenance information from the model, being in the GPL minefield because they don't really seem to track inputs is another.

whizzter··on Roblox downloaded 145GB models from us (including adult content) without asking
Maybe maybe not, something interesting popped up reading the currently top-of-HN article on the GHC policy is that OpenJDK currently forbids AI contributions.

From the page, https://openjdk.org/legal/ai

--------------------------

What are the intellectual-property risks of using generative AI tools?

The Oracle Contributor Agreement (OCA) requires that a contributor own the intellectual property rights in each contribution and be able to grant those rights to Oracle, without restriction. Most generative AI tools, however, are trained on copyrighted and licensed content, and their output can include content that infringes those copyrights and licenses, so contributing such content would violate the OCA. Whether a user of a generative AI tool has IP rights in content generated by the tool is the subject of active litigation.

--------------------------

But they're just Oracle lawyers so it's baloney right?

whizzter··on For the first time ever, Google Search is less than 50% of Alphabet's revenue
Not more than accidentally or when actually interested in something that pops up, but as a friend said, I'm not a usual core customer so I've never been the baseline.

The thing they're doing correctly right now imho, is that AI mode is mostly toggled for things that passes a quick questions filter (probably low probability of a purchase, like "global illumination methods" giving a decent overview of the field) while if you just type green shoes it'll put out an assortment of online and local shopping options.

Now if as someone said in the sibling comments, Google is gouging their customers with the new auction model that's another problem, but if I was a shareholder I'd be less worried about an exodus of end users to OpenAI,etc than I was a year ago.

whizzter··on For the first time ever, Google Search is less than 50% of Alphabet's revenue
For me Google has stayed as the default interface, if I need to ask a basic query (probably searches that don't yield much revenue but keeps me on Google), the results were becoming worse a 1-3 years ago but now the AI parts of Google is now good-enough(TM) that I mostly don't need to go to a separate interface, as long as users aren't fleeing they can probably continue to get paid for ADs (also the if YT ads are included, those have really become obnoxious but probably well monetized).
whizzter··on Zero click, silent, remote Android DoS
Where does it say that it's carrier configuration? Looking through the page it mentions WAP and PDU, seems PDU from my skimming is just a part of encoding WAP messages, so basically anyone being able to send WAP messages onto the network will have the carrier happily retransmitting it unless carriers starts blocking them/filtering these incorrect ones?
whizzter··on MacBook Pro with PROLED XDR Display and Touch
Apple knows how much of a premium they can charge vs other manufacturers, if everyone else starts dropping they will as well.
whizzter··on Apple's git still trusts the compromised eMudhra certificates
Yes, but the irony here is that Apple used to (or perhaps still has) forbidden using other HTTP(S) clients in iOS apps (or perhaps Appstore in general) than the built-in out of security concerns like this would address by using 1 central storage instead of multiple ones were one won't get timely updates.
whizzter··on The result of the C++26 DIS ballot
Ah, so I might end up not looking like a fool for marking it green, good to know! :)
whizzter··on Roblox downloaded 145GB models from us (including adult content) without asking
A while back I was thinking it wouldn't be enforced, but the entire Craft-clones and REA tools usage explosion kinda hints that disassembling/rebuilding the source is cheap enough that LLM's(ironically) could probably quickly find culprits if you had suspicions about certain apps.
whizzter··on New 14‑inch MacBook Pro with M6
You mean as in binning? High defect rates for chips but they're burned to disable non-working parts and sell them as non-pro chips and accumulate the good ones ?
whizzter··on Three TLS Bugs in GoAhead
This caught my eye, remember how the eMudhra certificates had weirdly low parameters, like 4 and others in the single digits?

"Mbed TLS - Medium, CVSS 5.9 - A buffer-length typo reduces a 2048-bit DH modulus to one byte. TLS 1.2 DHE_RSA sessions are decryptable when the client accepts the broken parameters. GOAHEAD-SA-2026-0005."

Not familiar with those implementation details but was this the root cause?

whizzter··on Roblox downloaded 145GB models from us (including adult content) without asking
No, the question is, if the GPL'ed code/structure is more or less recovered during inference, would a court rule the result to be covered by the GPL?

I know there was some cases in the past where people swapped licences and changed variablenames,etc but the essential code clearly remained.

whizzter··on Roblox downloaded 145GB models from us (including adult content) without asking
Does it matter? Lawyers don't know either since most majorer cases are still in progress.

So far it seems more cases that have been decided in lower instances or has been settled or gone in the direction of the party with most money for lawyers, still even in those cases there seems to be a slight tilt towards rightsholders.

I'm not saying anything categorically, but if some cases go all the way and towards rightsholders, it could become a real shitshow in the software industry since we've adopted AI so heavily and the non-significatng portion of public GPL licenced code could bite people in the ass.

whizzter··on Roblox downloaded 145GB models from us (including adult content) without asking
I think technically such a model should abide by the licence of the inputs, hence all models would probably be GPL if the FSF had resources to fight it and the legal profession had an inkling of the processes involved.

Or maybe the FSF is just waiting for everyone using AI code to become hooked and then subpoena every Antrophic/OAI/Codex customer and force the most massive source release in history (If Adobe/MS would file lawsuits vs the Craft apps and with their resources create legal precedent it could create chaos, maybe the only part stopping them right now from filing lawsuits is them realizing it could backfire since they're heavy AI users themselves).

whizzter··on Roblox downloaded 145GB models from us (including adult content) without asking
Aaron Swartz pulled down by the legal system for trying to get things accessible for people instead of being blocked by profit requirements.

Companies copying things to make profit for themselves not being held accountable.

Progress is one thing, injustice is another.

whizzter··on Roblox downloaded 145GB models from us (including adult content) without asking
It's a community site, first model I looked at (Tanya by Shrimport) is under CC-BY-ND-NC licence (Creative Commons, By attribution, No-derivatives, Non-commercial).

AI training by definition is derivative, and Roblox not using it for commercial purposes if used in production is practically nil.

This is a huge part of why AI upsets people, we can't have nice things such as communities where people are sharing 3d models without it being feeding ground for commercial companies that has little intention to ever honor any licences or compensate authors.

whizzter··on PaperPilot – Zero-Cloud, Pure-Rust PDF Engine with WASM and MCP
I was thinking the same thing when another PDF library popped up in the .NET subreddit a few hours before this post.
whizzter··on Anthropic S-1
I'm not really in that camp, but I'm still in the camp of "will they survive long-term if good enough open models trickles down to commodity hardware" (in a way the opposite camp perhaps?).

Sun made bank 25 years ago because their servers was needed for websites, today we run larger workloads on 5$ VPS servers (well maybe the VPS servers has gotten more expensive due to HW shortages but they're not intrinsically expensive anymore).

Page 1 of 34Next →