Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
pg_bot
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
41 ms
·
601.
▲
by
pg_bot
8y ago
As written it would, but you could trivially adapt it to the subreddit level. Cache each subreddit the same way, then coalesce the results dynamically, which would still remove the main bottleneck of connecting to the db.
602.
▲
by
pg_bot
8y ago
What I'm advocating for is not to cache in RAM but as a file in something like S3. Build the full HTML page for a time period and store it as a blob, serve it to the user and have JS take over on the front end. You can use local storag
603.
▲
by
pg_bot
8y ago
Nah definitely not confused about the architecture, it's fairly simple to wrap your head around. What I'm advocating for is making the general site semi-dynamic instead of fully dynamic. (Break expensive caches at regular predefin
604.
▲
by
pg_bot
8y ago
If I were to design reddit I would have enforced the following rule to handle their scaling problems. You cannot touch the database when you are reading the homepage. Instead every minute we generate the canonical list of ~500 links that is
605.
▲
by
pg_bot
8y ago
Is this a new discovery? A few years ago I remember seeing water droplets navigating a maze in a youtube video but I don't know if they went into enough detail about how the mechanism worked.
606.
▲
by
pg_bot
8y ago
Looks awesome, already requested an invite and can't wait to put it in practice. The next thing that I really want from Stripe is an API for the analytics they generate. I would love to be able to display the data that they are already
607.
▲
by
pg_bot
8y ago
Based on the largest study currently available[0], there does not seem to be any evidence supporting a vegan or vegetarian diet having any protective effect on all cause mortality. There's a lot of pseudoscience in the health and welln
608.
▲
by
pg_bot
8y ago
Creating your own typeface seems a bit excessive. Here are the things that I would change based on my first reaction. - Remove the tail on the Uppercase "U" - Uppercase "I" and lowercase "l" are identical. - Re
609.
▲
by
pg_bot
8y ago
The pharmacist likely has a contract with the PBM that bars them from discussing cash prices with people who are covered by insurance. If the PBM finds out the pharmacy is circumventing them, they can void their contract which will likely p
610.
▲
by
pg_bot
8y ago
While both handle two factor authentication, Authy only assists with time based one time passwords (TOTP) which still leaves the end user open to phishing. These security keys are meant to be used with universal second factor (U2F) which pr
611.
▲
by
pg_bot
8y ago
Yes, I sleep during the day quite often. I currently work for myself, it's never been an issue for other people I've worked for.
612.
▲
by
pg_bot
8y ago
I'm the only person I've encountered that naturally runs on a 25 hour clock. I get the same amount of sleep per day (~8 hours) but I follow it with 17 hours of wakefulness so my clock moves forward by an hour every day. To my know
613.
▲
by
pg_bot
8y ago
My argument holds for gold as well. Do some research on ROI for gold against the stock market for the past 80 years. You will find that it has a pitiful return when compared to owning stocks. Gold is a non productive asset, just because peo
614.
▲
by
pg_bot
8y ago
There is a reason why an investor that holds a security until it is worthless is called a "bag holder". It makes no sense to "invest" in any currency when you can own productive assets instead. If you are concerned about
615.
▲
by
pg_bot
8y ago
Ideally, there would be an event emitted by the browser that could detect that a U2F key was inserted, but do to the design limitations of the key this is unlikely to happen. The U2F key is essentially a keyboard that has been plugged into
616.
▲
by
pg_bot
8y ago
Technically, nothing needs to be additionally configured for FIDO U2F to be implemented for an application. You just need to connect the key to your account and it should just prompt you to click the button when you need to sign in. If a co
617.
▲
by
pg_bot
8y ago
I think the greatest irony of our age is the progression of climate change due to environmentalists protesting against the development of nuclear power. While nuclear power admittedly has risks, the tradeoffs are clearly worth making if you
618.
▲
by
pg_bot
8y ago
I am still for single use, but if it is unused and the medicine expires people throw away the entire thing. The reason for replacement every 18 months is that the medicine expires, if you could just replace the medicine if you didn't u
619.
▲
by
pg_bot
8y ago
While there are other epinephrine auto-injectors on the market (auvi-q and adrenaclick) the big difference here is that this is considered a "generic" version of the EpiPen. The significance is that pharmacists can recommend that
620.
▲
by
pg_bot
8y ago
I don't understand why MoviePass doesn't just close up shop. Their popularity stemmed from selling a dollar for 50 cents. There is no business here, they should quit while they are behind.
621.
▲
by
pg_bot
8y ago
I find it shocking that anyone can defend the government of Venezuela with a straight face. The country is demonstrably worse today than it was before Chavez was elected. 90% of the country now lives in poverty, inflation is likely to reach
622.
▲
by
pg_bot
8y ago
No, it is a security key for universal second factor authentication. Read the spec[0] before you put on your tinfoil hat John. [0]: https://fidoalliance.org/specs/fido-u2f-v1.2-ps-20170411/FID...
623.
▲
by
pg_bot
8y ago
Economics is the study of how individuals, firms, and society make decisions to allocate limited resources to many competing wants.
624.
▲
by
pg_bot
8y ago
It is not evident that the [lack of] credentials of the person who designed the vessel contributed to its capsizing. This CNN article goes on to discuss the conditions during the day of the incident[0] The town was under a severe thundersto
625.
▲
by
pg_bot
8y ago
I've seen too many people fall into absolutism recently. Too many people disagree with someone on a single point and then discount everything they say based on that disagreement. If you are only handing out an "A" or an "
626.
▲
by
pg_bot
8y ago
Differential synchronization does not require a fixed polling interval. You can have real time updates as each party types, in fact the algorithm prefers this setup as it is easier to process a lot of small changes rapidly. Neil goes into f
627.
▲
The magic store
(gimletmedia.com)
2 points
by
pg_bot
8y ago
|
0 comments
628.
▲
by
pg_bot
8y ago
You can have multiple kiosks so you can parallelize the ordering process.
629.
▲
by
pg_bot
8y ago
I think in that case your ability to raise additional funds will be dependent on the persuasiveness of your argument. The investors would need to believe that you have a viable plan, and that you are the person who can execute it. If they d
630.
▲
by
pg_bot
8y ago
"Africa is poor because she is not free" - George Ayittey
More ›