๐๐๐ถ๐น๐ฑ๐ถ๐ป๐ด ๐๐ป ๐๐๐ฒ๐ป๐ ๐ฆ๐ผ๐๐ฟ๐ฐ๐ฒ๐ฑ ๐๐๐ฑ๐ถ๐ ๐๐ผ๐ด
A Japanese label called at 3am. They wanted to know who hid their videos. They wanted the exact time and reason for every change. The old system failed. It only stored the last action. It deleted the history.
Updates destroy data. If two people edit a video, the first change disappears. Regional rules become a mess.
Event sourcing fixes these issues. Every change is a permanent fact. You never delete data. You only add new events.
The setup is simple.
- PHP 8.4
- SQLite
- One append-only table for events
- One projection table for fast reads
This solves three main problems.
- History is permanent.
- Every actor is tracked.
- Regional reasons are clear.
You do not need Kafka or a big team. This system is 600 lines of code. It runs on one server.
Now legal teams get real answers. No more guessing. No more apologies.