Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
gfody
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
38 ms
·
481.
▲
by
gfody
6y ago
the accusation is that the mere act of searching a domain on godaddy increases the likeliness of it being sold by godaddy to some shady squatting service. the rebuttal is yeah because we use your searches to power our suggestions. the advic
482.
▲
by
gfody
6y ago
> completely unsubstantiated accusation a guy searched for a domain on godaddy and godaddy sold it - afaict that’s a fact. they obviously agree that it looks bad or they wouldn’t’ve bothered with this response.
483.
▲
by
gfody
6y ago
there's a thread here somewhere with an OG founder describing how they would seed entire threads emulating the sort of voice and attitudes they wanted to encourage. with that and technology like GPT3 (plus downright scary shit I'v
484.
▲
by
gfody
6y ago
honestly I don't see how it's not - do you want to be able to union an int with a float or something? there's sql_variant or you can make your own type but that's pretty gross, violates 1NF, and is the opposite of type-s
485.
▲
by
gfody
6y ago
> A row is an object and a row containing a reference to a row in another table is equivalent to an object containing another object if you're already thinking of it that way then it's a small jump to the result set as a set ,
486.
▲
by
gfody
6y ago
you can avoid nullable cols by using separate physical tables for each concrete type with surrogate PKs from a common sequence. these can be concatenated back together in a view (with no performance hit if you're careful not to hide in
487.
▲
by
gfody
6y ago
it came and went, postgres and sql server were (and still are) referred to as "object-relational" because of their support for rich user-defined complex types. it's just not that practical real-world because we tend to start
488.
▲
by
gfody
6y ago
postal address is one of those cases where you probably do just want to shove it all in a string as most structural constraints eventually backfire - especially if you support international: http://www.columbia.edu/~fdc/
489.
▲
by
gfody
6y ago
s3 just makes you work for it: - delete 1000 objects per post to /?delete - do this 100 times per connection - do this on a few threads per server to avoid being throttled - which entails keeping track of which servers you're usin
490.
▲
by
gfody
6y ago
or even faster https://github.com/peak/s5cmd
491.
▲
by
gfody
6y ago
> Just recognising and labelling the Ugh Field phenomenon can make it less bad, because it’s an accurate systemic explanation for what’s going on, rather than a misleading personal one like “I’m hopeless and never get things done”. great
492.
▲
by
gfody
6y ago
> This sounds tinfoil hat crazy https://www.thenewatlantis.com/publications/we-all-wear-tinf...
493.
▲
by
gfody
6y ago
turns out Neal Stephenson's Baroque Cycle is historical fact, whodathunk?!
494.
▲
by
gfody
6y ago
> it is isn't atomic merge is a single, logically-atomic statement in sql server (with or without hints) it doesn't have the same physical locking characteristics as a single insert or update statement, how could it?
495.
▲
by
gfody
6y ago
> The problem with merge is that it fails under contention, not under simple testing. that depends on so much else going on with your database - fine policy but when I said "test" I didn't mean whatever you mean by "s
496.
▲
by
gfody
6y ago
this has nothing to do with SQL Server. on SQL Server MERGE is atomic, if the source has no indexes it's probably a temp table, of course evaluating "not matched" requires joining the source to the target, on SQL Server you s
497.
▲
by
gfody
6y ago
with all due respect to Aaron, I've had this link shown to me by developers not wanting to write a simple merge statement instead of some block of semantically weird shit full of lock hints enough times for it to be annoying. be carefu
498.
▲
by
gfody
6y ago
> I think everyone already knows my opinions about MERGE not everyone is stuck on a 15-year-old version of SQL Server. odds are you can go ahead and use modern language features. I can understand why a DBA consultant that frequently enco
499.
▲
by
gfody
6y ago
I use MusicBee to listen to my di.fm subscription - the futures not bad
500.
▲
by
gfody
6y ago
is this an assumption or is there an actual source for the original statement - just curious as all I can find is a tweet from a suspended twitter account
501.
▲
by
gfody
6y ago
more better handling
502.
▲
by
gfody
6y ago
my thoughts as well, otherwise what was the point of casting it whole in the first place?
503.
▲
by
gfody
6y ago
some animals alternate sleep between each hemisphere, there's a bunch of examples of exotic sleep patterns in 'why we sleep'
504.
▲
by
gfody
6y ago
Weird that wiki doesn’t mention that it’s just the -oid suffix for “like” the same way we can call a non-square box a cuboid. The rest seems suspect eg anyone could’ve coined it.
505.
▲
by
gfody
6y ago
glitchin'
506.
▲
by
gfody
6y ago
ah the shit sandwich, I trust you're joking ;)
507.
▲
by
gfody
6y ago
if you don't want to rollback to the previous version you can also use safe mode (hold ctrl when you launch outlook)
508.
▲
by
gfody
6y ago
astral projection is just oobe and "experience" implies subjectivity w/no claim of objectivity and no corresponding onus or burden or anything
509.
▲
by
gfody
6y ago
lookup WILD (wake induced lucid dream) it's basically the practice of remaining conscious while falling asleep - techniques for dipping your toes in the void instead of leaping in head first
510.
▲
by
gfody
6y ago
there's a similar paper shared here a couple years ago: https://data.vision.ee.ethz.ch/aeirikur/extremecompression/ ..when compared to low bitrate dct-based compressors it looks impressive, but then compared
More ›