[tudorg]

My take:

* When the pendulum has swung back from NoSQL, MySQL was in a weird place due to Oracle.

* OSS project and foundation not dominated by any particular company means that startups are willing to bet on it. In turn, these startups bring more tools, extensions, and attention to Postgres.

* The open wire protocol, with multiple existing implementations, means that if your application depends on Postgres, you will have plenty of options going forward.

* The extension ecosystem is working because extensions can do almost anything (create types, indexes, functions, etc.). And now pgrx and pgzx open up to writing extensions in Rust and Zig.

[brianhorakh]

My guess was also the ease of building safe extensions along with numerous vector and time series extensions, and it's recently improved replication capabilities.