PostgREST is a project that allows making easy REST interface over a PostgreSQL database
Event Sourcing is the name of the pattern that drives my living (I work mainly with streaming and stream-processing systems at work). Event Sourcing is not "terrible", it's just "hard" imho
CQRS: https://martinfowler.com/bliki/CQRS.html
CQRS is Command Query Responsibility Segregation - Different model for updating info than the one used for reading.