You absolutely can use Postgres for this. There are extensions for the auditing. You could rig something up with triggers for the notifications or use Supabase

You absolutely can use Postgres for this. There are extensions for the auditing. You could rig something up with triggers for the notifications or use Supabase depending on how realtime you want to be. Much of the decision comes down to the ops side and how/where you're going to manage it, because Postgres will eat up this use case for breakfast no problem.