Querying the entire internet (100 billion rows!) with MotherDuck
https://motherduck.com/blog/querying-the-entire-internet-100-billion-rows-with-motherduck/
Interesting analysis.
However, the introduction is misleading: "Coding agents have turned a lot of people into web developers, so here is the internet-sized question for today: how much has personal, platform-hosted publishing actually grown?"
But the real conclusion¹ is "How fast the vibe-coded web is growing," even if it mixes different plans.
tldr; wordpress.com decline
¹ https://motherduck.com/dive-gallery/embed/the-vibe-coded-web-measured-common-crawl/
raffaele
npub1yq…zn5x2
2026-09-24 08:45:07 UTC
Author Public Key
npub1yqx5ghqax2pk0l7z7qxwj5atkk67sz8lghcua4wf0cgdylke9a6qlzn5x2Seen on
wss://relay.ditto.pubPublished at
2026-09-24 08:45:07 UTCEvent JSON
{
"id": "5c6d487c22a22b50eebd19da38b17bb6ee528160bfe286f22b57cfd4fb870b24",
"pubkey": "200d445c1d328367ffc2f00ce953abb5b5e808ff45f1ced5c97e10d27ed92f74",
"created_at": 1790239507,
"kind": 1,
"tags": [
[
"proxy",
"https://digipres.club/users/raffaele/statuses/117325136392707077",
"activitypub"
],
[
"client",
"Mostr",
"31990:6be38f8c63df7dbf84db7ec4a6e6fbbd8d19dca3b980efad18585c46f04b26f9:mostr",
"wss://relay.ditto.pub"
]
],
"content": "Querying the entire internet (100 billion rows!) with MotherDuck\nhttps://motherduck.com/blog/querying-the-entire-internet-100-billion-rows-with-motherduck/\n\nInteresting analysis. \nHowever, the introduction is misleading: \"Coding agents have turned a lot of people into web developers, so here is the internet-sized question for today: how much has personal, platform-hosted publishing actually grown?\"\n\nBut the real conclusion¹ is \"How fast the vibe-coded web is growing,\" even if it mixes different plans.\n\ntldr; wordpress.com decline\n\n¹ https://motherduck.com/dive-gallery/embed/the-vibe-coded-web-measured-common-crawl/",
"sig": "da6a81c9d7685f5dc300a14e9e7c9dfd235fdf73671499392fd32777e96c01c2576d3eb1efc5b8e626e53aae4055e59660d727171202db67601a8e3788049535"
}