What is PostgreSQL? Features, uses, and benefits

Postgres went from respected niche pick to the default database for new projects in under a decade. Here is what it actually is, how it works under the hood, what it is genuinely good at, and where it will make you work for it. The post What is PostgreSQL?