Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
aeyes
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
25 ms
·
391.
▲
by
aeyes
4y ago
A cooling pipe started leaking and set the batteries on fire.
392.
▲
by
aeyes
4y ago
Do they have an official description what a zone is somewhere? Back in the days when we had our own data centers a zone was defined as a "fire section" meaning that it should not be impacted if any other zone of the data center ha
393.
▲
by
aeyes
4y ago
But europe-west9-a is only one zone, why does the whole region fall over as a consequence?
394.
▲
by
aeyes
4y ago
This is ancient knowledge and I would have agreed with you 15 years ago, today the only reason to not use an ORM is analytical queries. Since the Postgres planner doesn't really allow you to tune your query there aren't many ways
395.
▲
by
aeyes
4y ago
The amount of new grads and people coming in from other trades because they want a piece of the cake is high enough to keep supporting the flywheel. It would be interesting to see median age of engineers at tech companies, here it's de
396.
▲
by
aeyes
4y ago
If Apple disappears all push notifications will stop working, even the ones from apps you already installed. This is another restriction of the walled garden.
397.
▲
by
aeyes
4y ago
I have a 100k qps workload and we run 10 pgBouncer instances. I ran into the CPU limit with 6. Connections to pgBouncer are persistent so it's not caused by connection churn. The amount of incoming connections is in the low hundreds pe
398.
▲
by
aeyes
4y ago
Not too much if connections are persistent. A problem is that pgbouncer is 1 CPU only so you need a couple of them which makes the pooling less efficient.
399.
▲
by
aeyes
4y ago
I see 500k qps with 30TB data doubling every 2 years on slide 19. In my experience me this isn't close to being possible with a single Postgres box. There is no way around sharding this workload. Vitess has different consistency models
400.
▲
by
aeyes
4y ago
They are scaling down the workforce which is different from scaling down the operation. This might come next because as a business you obviously don't want to operate in a small market where the economies of scale don't work out.
401.
▲
by
aeyes
4y ago
I don't want to sound negative or discredit this contributor but having Asperger syndrome "helps". I got lost deep diving into several topics to the point where I spent almost all of my free time for a couple of years trying
402.
▲
by
aeyes
4y ago
No because they are only HTTP proxies. But you don’t actually know how these companies get them, rumor is that they are part of browser extensions or free VPNs which users might install on their devices. The most “reputable” company in this
403.
▲
by
aeyes
4y ago
Even though it won't help you now, instead of celery-once I highly recommend using the celery-redbeat scheduler which uses a distributed lock to ensure that only one scheduler instance is active. It's plug&play and compatible
404.
▲
by
aeyes
4y ago
If all you need is machines then there is still a massive benefit in using the cloud. You can spin up 1000 machines tomorrow without having to buy them, wait for getting them (2 months later), rack them, cable them, .... Especially if you n
405.
▲
by
aeyes
4y ago
Depends on how much abstraction you have, I have seen big companies where deploying code is basically like using Heroku. As an engineer responsible for a couple of services you don't need to know or care if this code is running on bare
406.
▲
by
aeyes
4y ago
Same experience here, they were even hooking us up with credits. Even when we were tiny they wanted to understand how we used AWS and were available to help with PoCs for products we weren't familiar with. I interviewed many people in
407.
▲
by
aeyes
4y ago
Each device has a key, the message is sent multiple times with different keys. > WhatsApp multi-device uses a client-fanout approach, where the WhatsApp client sending the message encrypts and transmits it N number of times to N number o
408.
▲
by
aeyes
4y ago
> Apple has paid a multi-million dollar settlement to a woman whose photos and videos were shared online by technicians repairing her iPhone. https://www.bbc.com/news/technology-57399627
409.
▲
by
aeyes
4y ago
This example is for a role but for IAM users it works the same way.
410.
▲
by
aeyes
4y ago
There are several tools which can be used with pre-commit, for example trufflehog.
411.
▲
by
aeyes
4y ago
I imagine that this is only for the grid production? If I charge my car with solar at home it won't move the meter, energy consumed by households with solar might not show up in the statistics. In reality renewable contribution might b
412.
▲
by
aeyes
4y ago
What kind of windmill do you have? I did some research to see if it would make sense as a homeowner and found it to be mostly not worth it. You shouldn't attach it directly to the building because wind speed near surfaces slows down si
413.
▲
by
aeyes
4y ago
Competition doesn't work, ISPs only care about high-profit dense areas. I bet that they are happy about services like Starlink because regulators are less likely to force them to provide service in remote areas because an alternative e
414.
▲
by
aeyes
4y ago
At least their managed Postgres service is running on Windows machines. I don’t know much about Azure but after seeing that I’m pretty convinced that most services they offer run on a Windows kernel.
415.
▲
by
aeyes
4y ago
It's not 400 miles and not 300mph but the Hong Kong to Shenzhen XRL line is underground, traveling at up to 350kph. https://www.hyd.gov.hk/en/road_and_railway/railway_network/x...
416.
▲
by
aeyes
4y ago
I wanted to say that the per-developer output has not slowed down significantly. But I admit that there are challenges. For example startup time is ~30 seconds because that's the time it takes to import everything. This automatically m
417.
▲
by
aeyes
4y ago
Most code has type annotations but we don't enforce it. A lot of code was written before typing became well supported and we never went back to add it to every old piece of code, we add them when people touch related code sections. Typ
418.
▲
by
aeyes
4y ago
Query and storage layer are nicely separated in the Postgres codebase, you can absolutely rip out the complete backend if you really want it. There is a Postgres interface to Spanner which probably did that.
419.
▲
by
aeyes
4y ago
Do you have any real world experience? I'm working on a Python codebase which is almost 2 million lines of code with almost 100 developers and I haven't seen development speed slow down over the years. Of course you need to have a
420.
▲
by
aeyes
4y ago
I'm not sure about the specifics but we had an account at SVB and weren't able to get it all out because of such limitations. I don't know exactly how the limits work because we definitely did ACH transfers in the millions be
More ›