Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
singron
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
31 ms
·
451.
▲
by
singron
4y ago
Church membership is down, but there may be other thresholds of devoutness that are up. It may also be that the devout have become more political rather than more numerous or that there is no trend of religion in politics at all. https:&#x
452.
▲
by
singron
4y ago
If you think a table might get anywhere near this size (blobs or not), I highly recommend table partitioning.
453.
▲
by
singron
4y ago
Down rounds are bad for employee morale too since it puts previously issued options below water. It's probably worth it to re-issue equity, but that's messy and a lot of companies don't do it.
454.
▲
by
singron
4y ago
Only if PATH includes ".", which is why they say not to do that (or use windows. I'm not sure if you can fix that there).
455.
▲
by
singron
4y ago
They already had limits on simultaneous streams. I think they are limiting the number of TVs that can use the app, and then they will continue the quality downgrades on the non-TV platforms.
456.
▲
by
singron
4y ago
I cannot tell if this is a joke.
457.
▲
by
singron
4y ago
Is there case law on this? The CA moonlighting law heavily implies that a huge company could claim to own nearly anything you produce (as an exception that proves the rule). > (a) Any provision in an employment agreement which provides t
458.
▲
by
singron
4y ago
An update in postgres will always copy the tuple for MVCC, so it can't take advantage of an optimization like this to modify it in place.
459.
▲
by
singron
4y ago
The warrant lets law enforcement look for and seize things. It doesn't necessarily compel the target of the search to perform an action. Normally you would oblige the officers since otherwise they would just cut open your locks, but wi
460.
▲
by
singron
4y ago
By predictably bad, it means that the model said it would be bad and it was bad. There are also "unpredictably bad" outcomes. E.g. if 19 out of 20 that are about to receive investment are bad, the claim is that the model could ide
461.
▲
by
singron
4y ago
The air is dry in California so it has a huge capacity to absorb moisture from transpiration or evaporation. The prevailing winds will carry the water hundreds of miles or more before it precipitates. They water crops year round, but there
462.
▲
by
singron
4y ago
You could evaluate the interviewer that way, but IMO it's more valuable to evaluate the interview process since that will apply to everyone you would work with. If the interview is easy, expect to work with warm bodies.
463.
▲
by
singron
4y ago
Another idea is serialization. You release your work little chunks at a time, and if it's not sufficiently supported financially, you stop. A lot of Patreon is effectively funded like this. Obviously the medium has to be amenable to th
464.
▲
by
singron
4y ago
Btw this procedure doesn't work for partitioned tables. For some reason, it locks the table and does a table scan anyway. The workaround we came up with was to add check constraints for instant partition attachment, lock the table, det
465.
▲
by
singron
4y ago
The world described in LoTR is not physically like ours. For instance, the orcs aren't described as bad guys because of their upbringing, culture, or subjective perception by the other races. Orcs are intrinsically evil. All the bad cr
466.
▲
by
singron
4y ago
The situation I'm describing is with vsync enabled. This problem is not solved by vsync and mostly goes away if you turn vsync off, since then it acts more like mailbox present mode at the expense of 100% utilization. Vsync solves tear
467.
▲
by
singron
4y ago
Depending on the graphics api, something needs to sleep somewhere to get decent latency. E.g. in vulkan, if the present mode is fifo, then rendering frames as fast as possible will fill the swapchain with stale frames that won't be pre
468.
▲
by
singron
4y ago
It would be awesome if SOC2 wasn't a joke and you could expect customers to accept that instead of answering endless superficial questionnaires. Then you could charge $5000 per questionnaire if they still really wanted it.
469.
▲
by
singron
4y ago
As someone from Colorado, the no-salary listings are basically a disqualifier since it demonstrates that the company is willing to break the law to try to take advantage of you.
470.
▲
by
singron
4y ago
It's covered in the article, but serialization just has to appear to execute in any sequential ordering of transactions. There are no other constraints about the ordering, so it technically allows the print to appear to run before the
471.
▲
by
singron
4y ago
Sorry for replying very late. I've used a similar technique of locking a "parent" row while adding items to a corresponding set. It works great as long as you can figure out a relationship like that and it's fine-grained
472.
▲
by
singron
4y ago
You really aren't talking about the same thing. It's not like you can add 100 housing units to an area one time and achieve affordable housing indefinitely. The housing units have to be added to meet increases in demand. The idea
473.
▲
by
singron
4y ago
Yes can repeat any string, not just "y". It can be useful for basic load generation.
474.
▲
by
singron
4y ago
Google's Borg clusters don't have wildly larger sizes than that despite having more years of development and a lot of motivation at that scale. They instead have a lot of clusters and transparent inter-cluster network topologies (
475.
▲
by
singron
4y ago
Wood used for this purpose is almost definitely dried (either naturally or with a kiln) and will thenceforth seek equilibrium with its environment. It's pretty unusual to use green/undried wood for anything, although I've hea
476.
▲
by
singron
4y ago
You don't, but if your cursor is just a position in some well-defined order, you can sometimes craft a cursor out of a known position. Continuing the book metaphor, instead of skipping to page 100, which has no semantic meaning, you co
477.
▲
by
singron
4y ago
Missing data that began existing after you started querying is usually OK. If you had requested the data 1 second earlier, it wouldn't have been returned anyway. With offset pagination, you can miss data that always existed. This can m
478.
▲
by
singron
4y ago
Idk about this one, and 10x sounds past physical limits unless their original footprint was ridiculous, but I heard a story at Google that sounded kind of like this. I think there was some colo in the day that charged only by sqft and gave
479.
▲
by
singron
4y ago
The dues are also 1% of total compensation, which includes bonuses and RSUs at Google. For the bulk of L3/L4 Googlers, this is $1800-$2600 per year. This is typical for union dues on a percentage income basis, but very high on an absol
480.
▲
by
singron
4y ago
I don't think the paragraph metaphor works well since written works are often read front to back, and the organizational hierarchy isn't so important on such a linear medium. There are books that buck the trends and IMO you don&#x
More ›