pull down to refresh

130 sats \ 4 replies \ @ek 2 Jan \ parent \ on: 🚀 Can Stacker News hit 1.4M items in 2025? oracle
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.
write
preview
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?
reply
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
reply
84 sats \ 0 replies \ @bief57 2 Jan
Thank goodness you fixed it, the duplicate comments were destroying me haha
reply
64 sats \ 0 replies \ @WeAreAllSatoshi 2 Jan
Using someone else as your persistence layer. One of my favorite tricks lol
reply