4 ms·
Why postgre instead of classic mysql?
by hyperionultra 6mo ago
Why postgre instead of classic mysql?
- hk__2 6mo agoWhy mysql instead of postgres should be the right question nowadays.
- dewey 6mo agoPostgres isn't a newcomer any more. For most projects that I see it's the default and the "classic" already.
- purerandomness 6mo agoMySQL does not let you have transactional DDL statements (alter, create, index etc). If you're building anything serious and your data integrity is important, use Postgres. Postgres is much stricter, and always was. MySQL tried to introduce several strict modes to mitigate the problems that they had, but I would always recommend to use Postgres.
- JanSchu 6mo agoPostgres is simply a battle proven technology.
- rvz 6mo agoExactly. Thank you for choosing Postgres for this. Well done.
- faangguyindia 6mo agosuch apps should use sqlite. it's enough for this type of app.
- eb0la 6mo agoMySQL or Postgres are the DB of choice if you want a managed database in the cloud. Probably Postgres is there because you can use it as a queue (https://livebook.manning.com/book/just-use-postgres/chapter-11 https://livebook.manning.com/book/just-use-postgres/chapter-...)
- throwaway613746 6mo ago[dead]