HNGlance

Top Best New Show

What's Most Popular on Pornhub?

https://substring.substack.com/p/whats-most-popular-on-pornhub

by lolpanda • 4 years ago

5 1 4 years ago

SU

substring.substack.com

Related Stories

Loading related stories...

Comments

1

tuatoru• 4 years ago

Pornhub allows anyone to embed their videos on 3rd-party websites. They offer a full dump of the video database that you can download from here
The database is fairly large, close to 4M videos. It’s impossible to load such a large number of items into Excel. So you need a SQL database, ideally, a very fast SQL database.

Seriously, only 4M rows? That's tiny. We were dealing with that using DB2 in SMEs in the 1980s. With proper indexing, Postgresql on a 386 wouldn't have any difficulty. You don't need any niche nonstandard tool.

Source preview

substring.substack.com

HNGlance

© 2024-2026 HN Glance. Story content belongs to its original sources.

Privacy
Terms