3 ms·
I mostly come across MySQL for simple web applications that need to store some data. For that it works fine and is cheaper than MSSQL for instance. Not really t
by AtNightWeCode 5y ago
I mostly come across MySQL for simple web applications that need to store some data. For that it works fine and is cheaper than MSSQL for instance. Not really the prime use case for Postgres.
- __float 5y agoWhat makes Postgres unfit for that use? It doesn't have large licensing fees like SQL Server, and Postgres (just like MySQL) can run on a single node and handle small amounts of data just fine.
- mst 5y agoGetting to reasonably solid active/passive failover for relatively simple uses is substantially easier to learn from zero for mysql. And I say this as somebody who defaults to postgres or sqlite over mysql where possible these days just because I expect it to be less of a headache down the road.
- AtNightWeCode 5y agoThe knowledge about running MySQL in production seems to be more widespread. A lot of web-hosting companies offers it. MySQL is the default for some CMS systems and so on. Postgres is powerful and can be used for pretty much everything but it takes more knowledge.
- directionless 5y agoWhat about this does not feel like a postgres use case?