upvote
BigQuery has "public datasets", so users can even run complex SQL on it, but it's them who pays for it, not you. You only pay for data storage.
reply
The crawlers would have still just hammered their site though, right?
reply
I think the idea is that they could store the data in BigQuery, and point users of the site there.
reply
Sure, but now you're moving the site from "Free data presented in a pleasant way to view" to a "pay-as-you-go database". Your audience shifts dramatically, and you lose the ability to share the data you're trying to present.
reply
True. But it sounds like they already lost that.
reply
The crawlers would have still just hammered their site though, right?
reply
Why is your comment exactly word for word of another comment just one level above in the comment chain?
reply
Maybe because they restated what they said instead of addressing to the previous commenter’s point.
reply
Because the crawlers would still have hammered their site, though.

(The GP post doesn’t actually meaningfully address the issue being raised. Adding BigQuery or whatever would not change the fact that (a) they already offered a method of getting all of the data in a cost effective way, and (b) the issue was that the crawlers hammered the site hard enough to make it economically unviable.)

reply
I think snowflake has similar, you can rent it out or make it free
reply
Building on AWS is a financial time bomb.
reply
Are you not able to put limits on how much the site can spend?
reply
As of 2026, still not, and probably never.
reply
Sure, but many a hobbyist has discovered the need for that the hard way.
reply
deleted
reply
Do you have any view on why the AI scrapers resulted in a heavier load than existing crawlers from eg search engines?

Where they more exhaustive or more frequent?

reply
There's been an explosion of vibe-coded scrapers that behave poorly and ignore robots.txt. Presumably OP disallowed crawling of the search endpoint for the reason stated (that crawling it would result in endless permutations of search filters.)
reply
not the OP but I'd say that google crawls you once and AIs scrape your page every time someone asks them a question that they think your page might be relevant to.
reply