Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
Pxtl
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
27 ms
·
481.
▲
by
Pxtl
2y ago
I disagree. DNS stores enough information in WHOIS to see if ownership has changed, it's not DNS' fault that nobody looks. Probably the least-wrong thing to do with current DNS is to have authentication servers keep track of the W
482.
▲
by
Pxtl
2y ago
It's a little more abstract since you don't have handy moving-reference-object like your finger, but: Place the picture in front of something deep, like a long hallway. Look off at something in the distance behind the picture, l
483.
▲
by
Pxtl
2y ago
That's more for traditional "magic eye" pattern stereograms where you want to relax your eyes to look off into the middle distance behind the subject instead of intensely focusing on something unnaturally close to your face
484.
▲
by
Pxtl
2y ago
The left-right full-image stereograms... but those are less common than the pattern-based "magic eye" stereograms. Those are the reverse of this - in the linked image and the left-right full-image stereograms, they're done b
485.
▲
by
Pxtl
2y ago
No, because NOT NULL/UNKNOWN is still NULL/UNKNOWN. I realized earlier I was using the term NULL, but going forwards let's use the ANSI SQL concept where the null state of a Boolean is called UNKNOWN. You'll have to for
486.
▲
by
Pxtl
2y ago
It treats the NULL/unknown value of the boolean as false 1 <> NULL => Boolean UNKNOWN, so SELECT * FROM foo WHERE 1 <> NULL returns nothing. 1 = NULL => Boolean UNKNOWN, so SELECT * FROM foo WHERE 1 = NULL returns not
487.
▲
by
Pxtl
2y ago
Honestly, at this point I just wish SQL servers supported proper discriminated union types and nullable columns were implemented as some kind of MaybeKnown<T> and I could just have a normal Maybe<T> with normal equality semantic
488.
▲
by
Pxtl
2y ago
Or maybe people understand but still think it's dumb and hideously inconvenient? Ergonomics matter.
489.
▲
by
Pxtl
2y ago
> Null is one of the hardest things for traditional software engineers Making them harder is not better.
490.
▲
by
Pxtl
2y ago
If you're compromising on your high-minded and unorthodox purist concept for ergonomics, you may as well finish the job of ergonomics and just use normal nulls where X=X is true.
491.
▲
by
Pxtl
2y ago
> SQL NULLs aren't weird, they're just based off of Kleene's TRUE-FALSE-UNKNOWN logic! Kleene's TRUE-FALSE-UNKNOWN logic is weird. SQL nulls effectively violate the reflexive property of equality, because X=X does not
492.
▲
by
Pxtl
2y ago
If you could replace 3 of your 4 writers with gen AI then they weren't writing content they were writing filler. AIs write noise, not signal.
493.
▲
by
Pxtl
2y ago
> Don't play competitive multiplayer crap. Especially if it's free to play. Problem is that most good multiplayer online games have gone F2P. I bought Team Fortress 2. Then it went F2P and got overrun with bots. Overwatch als
494.
▲
by
Pxtl
2y ago
I've got to say I prefer the raw Retroarch interface over the EmulationStation launcher. EmulationStation is pretty but the seams between it and Retroarch were just too big for me.
495.
▲
by
Pxtl
2y ago
afaik most ebikes are limited at 20mph, and realistically the thing that kills most cyclists is cars not the speed of cycling. And when a car runs you over a styrofoam helmet isn't going to help much.
496.
▲
by
Pxtl
2y ago
I like magic links (as long as they self-renew the cookie so I never have to log in again) but you do highlight the critical need for a good landing page if you use them, like "are you sure you want to log in as SomeUserNameGuy? You&#
497.
▲
by
Pxtl
2y ago
My reaction: "If scanning for wifi has that much negative impact on my connection, the OS should by default pop up a toast notification when it happens without a user request to do so." If MS can put slop like news and weather and
498.
▲
by
Pxtl
2y ago
Came here to post this and am happy to see that's already been done.
499.
▲
by
Pxtl
2y ago
> forever wars And yet they're allying with Trump and his Republicans? Republicans are responsible for the most recent US "forever wars", and Trump has threatened to invade various countries Syria, North Korea, Venezuela,
500.
▲
by
Pxtl
2y ago
> calls his coworkers NPCs. Seriously, that's kind of a "fuck you" moment to all the people who helped him earn those millions isn't it? Between this and hanging around with the head-cases at DOGE, I think the first
501.
▲
by
Pxtl
2y ago
Do none of these people have any creativity at all? No artistic spark that wants to be brought out but never could because art isn't really a profitable career? Like it's the same thing that boggles my mind with Elon. All that s
502.
▲
by
Pxtl
2y ago
I mean laws are supposed to stop the bad actors but at this point the extreme cost of legal action and the street-crime fixation of police forces mean those laws don't constrain wealthy interests unless they harm other wealthy interest
503.
▲
by
Pxtl
2y ago
Uh, more people work on 20-year-old codebases than you'd think.
504.
▲
by
Pxtl
2y ago
Torts are not just about damage, they're also about deterrence. Jones repeatedly demonstrated in the court battle that no deterrence would work on him. His entire business is built on this kind of defamation -- how much proceeds of thi
505.
▲
by
Pxtl
2y ago
Who deserves stronger punishment: a man who makes an error while driving and kills a family by accident? Or a man who deliberately runs a person down (but his target survived), and intends to continue doing so?
506.
▲
by
Pxtl
2y ago
His wealth is primarily the proceeds of slander and fraud. He should not have any of it. Unfortunately, slander and fraud are really hard to enforce. In a just system he'd have never earned that money in the first place. Fortunatel
507.
▲
by
Pxtl
2y ago
Ford. For Nixon.
508.
▲
by
Pxtl
2y ago
The only reason Biden pardoned his son was that Trump explicitly said he was going to use the DoJ for a punitive witch-hunt. No father would ever subject their child to that. If Harris had won, Biden would not have pardoned Hunter. Like
509.
▲
by
Pxtl
2y ago
It's infuriating that we're still struggling with this after so many years. Every time I learn a new format I want to scream "why can't you be normal?"
510.
▲
by
Pxtl
2y ago
This. I hate how all these serialization/config formats come out of dynamically typed languages. Static typing is a must. Then so many classes of errors go away.
More ›