> Always has been.
It definitely has not always been.
https://www.quora.com/Why-is-MySQL-more-popular-than-Postgre... (2010)
It definitely has not always been.
https://www.quora.com/Why-is-MySQL-more-popular-than-Postgre... (2010)
It is great though, amazing piece of technology. Not 100% sure you need some specialized data store for your use case? (Most people aren’t). Pick Postgres. You can always switch to SpecializedDB later when pg falls over.
I cannot undersell enough how hard it is to be at being 90% good at everything. Like, you can pick Postgres for these technologies and not get fired for it at first glance and it will carry you to medium-large scale
- time series
- GIS
- Graph
- CRUD/ Jamstack apps (eg Supabase)
- Queues
- and on and on and on
If it even tangentially involves data you can trust that Postgres has some solution that will mostly work with some edge cases unless you are at disgusting levels of scale. Love it. A true jack of all trades
Building/running Postgres in Windows' Linux compatibility layer or within Docker is typically the better option, especially considering that every cloud vender offers Postgres running on a Linux OS, and it's best to have your dev environment match your deployment environment as closely as possible.
With Linux as your starting point, getting up and running with apt-get install mysql vs. apt-get install postgresql was trivially similar in 2010.