Don't Do This with PostgreSQL

Re:Don't Do This with PostgreSQL by h1fra on Tuesday November 12, 2024 @11:35AM (#42117021)

Most of the points here are "don't do it, but if you do it's not a problem". It should be renamed with "Be careful about this"

[ Parent | on HN ]

Re:Don't Do This with PostgreSQL by spprashant on Tuesday November 12, 2024 @12:29PM (#42117605)

I think it's more like, "don't do this" because there is perfectly saner alternatives available.

[ Parent | on HN ]

Re:Don't Do This with PostgreSQL by karmakaze on Tuesday November 12, 2024 @01:36PM (#42118278)

Each section has 'why not' and 'when should you', so really it's a "Do (only) when" recommendation.

I don't see sufficient justification for "Don't use serial"--the some weird behaviors links to a 404 page.

The "Don't use varchar(n) by default" reasoning is similarly weak.

This post doesn't doesn't give enough detail reasoning to be self-evident, and other than the quality of formatting could be a collection of anyone's blog posts. Some recommendations seem to be solid, but mixed with the arbitrary ones loses some of its recommendation strength.

[ Parent | on HN ]