Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
richbell
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
38 ms
·
541.
▲
by
richbell
3y ago
> Only 4k votes in a sub with 577k members doesn't sound very legit. You'd be surprised how small the active userbase of large subreddit are. There are subreddits with millions of subscribers that rarely see more than 1,000 com
542.
▲
by
richbell
3y ago
I also wonder what type of engagement that 97% figure (if accurate) reflects. It's well known that people who submit content or comment (i.e. directly engage with the site) are a small minority of the overall userbase. Large subreddits
543.
▲
by
richbell
3y ago
They recently shut down i.reddit.com and have been trying to sunset old.reddit.com (or at least hide it behind dark patterns) for years. It isn't a large leap to say that old.reddit.com will be next in their crosshairs. https:/&#
544.
▲
by
richbell
3y ago
If it was edited /u/spez would have disputed them. Instead he lashed out against the Apollo author for "leaking private phone calls".
545.
▲
by
richbell
3y ago
It's demonstrably not, considering there are full audio recordings and transcripts.
546.
▲
by
richbell
3y ago
FWIW I agree. Anyways, I think it's wrong that the White House attempted to discredit and aggressively remove the content under false pretenses. At the same time, I think it's important to recognize that the content can be real A
547.
▲
by
richbell
3y ago
Indeed; gambling as a business model, be it betting apps or gacha games, relies on hooking in "whales" (gambling addicts) for most of their profits.
548.
▲
by
richbell
3y ago
Obesity is a problem, however, it's hard for people to download an app and gain hundreds or thousands of pounds on a single night.
549.
▲
by
richbell
3y ago
> How many former spooks signed a letter claiming it had all the hallmarks of a russian information operation to influence an election? 50? This was then promoted to "russian disinformation" and treated as fact far and wide acr
550.
▲
by
richbell
3y ago
I've read the Twitter files. I do not believe the content supports your claims. The fact that you refuse to link to any specific evidence makes it seem like you know this and aren't acting in good faith.
551.
▲
by
richbell
3y ago
> Are you looking for cnn, msnbc, fox, or one of the other media corporations fueled by pharma alone to write an editorial telling you why something is true? I am looking for specific evidence that substantiates the claim that was made.
552.
▲
by
richbell
3y ago
> ..."developed COVID-19-like illnesses in November 2019". My partner and her siblings developed a COVID-19-like illness in November 2019. It was far worse than any flu they'd ever had and even put one of them, an otherwis
553.
▲
by
richbell
3y ago
> The twitter files gave proof governments have been using social media to censor legal speech paid for by the tax payer. Source?
554.
▲
by
richbell
3y ago
The article should really be called I moved to small German town and regret it .
555.
▲
by
richbell
3y ago
This comparison doesn't really work because 4chan boards tend to be pretty strictly moderated. It's just that the threshold of what's considered acceptable is lower.
556.
▲
by
richbell
3y ago
If people are willing to pay hundreds of thousands of dollars to use third-party clients, doesn't that suggest that the first-party experience is awful? Let's not forget that Reddit's content is generated by its users. Perhap
557.
▲
by
richbell
3y ago
HN discussion of that: https://news.ycombinator.com/item?id=34039816
558.
▲
by
richbell
3y ago
https://news.ycombinator.com/item?id=36197355
559.
▲
by
richbell
3y ago
Still not a good look for Aimee. > In August 2018, Knight's father David Challenor was sentenced to 22 years in prison for raping and torturing a 10-year-old girl *in the attic of the home shared by him, his wife Tina Challenor, and
560.
▲
by
richbell
3y ago
The ads are genuinely disgusting. I don't how stuff like this is legal. https://youtu.be/EozPi1qmH44
561.
▲
by
richbell
3y ago
He left New York over their Kafka-esque treatment of him and his business, amongst other things. I'd encourage you to watch his videos where he calls the New York government and tries to figure out why there's been a lein and warr
562.
▲
by
richbell
3y ago
PyPI has had a pretty consistent spam problem for a while now.
563.
▲
by
richbell
3y ago
I think it's more confusion of how `ON CONFLICT DO NOTHING` works. Incrementing sequences is not "doing nothing" , even if it's valid and sensible behaviour, which leads to confusion.
564.
▲
by
richbell
3y ago
In my experience this tends to be an annoyance when you want to upsert against a table that has multiple unique constraints. For example, let's say you're tracking GitHub repositories and have a table `repository(id, gh_id, gh_nod
565.
▲
by
richbell
3y ago
> It's as resilient to race conditions *as it could be*. Does exactly what you'd expect, no? While that that may be true, based on the hours I've spent scouring Stack Overflow and GitHub issues it seems that many people do
566.
▲
by
richbell
3y ago
If I recall correctly (and it has been a while, so I'm not saying I am), the issue was with concurrent transactions inserting a record into tableA and another into tableB which has a foreign key constraint to tableA. The issue was like
567.
▲
by
richbell
3y ago
In addition to this, `ON CONFLICT` is still susceptible to race-conditions if you have a highly concurrent application. This may be obvious to some, however, a lot of people expect upsert to be atomic and get bit by this. I also dislike tha
568.
▲
by
richbell
3y ago
Thank you for this! GitHub's UI really bothers me, and I can't help but feel like it's gotten flashier but less useful . Another one: IIRC, for some reason, there is no "fork" button on mobile UI. You have to go to
569.
▲
by
richbell
3y ago
CAPTCHA v11: > What was the name of H.P. Lovecraft's cat?
570.
▲
by
richbell
3y ago
Who decides what is "fake news" or "hate speech"? In Canada there is a very real scandal involving our Prime Minister accepting money under the table from China, as well as him knowing about foreign interference in our e
More ›