Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
rosser
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
8 ms
·
31.
▲
by
rosser
7y ago
It's interesting that you chose to wiki-splain the scientific method in response to ... what? The notion of anthropogenic climate change? The accusation of being a denier? Whatever, the reason that's interesting is that an increas
32.
▲
by
rosser
7y ago
> Meanwhile blaming every weather anamoly on climate change is rather tiresome. Not nearly as tiresome as disregarding the clear and ongoing increase in the frequency and intensity of these anomalous weather events, where every recor
33.
▲
by
rosser
7y ago
See Brandolini's Law. https://en.wikipedia.org/wiki/Bullshit#Bullshit_asymmetry_pr...
34.
▲
by
rosser
7y ago
In most of the communities I've taken ayahuasca with, the "standard" dose is 1.5oz, which is ~42.5g. In others, it's even higher (or was, but has been reduced as they've refined their cook). Also, note that was 40g
35.
▲
by
rosser
7y ago
Not quite true. The default behavior changes, and new syntax is added allowing users to specify their desired behavior, but if the sub-query in the CTE does certain things, it will still be materialized instead, regardless. That is: the
36.
▲
by
rosser
7y ago
Are you thinking of the "[NOT] MATERIALIZED" clause? Yes, that's coming. https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit...
37.
▲
by
rosser
7y ago
Heed the caution about CTEs being optimization fences. I had a case just this past week, where one of our engineers needed help with a query that used a LEFT JOIN against a CTE which generated text-search vectors for some subset of rows, in
38.
▲
by
rosser
7y ago
That is one hell of a false dilemma.
39.
▲
by
rosser
7y ago
Can a mod please collapse or detach this thread? There's nought but noise here, unsurprisingly.
40.
▲
by
rosser
7y ago
When a child expresses curiosity, an adult who responds in a manner that involves a dismissive "instead" should probably seriously reconsider their life choices — especially the ones that led to them interacting with children in t
41.
▲
by
rosser
7y ago
In a world where you have SLAs with your customers, in which you commit to something better?
42.
▲
by
rosser
7y ago
I'm not quite sure what you're referring to with "glossolalia", offhand. The shamans I work with variously use a mix of Spanish, English, and Quechua, or Shipibo-Conibo, and although all of those (if moreso the indigenou
43.
▲
by
rosser
7y ago
Previously: https://news.ycombinator.com/item?id=19576425
44.
▲
by
rosser
7y ago
Thanks for your perspective, I appreciate it. I can see that being a legitimate read of the comment, if one punts on the guideline to assume good faith, and interpret people's arguments in the strongest light, rather than, e.g., dismis
45.
▲
by
rosser
7y ago
I think we're in agreement. This is him saying, "I think it's interesting enough to expend that effort." No one else has to agree, but that a mind like his thinks so, and based on what I've read of these accounts, I
46.
▲
by
rosser
7y ago
It's broken thinking to assume something is safe on the basis of a lack of proof otherwise. We have a pretty substantial body of research exonerating cannabis of a lot of the harms other drugs of abuse can bring. Literally no-one ever
47.
▲
by
rosser
7y ago
It's interesting to note that some time after writing this, Sagan became aware of the work of Jim Tucker, at the University of Virginia, attempting to validate the "past life" reports of children who've offered verifiabl
48.
▲
by
rosser
7y ago
Right, because it's clearly the domain name I take issue with, and not at all the literal lies that have been published under it.
49.
▲
by
rosser
7y ago
Would you care to speculate again about how much time I've spent reading their literature before this discussion? I promise you, it's non-zero. Please try not to dismiss people's positions that shallowly; it's a disser
50.
▲
by
rosser
7y ago
I do a lot of work with psychedelics. I'm very, very well aware of the power of consciousness-altering chemicals to have profound effects. That's kind of the whole point of using them. They should be respected but I don't s
51.
▲
by
rosser
7y ago
drugabuse.gov should probably not be considered an un-biased source on the topic of drugs of abuse. Some of their material will be propaganda and FUD.
52.
▲
by
rosser
7y ago
The association between cannabis and schizophrenia remains, as far as I'm aware, primarily statistical, and other factors like familial history are significantly more predictive. EDIT: That is, I don't think we have sufficient und
53.
▲
by
rosser
7y ago
I have worn a beard nearly continuously for approaching three decades, now. I used to keep my beard neat enough with a pair of scissors, a mirror, and few minutes every few days. Then I got a wet-dry trimmer that I used periodically in the
54.
▲
by
rosser
7y ago
Or turn it off. EDIT: Yes, that creates a data point that police could also search for — "give me all the phones in the vicinity that were turned off and then back on surrounding the incident." Okay, how far away? That would be a
55.
▲
by
rosser
7y ago
It's not a "conspiratorial plot", no. But time and again, research has shown that the implicit biases held by the people building these tools [0] are observable in the tool's results — and all people hold implicit biases
56.
▲
by
rosser
7y ago
> The researchers Joy Buolamwini at Massachusetts Institute of Technology in Cambridge and Timnit Gebru, then at Microsoft Research in New York City, showed that some of the most advanced facial-recognition software failed to accurately
57.
▲
by
rosser
7y ago
> ...for suggesting sea mammals have a "gland" that filters salt from water. No-one made any such suggestion. One person lamented that such a gland didn't exist; they did not assert its existence. The other person didn&#
58.
▲
by
rosser
7y ago
Just because you don't see a particular value in something does not mean it lacks that value for others. Frankly, I find this to be far more a "My way or the highway" kind of attitude than the quoted bit from The Fine Artic
59.
▲
by
rosser
7y ago
> ...if I wasn’t going to be with her, I had to let her go so she could find someone else. That's not an ultimatum, though I can see how it might read that way. She felt a need, which he wasn't meeting. She told him that if h
60.
▲
by
rosser
7y ago
It's not the same format, but here's a few slide decks from Bruce Momjian's site, describing PostgreSQL's internals: https://momjian.us/main/presentations/internals.html
More ›