Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
piaste
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
41 ms
·
481.
▲
by
piaste
5y ago
I use, and teach juniors basically the same rule as your first one. I phrase it a little differently though: "if something happened in the future that required a change to function A, would the same requirement apply to function B as w
482.
▲
by
piaste
5y ago
> Requiring encryption might be okay, but requiring CA based TLS is not okay. It is another strong force of centralization and shortly thereafter, control. CA-based TLS is a requirement that a client can enforce on the servers, not vicev
483.
▲
by
piaste
5y ago
Heh: https://hackage.haskell.org/package/product-profunctors-0.11... > cl_map :: Default Zipper a b => (b -> r) -> a -> [r] > A challenge from a Clojurist on Hacker News ( https://news.ycomb
484.
▲
by
piaste
5y ago
How often would a runaway query be able to run for days without the connection being dropped? I would expect either the incoming client request or the background job that started the query to have their own timeouts, and to dispose of their
485.
▲
by
piaste
5y ago
> If he had logging by screenshots it might be easier but with manual logging of hours there is very little reason to believe. OP wrote "I sent Upwork two years’ worth of projects". I assume that meant he showed them the actual
486.
▲
by
piaste
5y ago
How does passing the cost to the freelancer (who has ZERO ability to verify credit card ownership) make CC fraud any harder? If anything it's the opposite. If I were a fraudster, this blog post would encourage me to use stolen CCs on U
487.
▲
by
piaste
5y ago
However, OP claimed to have sent Upwork proof of two years of actual projects completed. While Upwork doubtlessly asked for them to verify that OP had not been scamming the client, it also shows that two years of real work had been done. A
488.
▲
by
piaste
5y ago
I recently decided to watch a movie that my ex-girlfriend had recommended to me, and I was able to quietly search for it in the chat history since we're no longer on speaking terms so I couldn't ask her. On the other side, when I
489.
▲
by
piaste
5y ago
NFTs cannot pay dividends and do not have boards of governance. A share without votes and without dividends would be worth $0. (Also, many NFT shills and/or shovel salesmen fervently insist that they're selfless patrons of the art
490.
▲
by
piaste
5y ago
I 100% agree that metadata like timestamps and machine IDs, if you care about them, should have their own columns. I only disagree with: > It'd be much more orderly for each node to have a sequential ID I've outlined some reaso
491.
▲
by
piaste
5y ago
Because you don't want your record IDs to be perfectly sequential data. You only care about them being sequential enough that your database engine will write them down quickly and efficiently (for engines like InnoDB or MSSQL which
492.
▲
by
piaste
5y ago
If the client needs to use the object right there and then, it can start polling the GET for that ID until it returns 200. A slightly more sophisticated pattern is to have the initial creation command return an ID of the creation event . T
493.
▲
by
piaste
5y ago
> Database people do all sorts of silly things like storing datetimes as normalized ISO strings (2022-01-08T08:18:20) instead of using 64bit unix time That's super weird. I can't think of a major RDBS that doesn't have a n
494.
▲
by
piaste
5y ago
Also entire classes of bugs. You screwed up a JOIN, or an application-level lookup for that matter? With UUIDs you'll get no results, with sequential ints you'll get a valid but wrong result. Or worse, the right result for the wro
495.
▲
by
piaste
5y ago
Who said you're working or grown ups? It's a great prank for college students as well.
496.
▲
by
piaste
5y ago
Based on this [0] chart, iPhones seem to be more popular in the Anglosphere and a handful of other countries like Belgium, Japan and Saudi Arabia. Rest of the world favours Android. [0] https://deviceatlas.com/blog/andr
497.
▲
by
piaste
5y ago
There is a more recent one, popularized in 2020 as an acronym.
498.
▲
by
piaste
5y ago
I don't know much about the culture specifically, but I'm reminded of the story about the Indonesian president whom the KGB tried to blackmail by taping him being seduced by two flight attendants. > Before starting the blackmai
499.
▲
by
piaste
5y ago
> with everybody working themselves into a lather over the promise of WAP If this was an intentional pun over the recently-acquired other meaning of "WAP", my compliments, it was perfectly executed.
500.
▲
by
piaste
5y ago
Sometimes the pagination is optional to allow the client to only get as many results as they can handle. But far more often, the pagination is forced - get 100 results, hit this link for the next 100 - in order to limit the load on the serv
501.
▲
by
piaste
5y ago
Sure, it's just funny that your example of "thirty years later" is code that someone could in principle have written in the same year (well, almost - I imagine Perl 1 might require some changes from the Perl 5 version). If
502.
▲
by
piaste
5y ago
> What is a realistic scenario where an array needs to be flattened? Concatenating the result of a paginated API. Showing all the objects two or more 1:N steps away from you in the object graph. The events your friends are attending, the
503.
▲
by
piaste
5y ago
And Perl's first release was in... 1987.
504.
▲
by
piaste
5y ago
In my experience, saying stuff like "the chance of a UUID collision is about the same as your car being struck by lighting and hit by a meteorite every day for a year" works on some non-STEM people. But there are a lot more for
505.
▲
by
piaste
5y ago
I think Base85 [0] warrants a mention for those needing to minimize the string representation length of their UUIDs. A year ago or so we had to store a reference to one of our entities into a legacy third-party system, which used char(20) a
506.
▲
by
piaste
5y ago
In this case it seems to be a matter of distance, not power. Imagine that, rather than the CEO making shit up, the case was about a lowly lab technician who faked results out of laziness or recklessness. Even though his fraud ultimately imp
507.
▲
by
piaste
5y ago
I recently purchased a used Yamaha SW-45 subwoofer for 30€. I asked the seller if for an extra 10€ he could include the RCA cable, to save me a trip to the nearest mall / Amazon locker. He tried to sell me a 40€ "high quality&quo
508.
▲
by
piaste
5y ago
> Combine that with human status seeking and the placebo effect and you get $2500 audiophile ethernet switches. There is a very clear line separating expensive audiophile equipment that might have some hard-to-measure non-placebo benef
509.
▲
by
piaste
5y ago
Ok, the way you read the article is an idea I can agree with. I still think the author's intent is more aggressive than you think, though. He repeatedly refers to Twitter bullshit as an example of low-density content he thinks one sho
510.
▲
by
piaste
5y ago
> https://studio.ribbonfarm.com/p/against-waldenponding > Premise: FOMO is good. Being plugged in is good. There is valuable info at all levels from twitter gossip to philosophy books. You should stay plugged in.
More ›