Readit News logoReadit News
bmer commented on Non-elementary group-by aggregations in Polars vs pandas   labs.quansight.org/blog/d... · Posted by u/rbanffy
RadiozRadioz · 10 months ago
Why would you generate SQL using another programming language? To me that sounds like something you'd only do if you're deep in an ORM with no escape hatch. For data analysis tasks, that's extremely unergonomic and you should definitely just write normal SQL. Use the ORM for CRUD. I've never seen an ORM that won't let you drop down to regular SQL for ad-hoc queries.

Editor completion is an extremely low ranking aspect for choosing technologies for data analysis. If SQL is the better tool but you're not using it because it doesn't have editor completion, then you need a better editor. It pains me when people prioritise "developer experience in VS Code" over "actually the correct technological choice".

bmer · 10 months ago
What's the "right editor" for SQL?

"Correct technological choice": I think relational algebra style APIs (a la Polars) are the "correct technological choice" here. SQL is just a tool to express relational algebra, and I'm not sure it's a good one.

bmer commented on M4 MacBook Pros use a quantum dot (QD) film rather than a red KSF phosphor film   twitter.com/DSCCRoss/stat... · Posted by u/zdw
matrix87 · 10 months ago
is OLED unequivocally better than IPS?
bmer · 10 months ago
I've heard that there are screen lifetime issues?

Also, from my limited experience with a single OLED screen, it seems that most stuff was created for a certain kind of screen without as much colour fidelity, and now that stuff seems far more...obnoxiously "saturated"?...on an OLED screen.

bmer commented on Non-elementary group-by aggregations in Polars vs pandas   labs.quansight.org/blog/d... · Posted by u/rbanffy
_boffin_ · 10 months ago
Why not sql?
bmer · 10 months ago
Editor completion. Programmability "out-of-the-box" (rather than having to generate SQL using another programming language).
bmer commented on KDE Again Operated at a Loss During 2023   phoronix.com/news/KDE-202... · Posted by u/ReadCarlBarks
advisedwang · a year ago
> it was another year they unfortunately operated in the red funding wise.

As Arnt point's point's out, this was not unfortunate. It was intentional, necessary and calculated. See the report itself (https://ev.kde.org/reports/ev-2023/#welcome-to-kdes-annual-r...)

bmer · a year ago
I am surprised to see phoronix getting that so wrong…
bmer commented on Ask HN: Security risks when buying mini-PCs/PCs from unknown vendors?    · Posted by u/bmer
LinuxBender · a year ago
I've bought three mini-PC's from different vendors via Amazon. All three had malware on their pre-installed image. I replace the storage and install Linux but there is still the risk of a malicious BIOS. Given I don't use them for anything important I accept the potential malicious BIOS risk. I would never use these with any data I or others cared about but that is just my own personal opinion that is shared by some security teams. I would never bring one of these into a company or government organization.
bmer · a year ago
Is it possible to “install” (“flash”?) an open source BIOS onto a newly bought device?
bmer commented on Is My Blue Your Blue?   ismy.blue/... · Posted by u/bpierre
RussianCow · a year ago
For a single individual, all of the above is true, but for a large enough sample size, the answers may be more generally useful because you account for all of those rounding errors.
bmer · a year ago
No, because if my case holds more genera (and I suspect it does), the answers are in part out of sheer frustration, and therefore prone to being similar to the last one given.

I am not afraid to say this is poorly designed.

bmer commented on Leave car keys 'at front door' to avoid violent confrontations: Toronto Police   toronto.citynews.ca/2024/... · Posted by u/bookofjoe
voldacar · a year ago
The root problem is that somebody is entering your house and stealing your car

Modulo stray bullets, shooting does in fact seem to address this

bmer · a year ago
The root problem is a lack of imagination that cannot fathom how the person making the judgement might find themselves in the position of the judged, in the not-so-far-future.

The good news is that reality does not care whether or not you lack imagination. One can only marvel then, at the sequence of events that lead to the "unthinkable".

bmer commented on Leave car keys 'at front door' to avoid violent confrontations: Toronto Police   toronto.citynews.ca/2024/... · Posted by u/bookofjoe
djohnston · a year ago
This seems akin to watching those flash mob looting videos and saying “they’re just trying to feed their families”.

They are criminals. They are not trying to feed their families in a way commiserate with a peaceful society. They’re probably not trying to feed their families but even if they are it doesn’t matter if they are doing so by brutalising their neighbours.

bmer · a year ago
Yeah, I only support brutalising neighbours if its done nice and clean: by an army of attractive well-paid lawyers gaslighting everyone involved.
bmer commented on U.S. transferred a record $80.9B worth of military equipment 2023   airandspaceforces.com/for... · Posted by u/belter
whimsicalism · a year ago
Nobody has the counterfactual answer to this.

Proponents will speak to deterrence and preservation of ‘liberty’/non-despotism, opponents will speak to the very real death toll inflicted by these weapons.

bmer · a year ago
Well, what do the prediction markets think?

Markets are unable to lie (as they are deeply/intrinsically connected to reality).

u/bmer

KarmaCake day1192December 15, 2015View Original