Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
singron
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
24 ms
·
301.
▲
by
singron
3y ago
That's what we did. If you actually spent 50% of your CS degree on learning every nlogn sort, then you went to a particularly bad CS program.
302.
▲
by
singron
3y ago
In modern casual English it's very common to use present indicative in scenarios you would traditionally use other tenses (perfect or future) or moods (conditional or subjunctive).
303.
▲
by
singron
3y ago
In Postgres this effect is huge since there aren't primary indexes. All tuples for a table get mixed up together in the heap, so a large table will tend to having only 1 hot tuple per page. Additionally, every update and delete leaves
304.
▲
by
singron
3y ago
This also depends on whether you distro is using zlib or zlib-ng, which is significantly faster.
305.
▲
by
singron
3y ago
This is not true in postgres. When the second transaction tries to update the row, it will wait for the first transaction to commit first and then recheck the WHERE. https://www.postgresql.org/docs/current/transact
306.
▲
by
singron
3y ago
now() is the timestamp the transaction began at. There is no function to return the commit timestamp because you have to write the value before you commit.
307.
▲
by
singron
3y ago
Sometimes the fact that you can't change it is a great feature. Obviously if it's missing a critical feature, then you are screwed, but often these requests for customization are made because it seems like they are quick and cheap
308.
▲
by
singron
3y ago
Instructions to not _do_ things are conspicuously lacking from these trainings. We were instructed not to consider the legality of what we were doing, avoid using all the above language, and let the lawyers clean up afterwards if it's
309.
▲
by
singron
3y ago
E.g. thinkpads usually use a composite plastic (carbon/glass fiber), which makes them lightweight, durable, and thermally insulated from your body. Chromebooks definitely use the cheap stuff though.
310.
▲
by
singron
3y ago
With postgres, simple views are updatable, so you can often do this pattern without copying tables or dual writes. It's particularly useful for renaming columns, but you can also do some other things. You also don't have to use ve
311.
▲
by
singron
3y ago
2% interest on 500k is 10k by itself. If you take 40 years to pay the judgement, you will pay a lot more than 500k. For most people, this is basically a second very expensive mortgage. They might use a faster payment schedule and garnish yo
312.
▲
by
singron
3y ago
Google's fiber implementation is a take on that actually. Each fiber iirc is an actual thread, but there are some special syscalls that allow context switching to another specific thread and bypassing slow scheduling logic. This can sa
313.
▲
by
singron
3y ago
Why is the only image in this article a stock photo? "Images" is in the headline! Put an X-ray in the article!
314.
▲
by
singron
3y ago
I've heard before that a lot of GNU programs are stretched like this so that they don't resemble anything from proprietary AT&T unix. E.g. all the extra options in basically everything and the ridiculous optimization of things
315.
▲
by
singron
3y ago
It's pretty common to use present tenses in US English for events in the future or past. E.g. "I'm at the store the other day, and this guy comes up to me...", "I'm visiting the store later" Perfect tense
316.
▲
by
singron
3y ago
A "premise" is part of a logical argument. You want to say "premises", which refers to a location. I'm sorry to be that person.
317.
▲
by
singron
3y ago
If the ctrl and fn key positions bother you on other ThinkPads, my T14 has an option to swap them in the BIOS, and I imagine many other models do to. The model in the article can probably swap them back.
318.
▲
by
singron
3y ago
It probably wasn't the situation in your case, but I often give straightforward hints if the candidate is struggling with something that I don't want them to spend time on so we can get to the significant material. E.g. in an algo
319.
▲
by
singron
3y ago
It's kind of wild that the cops showed up ready to kill people for sitting down. Did disgruntled attendees exaggerate the danger when they called in (i.e. SWATing)?
320.
▲
by
singron
3y ago
You could also check out hazard pointers. This is basically the example used in https://melodiessim.netlify.app/intro-hazard-ptrs/
321.
▲
by
singron
3y ago
I recommend sampling traces if you aren't. I've been unimpressed with datadog apm, which has no affordable configuration. We've been running our own Jaeger stack with 0.1% sampling, and it's negligible to run compared to
322.
▲
by
singron
3y ago
I think everyone internalizes pets vs cattle a little differently, but I think people often don't realize that if you have cattle, then you now have a cattle ranch. I.e. you often create a new concept to manage your cattle, and you oft
323.
▲
by
singron
3y ago
If you have 1-2 engineers, then you have to build a product with a ruthlessly focused scope. Hopefully you do it well. If you have 20 engineers, then you have each one add new surface area each quarter, and then your app is 160 different th
324.
▲
by
singron
3y ago
I'll cut this thread short and Google it for you: > Archaea (/ɑːrˈkiːə/ (listen) ar-KEE-ə; SG: archaeon /ɑːrˈkiːən/ ar-KEE-ən) is a domain of single-celled organisms. These microorganisms lack cell nuclei and are
325.
▲
by
singron
3y ago
When do you think Sergey left? Wikipedia says he was president of alphabet until 2019, but I feel like he was sort of an absentee leader for years before that. Eric Schmidt was CEO until 2011. Larry Page was CEO until 2015 when Sundar becam
326.
▲
by
singron
3y ago
If you run a prepared query a few times, postgres will switch to a generic query plan. Sometimes the generic plan is much worse. I've never been able to fix this by running ANALYZE. I have been able to fix this by adding completely new
327.
▲
by
singron
3y ago
Scrubbing helps fix random errors in the drive data, but it won't prevent correlated disk failure. If a drive fails during the scrub, then you still have to replace the disk, and it's still very likely that another disk can fail i
328.
▲
by
singron
3y ago
The common rechargeable battery chemistries are 1.2 V (NiCd, NiMH), but a normal alkaline battery is 1.5 V. It usually works OK because the alkalines drop voltage quickly and devices are designed to operate in a lower range. If you can fit
329.
▲
by
singron
3y ago
Also 12 power supplies and 24 fans. That's up to 96 amps @220V or 21KW, although I imagine it draws less than half that since the power supplies are n+n redundant. If you were thinking about getting one for home, a circuit for a typica
330.
▲
by
singron
3y ago
We've done SOC2 type 1 and 2, and with a few exceptions, you only have to do what you say you do. First you claim you have controls on X, Y, Z, and then your audiors check that. You can just not claim X if you don't want to implem
More ›