Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
zasdffaa
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
71 ms
·
811.
▲
by
zasdffaa
5y ago
This may be a terminological disagreement rather than something fundamental. You said > ... AGI might be philosophically impossible given that we do not seem to have a proven, accepted definition of GI. That says x might be impossible to
812.
▲
by
zasdffaa
5y ago
You conflate 'existence of x' with 'common agreement of existence of x'. Black holes existed decades/centuries ago but (from memory) there was no agreement they actually existed until gravity waves were detected jus
813.
▲
by
zasdffaa
5y ago
> AGI might be philosophically impossible given that we do not seem to have a proven, accepted definition of GI Strange argument. Just cos we can't define it doesn't preclude its existence. Once (pre modern chemistry) no-one kn
814.
▲
by
zasdffaa
5y ago
Appreciated. FYI Browsing articles this backs you up stongly, from https://erowid.org/library/books_online/pihkal/pihkal003.sht... "EXTENSIONS AND COMMENTARY: This specific compound is probably the first
815.
▲
by
zasdffaa
5y ago
> multiple times per week for months on end yes that is not use but abuse, and I'd expect bad consequences.
816.
▲
by
zasdffaa
5y ago
> They’re absolutely zero studies that show that these compounds are either safe or dangerous. Anyone saying that they’re either has a bias. Your ignorance does not indicate lack of research in the real world. < https://en.w
817.
▲
by
zasdffaa
5y ago
I've long wondered how Shulgin managed toxicity issues with new substances. There can be very little difference between something relatively safe and something very toxic (or even worse perhaps, cumulatively toxic) so that's very
818.
▲
by
zasdffaa
5y ago
Gotcha. It's a very different scenario from what I imagined and my suggestions don't apply. Agreed also your limited control on rewriting is limited and with the comment on clustered indexes. I do wonder how is it possible to run
819.
▲
by
zasdffaa
5y ago
OK... If the covering ix is as almost fat as the table there may be little benefit in it. If the original table can just fit in the ram but the orig table + covering index together can't, they may be fighting for space in ram which mea
820.
▲
by
zasdffaa
5y ago
Thanks, that's indeed my point. To clarify an earlier one where I said "The same query's behaviour can be utterly different depending on..." what I was saying was that the same query might be executed completely, tota
821.
▲
by
zasdffaa
5y ago
> Once you actually understand them, I feel you don’t need explain in most cases; you will simply ‘see’ why certain queries or definitions or structures are bad. Ummmm.... my experience pushes me strongly in the other direction. The same
822.
▲
by
zasdffaa
5y ago
IME just run the DB, pick up and look at the query plans for the most common/time consuming, then add indexes. That's 80% of it. So... > Is it a matter of having a conceptual model of relational algebra and the way the differen
823.
▲
by
zasdffaa
5y ago
> For example, SQL Server will create a temporary index on the fly if one is missing err, I may be misunderstanding but can you explain why you feel this? I have never (IME) seen MSSQL do this and it wouldn't make sense because cons
824.
▲
by
zasdffaa
5y ago
https://en.wikipedia.org/wiki/Sealioning
825.
▲
by
zasdffaa
5y ago
You can't admit other people have a valid objection so you just twist words and misrepresent others to avoid admitting your initial post was content-free and of no value. Please just stop.
826.
▲
by
zasdffaa
5y ago
> I see no citations. well, if you believe science has any value then we might agree on this < https://en.wikipedia.org/wiki/Scientific_method >
827.
▲
by
zasdffaa
5y ago
You don't say if you'd been to that country, or experienced anything relevant that you presented, or anything to explain why you felt this way. As such, you give me nothing to ponder on nor any reason to agree with you (or even
828.
▲
by
zasdffaa
5y ago
> ...I sense... That is not enough to base a post on.
829.
▲
by
zasdffaa
5y ago
Search 'diffraction spikes' IIRC
830.
▲
by
zasdffaa
5y ago
> SSD is fast enough that buffering SSD in RAM is mostly unnecessary. A very strong claim, which I'd contest depending on what you're caching. If it's application code then probably but if you've lots of data which yo
831.
▲
by
zasdffaa
5y ago
DB dev here with > 2 decades experience. This is just IMO and it depends on your needs, but these fit mine. If you're using SQL on small DBs you can probably get away with what you do, for large DBs that won't fly. Visual query
832.
▲
by
zasdffaa
5y ago
This is a respectable attempt at an answer (bar para 3 anyway) and exactly what I so rarely get. I just get shut down because "it's art" and you don't question it. It's art so it's beautiful, it's art so i
833.
▲
by
zasdffaa
5y ago
you attribute to art things which you don't define ("personal expression") and a function that cannot be measured and which you probably can't even define ("... growth in the people who engage with it"). '
834.
▲
by
zasdffaa
5y ago
> There is absolutely nothing wrong with a product not catering to everybody certainly agree > Even moreso when we are talking about a work of art. why does art get special consideration?
835.
▲
by
zasdffaa
5y ago
Perhaps you can't read. I said "...some responsibility..." That's because I don't believe it's "...all on parents". You can win any argument by misquoting the other person but nothing actually gets re
836.
▲
by
zasdffaa
5y ago
Can't parents acknowledge they have some responsibility towards their own children and not give just blindly give them laptops and phones and expect someone else to clean up the mess after them. Same stupid shit happening here in the U
837.
▲
by
zasdffaa
5y ago
Nice breakdown, thanks.
838.
▲
by
zasdffaa
5y ago
A Microsoft are very good at telling you (usually) what's there but they don't like telling you what's missing or what's inconvenient to use. Or indeed, what they have downright deliberately broken. The documentation qua
839.
▲
by
zasdffaa
5y ago
Please post useful information rather than blanket 'nope'. If there are so many, name the top 3 (say) or I can't learn anything.
840.
▲
by
zasdffaa
5y ago
JS disabled here and all I can see imagewise is the single mugshot of the author. Apparently you need javascript to show pictures. Is this deliberate perhaps. I wonder how much the JS weighs.
More ›