Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
bddicken
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
7 ms
·
91.
▲
by
bddicken
2y ago
I actually built this primarily with chatGPT o1. One of the things LLMS are really good at is writing scripts for processing and pairing down data. I wanna do a blog post talking about how did some of this, maybe coming up!
92.
▲
by
bddicken
2y ago
[OP] Backblaze writes about these data sets, and includes some more conventional graphs. For example: https://www.backblaze.com/blog/backblaze-drive-stats-for-202... I wanted to do something more fun!
93.
▲
12 years of Backblaze data center storage drives, visualized
(benjdd.com)
147 points
by
bddicken
2y ago
|
47 comments
94.
▲
Microsoft Azure data center latencies, visualized
(benjdd.com)
4 points
by
bddicken
2y ago
|
0 comments
95.
▲
Show HN: I made a tool to navigate your GitHub repo files
(repofiles.com)
2 points
by
bddicken
2y ago
|
1 comments
96.
▲
Database Sharding
(planetscale.com)
2 points
by
bddicken
2y ago
|
0 comments
97.
▲
by
bddicken
2y ago
At PlanetScale, we have a really nice solution for this in MySQL using SPANN + SPFresh. The way we've implemented it allows for pre and post filtering, full compatibility with where clause filtering, and has the same kind of acid compl
98.
▲
by
bddicken
2y ago
Tweet OP here: Very good analysis, thanks for sharing.
99.
▲
by
bddicken
2y ago
Author here: Yeah, the mod was added to reduce risk of loop(s) getting optimized away.
100.
▲
by
bddicken
2y ago
Author here: Yeah, I was surprised that there doesn't seem to be many options for extra optimizations in the Go compiler. Would be curious if Go experts have more insight or other compiler recommendations.
101.
▲
by
bddicken
2y ago
Yeah :/ That's what I had on my local machine, and I did not upgrade for this test. I have heard that things have gotten better in python 3.13. Regardless, I did include PyPy that shows it can at least be reasonably fast.
102.
▲
1B Nested Loop Iterations
(benjdd.com)
7 points
by
bddicken
2y ago
|
4 comments
103.
▲
JavaScript, Python, Go, and C
(benjdd.com)
1 points
by
bddicken
2y ago
|
0 comments
104.
▲
Visualizing how storage cost changes over time
(benjdd.com)
1 points
by
bddicken
2y ago
|
0 comments
105.
▲
by
bddicken
2y ago
Just pointing out that what you're paying for is actually 3x these resources. By default you get a primary server and two replicas with whatever specification you choose. This is primarily for data durability, but you can also send que
106.
▲
AWS us-east-2 latencies, visualized
(benjdd.com)
1 points
by
bddicken
2y ago
|
0 comments
107.
▲
by
bddicken
2y ago
Cool, thank you for the input.
108.
▲
by
bddicken
2y ago
Author here - You can see the raw data as a table here: https://www.cloudping.co . Sometimes visualizations like this are a careful act of balancing practicality with cool-factor.
109.
▲
by
bddicken
2y ago
Author here - thank you!
110.
▲
by
bddicken
2y ago
Author here - If you have a resource that provides good data on Azure or GCP latencies, please send them my way.
111.
▲
by
bddicken
2y ago
Author here - The data came from https://cloudping.co , and the GitHub repo has not been updated in 4 years. See https://github.com/mda590/cloudping.co . Is that a newer data center? The CloudPing site is def
112.
▲
by
bddicken
2y ago
Author here - Thank you for the compliment.
113.
▲
by
bddicken
2y ago
Author here - The data used was scraped from https://cloudping.co . You can find more info on the GitHub repo: https://github.com/mda590/cloudping.co .
114.
▲
by
bddicken
2y ago
Author here - yeah, I came across that when I was digging for data I could use for this. It's cool.
115.
▲
by
bddicken
2y ago
Author here - it is quite cool.
116.
▲
by
bddicken
2y ago
Author here - I just used what was available on https://www.cloudping.co , which is certainly missing a few. The CloudPing GitHub repo has not had a code change in 4 years. Maybe a few new regions have popped up since it was last
117.
▲
by
bddicken
2y ago
Author here - Cool and useful is a careful balancing act.
118.
▲
by
bddicken
2y ago
Author here - The ramping is a really good idea. The current visualization makes a 90ms latency look "good" when in reality, thats totally unacceptable for many applications, especially for things where multiple round-trips need t
119.
▲
by
bddicken
2y ago
Author here - Thanks for the suggestion Alex. From your perspective, what are some of the best ways you've seen people solve for this in the past? If you have links, please share.
120.
▲
by
bddicken
2y ago
Author here - Interesting. Someone on X also gave this idea to me. Any good resources for how to accurately compute this?
More ›