Looks like I'm going to have to denormalize upvotes either by putting them into their own table or adding them directly to the items table. Currently upvotes are in an Item act table with tips, boost, and job payments which makes certain queries easier but more important queries slower. This has become exacerbated by job payments which now dominate the table given the relative quantity.

The main reason I wouldn't want to add them directly to items is that when trust is recomputed, all old items would effectively go stale in terms of their upvotes and things like 'top' could become inaccurate over long time periods.

Upvotes in their own table though might also have limited scalability at some point.

🤕

Laws sound like a great idea until you realise someone has to make and enforce them and you end up creating a power disparity which incentivizes corruption and crime. Essentially what you set out to solve with laws you just institutionalized and the saying "People who say we need laws are experienced criminals" holds more truth.

The experienced criminals (eg. Banksters) actually need laws to protect them from competition.

Also the Rulers need them to enslave their subjects.

You’re all getting emotional lol….all hail our AI overlords.

There's one true law, the Natural Law, that is simply this:

I will add: do not lie, always speak truth.

If more people will simply respect this Natural law, the world will be much better, without any other so called "laws" enacted by a bunch of idiots named "governments or parliaments"and in fact are just rules and regulations against people, not to help people.

Please watch this amazing documentary about Natural Law so you will understand what am I talking about.

Lots will need to be improved but there’s nothing big in the way of scaling. It’s all pretty straightforward: horizontally scale (more machines), vertically scale (more cpu/ram), denormalize db queries I can’t optimize, etc

I really like the idea of paying for WTs but it shouldn't be very expensive for users to do so. The pricing should be very minimal like 5-10 sats/channel/month or something. There should be work on this on the protocol level itself making sure we don't bloat it more than necessary. Watch towers should be preferably hosted on-premise and in data-centers that have a good up time because of having excellent connectivity and power backups.

Notice the same yesterday, getalby give you an address too!!

Someone just need to re-implement email on lightning.

"Anything below 100k that isn't the contact list move to spam", and the issue with spam solved.

Even add the option to send back the payment if someone pay for send you an email if you open it.