How I attacked myself with Google Spreadsheets (2012)
11–20 of 32 posts
Re: How I attacked myself with Google Spreadsheets (2012)
#12[1] https://developer.mozilla.org/en-US/docs/Web/HTTP/Content_ne...
Re: How I attacked myself with Google Spreadsheets (2012)
#13I'll just say I found it to be a highly entertaining and well-written account of a nightmare scenario I think many of us here can relate to: The unexpected and unexplained exploding AWS bill.
Re: How I attacked myself with Google Spreadsheets (2012)
#14I REALLY REALLY want someone to do this with a huge amount of google image thumbnails so that the google crawlers just start hitting google servers. Would it be considered malicious to do such a thing?
Maliciousness is usually described in the context of intent. So your first sentence should provide the answer to your own question. Is there a way to do what you describe such that the result is gratifying and yet doesn't cause significant duress on Google's servers and employees?
Re: How I attacked myself with Google Spreadsheets (2012)
#15Re: How I attacked myself with Google Spreadsheets (2012)
#16I know Google has cheaper bandwidth than most, but it's still amazing that they are willing to pull 250gb every hour of every day for a single, free spreadsheet.
I suspect Google is very transmit heavy on bandwidth usage. Peering agreements tend to sweeten as your rx/tx ratio approaches 1, so increasing rx on the network makes it easier to establish a peering arrangement, avoiding the need to purchase transit.
Re: How I attacked myself with Google Spreadsheets (2012)
#17Previous discussion (763 points, 143 comments). For some reason this doesn't show up in the "past" search results but shows up if you search for the domain. https://news.ycombinator.com/item?id=3890328
Old title: "How I attacked myself using Google and I ramped up a $1000 bandwidth bill"
I think that the problem is that Algolia looks for results with all the words, the new title has the word "Spreadsheets" that is not in the old title.
I think Algolia has an option to allow variations and typos in words, but not an option to match most of the words (like 4 of 5 words).
Re: How I attacked myself with Google Spreadsheets (2012)
#18Does anyone know if Google ended up changing their behavior on this? I'm struggling to see why this is a legitimate design decision on their part - how is downloading a new copy every hour different from maintaining a persistent cache wherever they are storing it after download?
> Since these URLs are private, Google does not want to store them anywhere permanently in the Google servers.
Re: How I attacked myself with Google Spreadsheets (2012)
#19> What I find fascinating in this setting is that Google becomes such a powerful weapon due to a series of perfectly legitimate design decisions. It does have a certain "perfect storm of good intentions" quality, but no, "prefetching" hundreds of gigabytes worth of images that the user is not looking at right now* and that will not be cached for the next time the user views it, that the user did not indicate will be…
Edit: I also grabbed 3 different images and put them in a separate sheet. I'm gonna leave one open on my desktop and not open the other and see if that changes the requests.
One Hour Later: I think that Google is probably grabbing images On-Demand now. There are 12 total requests on my 6 images. The first 6 are sporadic, which correspond to when I added the images to the sheets. Then the next 3 are in the same second, which come from opening the sheet on my desktop. And the last 3 also came in the same second, again from opening that sheet on my desktop. I kept one open and closed the other and neither have had the images requested since.
Re: How I attacked myself with Google Spreadsheets (2012)
#20I know Google has cheaper bandwidth than most, but it's still amazing that they are willing to pull 250gb every hour of every day for a single, free spreadsheet.
Welcome to the wonderful world of network peering. I suspect Google is very transmit heavy on bandwidth usage. Peering agreements tend to sweeten as your rx/tx ratio approaches 1, so increasing rx on the network makes it easier to establish a peering arrangement, avoiding the need to purchase transit.