Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
znep
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
9 ms
·
31.
▲
by
znep
7y ago
It also allows you to prewarm a read replica before sending queries to it. You can also do this by slowly ramping up traffic to it (and may want to do that anyway for other reasons) but depending on the app and query patterns, that by itse
32.
▲
by
znep
7y ago
My phone line was down for 4 days because they accidentally disconnected it when hooking someone else up and it took them that long to fix.
33.
▲
by
znep
7y ago
Hopefully they actually finish this at some point to be useful by showing utilization and not just quotas. For the handful of things I looked at, other than lambda which they use in their example, utilization just displays "-".
34.
▲
by
znep
7y ago
SSD on a 2016 macbook pro. The timing coincides exactly with the FS (and OS...) upgrade.
35.
▲
by
znep
7y ago
I wouldn't expect that level of disk IO to cause issues dragging existing windows around without some deeper lock contention or something, it does not behave like just IO bound. Stuff being slower, totally, but not to this level. It
36.
▲
by
znep
7y ago
Hopefully somehow maybe while they are in there they might do something to fix the nasty system lockups I have seen when starting both time machine and carbon copy cloner backups since switching to APFS. I'm assuming it is related to
37.
▲
by
znep
7y ago
Reading between the lines of their status history is also interesting: https://status.docker.com/pages/history/533c6539221ae15e3f00... Their message seems to be missing the "which Hub accounts are impacted&qu
38.
▲
by
znep
7y ago
Another interesting thing to watch in the electric airplane space is Harbor Air and magniX. https://www.harbourair.com/harbour-air-and-magnix-partner-to... The float plane business seems to make a lot of sense in this regar
39.
▲
by
znep
7y ago
An interesting postgres oddity I ran into a few years ago that isn't about counting but is in a similar arena is how under very specific circumstances, "SELECT *" is significantly faster than "SELECT one_column" des
40.
▲
by
znep
8y ago
I would guess the pricing model is actually closely related to the main dimensions of their costs and is quite valid. The key point is illustrated by this quote from their main landing page: "storage and compute are decoupled, allowing
41.
▲
by
znep
8y ago
They don't have to fully maintain it on their own. Packaging their own openjdk distribution gives them control over timely targeted bug and security fixes even if they don't have "JVM experts" working on it. I'm n
42.
▲
by
znep
8y ago
The list of specific patches applied is here: https://docs.aws.amazon.com/corretto/latest/corretto-8-ug/pa... Looks to be mostly or maybe entirely backports. Good to see another option out there, it will be i
43.
▲
by
znep
8y ago
As far as I understand, Red Hat plans to take the lead on supporting a LTS version of OpenJDK 8 after Oracle steps down, with the intent to eventually do the same with 11. Various organizations such as AdoptOpenJDK will then be making rele
44.
▲
by
znep
9y ago
Are you the Mat Keep who is Director of Product Marketing at MongoDB? If so then, FWIW, people don't often respond well to marketing links posted without identifying your connection to the company.
45.
▲
by
znep
9y ago
I'm not clear what you are trying to suggest with that link. The whole point of the claim in the article around sorting is that in Aurora, for using disk to sort, postgres only has access to a relatively small filesystem that runs out
46.
▲
by
znep
9y ago
The reasons I couldn't live happily without swap on my development machine: - Macbook Pro's don't have a lot of RAM. Still. (Let's not get into that whole discussion as valid as it may be, that is far from the biggest
47.
▲
by
znep
9y ago
For an example of a somewhat similar project, see Austin's bluetooth traffic sensor data: https://github.com/cityofaustin/hack-the-traffic/tree/master... They used to have the code used to anonymize the
48.
▲
by
znep
9y ago
Exactly. I'd go further and say the burst capacity is actually a super useful and powerful feature that is very hard to get on your own hardware. Definitely can catch you unaware if you aren't on top of it and can get expensive
49.
▲
by
znep
9y ago
Not any more, as of some number of months ago you can grow and change volume type on the fly especially if it isn't a boot volume. http://docs.aws.amazon.com/AWSEC2/latest/UserGuide/ebs-expan... Read the
50.
▲
by
znep
9y ago
Does anyone have any real world experience with how the Amazon DynamoDB Accelerator that AWS released as a preview a few months ago can help out?
51.
▲
by
znep
9y ago
The biggest reason I've found for using a database as a queue is that you can actually run queries against it, both writes and reads. This is very useful when different entries in the queue can have some relationship that matters when
52.
▲
by
znep
10y ago
Just setting https_proxy isn't going to give you any caching benefits for https requests and isn't going to MITM TLS in any way. The client will make a CONNECT request through to the destination and the encryption is end to end a
53.
▲
by
znep
10y ago
From reading what you wrote, what I think you are talking about is statement caching where it can cache the "how do I run this" but still has to read each row (or indexed row) from the buffer cache. The mysql query cache actually
54.
▲
by
znep
10y ago
True point (disclaimer: don't know how mysql has evolved in the past 5 years). Fits with my general feeling of "if you want to optimize for a super specific use case, sometimes mysql can provide some cool tricks for that use case
55.
▲
by
znep
10y ago
While that is true and the mysql query cache definitely became a scaling issue as machines got bigger with lock contention etc., postgres doesn't even have a similar feature period. Suppose you have a query that is doing a group by on
56.
▲
by
znep
10y ago
Absolutely. The only thing that demanding total transparency gets you is hidden private groups. Private conversations will happen one way or another. From the outsider's perspective, the important thing is to make it explicit that t
57.
▲
by
znep
10y ago
This is a horrible interview question for all but a tiny handful of jobs: Is 300.168.0.123 a valid IPv4 address? ...but it is a great late night fun trivia question about "how can adding one character to that address make it int
58.
▲
by
znep
11y ago
This has been in beta for a while, the key thing lacking for our uses, at least with postgres, was full support for DDL. The lack of "true" replication into postgres RDS instances is one of the things blocking us from fully using
59.
▲
by
znep
11y ago
If you didn't catch it, AWS now supports upgrades between so-called "major versions" (eg. 9.3 -> 9.4). https://aws.amazon.com/about-aws/whats-new/2015/11/rds-postg...
60.
▲
by
znep
11y ago
As long as you don't have too many microservices... the polling and templating doesn't scale too well. This is related to https://github.com/hashicorp/consul-template/issues/165#issu... although tha
More ›