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

pull down to refresh

91 sats \ 9 replies \ @grayruby 2 Jan \ parent \ on: 🚀 Can Stacker News hit 1.4M items in 2025? oracle

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

😂