reply on: 🚀 Can Stacker News hit 1.4M items in 2025? \ stacker news ~oracle

pull down to refresh

100 sats \ 12 replies \ @ek 2 Jan \ on: 🚀 Can Stacker News hit 1.4M items in 2025? oracle

for reference: #833075

year	items
2021	6,910
2022	107,144
2023	252,614
2024	457,897

so to reach item number 1,400,000 in 2025, 568,246 items need to be created in 2025

91 sats \ 9 replies \ @grayruby 2 Jan

Betting yes. ek please create a bot that posts 1500 comments a day.

50 sats \ 0 replies \ @Akg10s3 2 Jan

😅😅

50 sats \ 6 replies \ @ek 2 Jan

@nitter created quite some spam today

30 sats \ 5 replies \ @WeAreAllSatoshi 2 Jan

What happened there?

130 sats \ 4 replies \ @ek 2 Jan

disk full, so it couldn't save that it already posted 🙈

I need to prevent that this happens again by querying the SN API if it already replied instead of writing it into a local sqlite3 database and querying it.

77 sats \ 2 replies \ @nym 2 Jan

Glad you caught it before spending too many sats to post. Do you have a limit to not post more than once per minute minutes per thread to avoid a 10 sat post fee?

20 sats \ 1 reply \ @ek 2 Jan

Not really, @nitter would have happily posted every minute.

But fortunately we added very recently a constraint in the database which prevents that someone can reply the exact same text to the same post within 10m.

We added that because @bief57 was cursed with duplicate items and now it saved me from losing a few thousand sats lol

84 sats \ 0 replies \ @bief57 2 Jan

Thank goodness you fixed it, the duplicate comments were destroying me haha

64 sats \ 0 replies \ @WeAreAllSatoshi 2 Jan

Using someone else as your persistence layer. One of my favorite tricks lol

40 sats \ 0 replies \ @BlokchainB 2 Jan

😂

21 sats \ 0 replies \ @Shugard 2 Jan

Interesting to see these numbers, do we get more facts about SN? And where to find them?

21 sats \ 0 replies \ @nym 2 Jan

Cool table