News for hackers. Stuff that matters.

A comment on Show HN: I built a social media management tool in 3 weeks with Claude and Codex. Parent comment

Re:Show HN: I built a social media management tool in 3 week... by hyperionultra on Monday April 13, 2026 @07:06AM (#47750336)
Why postgre instead of classic mysql?
[ Parent | on HN ]
Re:Show HN: I built a social media management tool in 3 week... by purerandomness on Monday April 13, 2026 @07:12AM (#47750398)
MySQL 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.

[ Parent | on HN ]
Re:Show HN: I built a social media management tool in 3 week... by faangguyindia on Monday April 13, 2026 @07:21AM (#47750480)
such apps should use sqlite. it's enough for this type of app.
[ Parent | on HN ]
Re:Show HN: I built a social media management tool in 3 week... by hk__2 on Monday April 13, 2026 @07:07AM (#47750343)
Why mysql instead of postgres should be the right question nowadays.
[ Parent | on HN ]
Re:Show HN: I built a social media management tool in 3 week... by dewey on Monday April 13, 2026 @07:09AM (#47750375)
Postgres isn't a newcomer any more. For most projects that I see it's the default and the "classic" already.
[ Parent | on HN ]
Re:Show HN: I built a social media management tool in 3 week... by JanSchu on Monday April 13, 2026 @07:15AM (#47750428)
Postgres is simply a battle proven technology.
[ Parent | on HN ]
Re:Show HN: I built a social media management tool in 3 week... by rvz on Tuesday April 14, 2026 @08:19PM (#47773159)
Exactly. Thank you for choosing Postgres for this. Well done.
[ Parent | on HN ]
Re:Show HN: I built a social media management tool in 3 week... by eb0la on Monday April 13, 2026 @08:28AM (#47751008)
MySQL 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-...)

[ Parent | on HN ]