News for hackers. Stuff that matters.
Re:What happened to TheNumbers.com by primitivesuave on Thursday July 23, 2026 @02:32PM (#49026105)
A couple years ago, I was running a website which allowed the public to view all the US government handouts to small businesses during the COVID-19 pandemic. It also tracked all the fraudulent loans being prosecuted by the DOJ, and allowed anyone to run structured queries over the public dataset. There was a "donate" button which took in ~$2k in donations over the lifetime of the site, and you could download the entire underlying dataset (around 10 GB uncompressed) for free directly on the site.

Despite the "download all data" link being prominently placed on the front page, the AI scrapers decided it would be more efficient to download terabytes upon terabytes of raw HTML by paginating through every possible facet on the search endpoint. Even with CloudFront caching results and a fairly efficient backend setup, the monthly bill ended up with around $1k just going toward network ingress/egress, so I shut down the site the following month.

Re:What happened to TheNumbers.com by deepsun on Thursday July 23, 2026 @03:06PM (#49026561)
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.
Re:What happened to TheNumbers.com by dpoloncsak on Thursday July 23, 2026 @03:33PM (#49026893)
The crawlers would have still just hammered their site though, right?
Re:What happened to TheNumbers.com by pavel_lishin on Thursday July 23, 2026 @03:52PM (#49027130)
I think the idea is that they could store the data in BigQuery, and point users of the site there.
Re:What happened to TheNumbers.com by dpoloncsak on Thursday July 23, 2026 @04:10PM (#49027363)
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.
Re:What happened to TheNumbers.com by pavel_lishin on Thursday July 23, 2026 @04:46PM (#49027810)
True. But it sounds like they already lost that.
Re:What happened to TheNumbers.com by deepsun on Thursday July 23, 2026 @10:50PM (#49030715)
No, it's free for everyone for the data sizes they have:

Free tier: 10 GB of active storage and 1 TiB of query data processed per month.

Re:What happened to TheNumbers.com by PunchyHamster on Thursday July 23, 2026 @04:00PM (#49027238)
The crawlers would have still just hammered their site though, right?
Re:What happened to TheNumbers.com by 40four on Thursday July 23, 2026 @04:34PM (#49027668)
Why is your comment exactly word for word of another comment just one level above in the comment chain?
Re:What happened to TheNumbers.com by gorgonian on Thursday July 23, 2026 @04:48PM (#49027847)
Maybe because they restated what they said instead of addressing to the previous commenter’s point.
Re:What happened to TheNumbers.com by 40four on Friday July 24, 2026 @12:52AM (#49031333)
The comment I’m speaking of was from a different user, and it’s giving a strong smell that both users are bots unfortunately. Maybe I’m wrong, maybe it’s a coincidence those exact strings of characters were formed in isolation from each other in the same thread. I hope I’m wrong, but it’s a red flag
Re:What happened to TheNumbers.com by dpoloncsak on Friday July 24, 2026 @09:00AM (#49034930)
I'm not a bot, and the other commenter was restating the question as the solution provided did not seem to actually solve the problem, just redesign the entire project (See comment from u/taneq).

We didn't form "those exact strings of characters in isolation from each other in the same thread" they are directly referencing my comment in a reply thread to said comment.

Re:What happened to TheNumbers.com by taneq on Thursday July 23, 2026 @04:46PM (#49027802)
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.)

Re:What happened to TheNumbers.com by PunchyHamster on Saturday July 25, 2026 @05:53AM (#49046179)
Because I am pointing out that the same exact thing would still happen even when commenter's "fix" would be applied.

You're bad at understanding context. Word for word was just me poking fun at that comment

Re:What happened to TheNumbers.com by tekne on Thursday July 23, 2026 @06:51PM (#49029135)
There is also the deep magic...

https://github.com/phiresky/sql.js-httpvfs

Re:What happened to TheNumbers.com by primitivesuave on Friday July 24, 2026 @03:04AM (#49032110)
I'm curious how this compares to just using DuckDB in the browser?

https://duckdb.org/2021/10/29/duckdb-wasm

Re:What happened to TheNumbers.com by tekne on Monday July 27, 2026 @10:53AM (#49070560)
Different pros and cons -- SQLite is smaller is the big one
Re:What happened to TheNumbers.com by primitivesuave on Thursday July 23, 2026 @06:42PM (#49029052)
Yes, if I wanted to put a nice HTML interface over the query results then I would still end up with the same problem where some combinatoric explosion of query parameters to the `/search` endpoint, most of which are cache misses, leads to many many TBs of network egress.
Re:What happened to TheNumbers.com by lokar on Thursday July 23, 2026 @04:33PM (#49027652)
I think snowflake has similar, you can rent it out or make it free
Re:What happened to TheNumbers.com by primitivesuave on Thursday July 23, 2026 @06:41PM (#49029036)
Thanks for that tip, this is exactly how I would do this if I had to do it from scratch. Just in case it's useful for anyone else: https://docs.cloud.google.com/bigquery/public-data
Re:What happened to TheNumbers.com by tailscaler2026 on Thursday July 23, 2026 @02:55PM (#49026411)
Building on AWS is a financial time bomb.
Re:What happened to TheNumbers.com by ninalanyon on Thursday July 23, 2026 @04:08PM (#49027334)
Are you not able to put limits on how much the site can spend?
Re:What happened to TheNumbers.com by shermantanktop on Thursday July 23, 2026 @04:12PM (#49027388)
Sure, but many a hobbyist has discovered the need for that the hard way.
Re:What happened to TheNumbers.com by mystifyingpoi on Thursday July 23, 2026 @04:58PM (#49027977)
As of 2026, still not, and probably never.
Re:What happened to TheNumbers.com by primitivesuave on Thursday July 23, 2026 @06:35PM (#49028970)
Completely agree, I've worked at several companies where I saw the AWS bill balloon from five to six figures, usually because of pointless over-provisioning. However, it all became worth it when I saw Jeff Bezos go to space. [1]

1. https://www.youtube.com/watch?v=IOmX793-5t4

Re:What happened to TheNumbers.com by BeeOnRope on Thursday July 23, 2026 @03:07PM (#49026571)
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?

Re:What happened to TheNumbers.com by pverheggen on Thursday July 23, 2026 @03:54PM (#49027164)
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.)
Re:What happened to TheNumbers.com by ratelimitsteve on Thursday July 23, 2026 @03:12PM (#49026631)
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.
Re:What happened to TheNumbers.com by primitivesuave on Thursday July 23, 2026 @06:29PM (#49028919)
They were both more exhaustive and more frequent. I don't remember the exact numbers, but it was definitely over 100x the traffic from search engines. By the way, search engines were allowed under robots.txt - I did want all 11.5 million loans to be individually indexed so they would pop up in Google search results, and I actually did receive/forward multiple tips about fraudulent loans because someone searched a business name on Google. All of this traffic was barely a blip, and my AWS bill for my hobby data science account was only ~$50-$100/month.

When I looked at the logs after getting the billing alert, 99.99% of the requests were to the "/search" endpoint with virtually every permutation of ~10-12 facets in the query parameters. There was only one scraper, but it triggered an enormous amount of network egress since it ended up missing the cache on the majority of queries.

Re:What happened to TheNumbers.com by x3haloed on Thursday July 23, 2026 @05:11PM (#49028112)
That’s a traffic design problem. You should be happy that your work is valuable and also protected it against excessive requests. Simple.
Re:What happened to TheNumbers.com by primitivesuave on Thursday July 23, 2026 @06:52PM (#49029146)
I deployed a Lambda function behind CloudFront which rendered a simple HTML page with the query results from executing some SQL over the dataset. I served millions of page views for next to nothing because most pages were already in the cache.

I don't know where you get this expectation that people should anticipate that a crawler might try every possible combination of query parameters, thereby missing the cache on each one. Most people consider it a bitter and arrogant perspective, which is why this got downvoted.

Re:What happened to TheNumbers.com by sillysaurusx on Thursday July 23, 2026 @10:35PM (#49030637)
For what it’s worth, a Hetzner dedicated server has unlimited ingress and egress. It seems like it’s the only provider that does. Egress fees suck.

You can get a beefy one for about $40/mo on their server auction site.

Just... don’t miss payments. Ever. Or they’ll delete your server within a week or so.

Re:What happened to TheNumbers.com by usernameak on Sunday July 26, 2026 @08:33AM (#49057496)
Only if you get gigabit networking (which can transfer only so much in a month). If you get 10Gbit/s, it's not unlimited anymore.
Re:What happened to TheNumbers.com by sillysaurusx on Sunday July 26, 2026 @03:07PM (#49061310)
Could you link to anything supporting that claim? I can’t find it.
Re:What happened to TheNumbers.com by usernameak on Sunday July 26, 2026 @05:27PM (#49062587)
On the 10G Uplink documentation page: https://docs.hetzner.com/robot/dedicated-server/network/10g-...

> The included traffic volume for outgoing traffic is 20TB. There is no bandwidth limitation. Overusage is billed with € 1.00 ($ 1.20)/TB. Incoming and internal traffic is unlimited.

So only egress is paid on 10Gbit, but still.

Re:What happened to TheNumbers.com by userbinator on Thursday July 23, 2026 @10:44PM (#49030686)
the AI scrapers decided it would be more efficient to download terabytes upon terabytes of raw HTML by paginating through every possible facet on the search endpoint.

No, they decided that would be a great way to convince you of the narrative and persuade you to pay for "security" services that further the incumbent browser monopoly.

They're not "AI scrapers", they're DDoS'ers manufacturing consent.