10 sats \ 5 replies \ @ek 6 Mar 2023 \ parent \ on: Zap transaction fees? bitcoin
Which wallet do you mean? The wallet on SN?
write
preview
0 sats \ 4 replies \ @Content_Ape OP 6 Mar 2023
Yes, the wallet on SN. I don't have the keys, but it looks like all the posts have a hash, so I assume it's a wallet and not a database.
reply
10 sats \ 3 replies \ @ek 6 Mar 2023
What hash? Are you talking about OTS? That's something different; nothing to do with LN transactions. See here: https://opentimestamps.org/
I can tell you with a 100% certainty that all tips are just transactions inside a database.
The code is open source, you can setup SN yourself and take a look: https://github.com/stackernews/stacker.news
reply
36 sats \ 1 reply \ @Content_Ape OP 6 Mar 2023
Yup, thanks for the link to the github. It's right there in the Wallet Transaction Safety section.
And you nailed it with the OTS, I incorrectly assumed it was a hash.
reply
10 sats \ 0 replies \ @ek 6 Mar 2023
Ah, you already saw it yourself. Nice.
No worries, happy to help.
reply
10 sats \ 0 replies \ @ek 6 Mar 2023
I realized you don't even need to setup SN yourself. It even says in the README that it's just a database:

wallet transaction safety
To ensure user balances are kept sane, all wallet updates are run in serializable transactions at the database level. Because prisma has relatively poor support for transactions all wallet touching code is written in plpgsql stored procedures and can be found in the prisma/migrations folder.
reply