Scaling has been tricky. Finding a database system which can handle the load was the hardest part. A single Postgres instance buckled quite early on. Later I tr

Scaling has been tricky. Finding a database system which can handle the load was the hardest part. A single Postgres instance buckled quite early on. Later I tried Cockroachdb but it also was not up for the task. Now I'm running ScyllaDB and it's handling tens of thousands of queries per seconds like a champ. Content moderation is already a big problem. It's what I spend most of my time on nowadays. There is a lot of crazy shit getting uploaded. Abuse reports are flying in from all corners of the internet. I'm working on automated systems for processing them. The most annoying part is that a lot of copyright management firms don't sign their e-mails with DKIM, so I can't verify that the sender address was not spoofed. This prevents me from fully automating the e-mail responses.