Hacker News new | ask | show | jobs
by redis_mlc 1796 days ago
Well, as a DBA, I periodically use a 3rd party tool to print out the schema. It's mainly for new hires to learn from.

But sometimes I'll flip through it and notice:

- mis-spelled table names, usually duplicate tables

- missing FKs

- missing unique keys, most commonly for early RoR apps

- developer-specific EAV tables with 1 row.

The benefit always outweighs the dead trees, but printing once a year is typical. Back in the day, more frequenctly on 25-line terminals where there was too much scrolling.

1 comments

I don't get why this post got into [dead]. Anybody care to explain their reasoning?
User redis_mlc has been shadowbanned for eight months which is an abhorrent practice. He is a prolific contributor, but most readers will never see his comments. Occasionally, a reader with showdead:yes in the options and sufficient karma will "vouch" a post back into general visibility.

Note that the verdict by HN moderator dang talks of a regular ban: https://news.ycombinator.com/item?id=25011268

Reply to redis_mlc <https://news.ycombinator.com/item?id=27878748>, post out of order because of the ban:

Moderation does not care about right or wrong, truthful or fake, moral or immoral.

Moderation cares about harmonic or controversial. There isn't even a "group think", as that would imply direction and consistency.

The user got shadowbanned (apparently automatically).