Things to know about databases

Re:Things to know about databases by mmcnl on Monday June 27, 2022 @05:05PM (#31900780)

"Show me your flowchart and conceal your tables, and I shall continue to be mystified. Show me your tables, and I won't usually need your flowchart; it'll be obvious." -- Fred Brooks, The Mythical Man Month (1975)

[ Parent | on HN ]

Re:Things to know about databases by Aeolun on Monday June 27, 2022 @08:42PM (#31902781)

This man has clearly never seen our database schema.

Show me either flowcharts and/or tables, it doesn’t matter, I’ll continue to be mystified.

[ Parent | on HN ]

Re:Things to know about databases by alliao on Monday June 27, 2022 @10:10PM (#31903352)

our devs created smash hits such as

  NounFunction
  NounFunctionTemporal
  NounCollectionFunction

  FunctionNoun_Function
  FunctionNoun_FunctionItem

  Noun_Collection
  Noun_Collection_Function
  Noun_Collection_FunctionItem

i've taken out duplicating combinations where different teams wanted same things over time, but never looked up what others had done before and decided to spin their own...

[ Parent | on HN ]

Re:Things to know about databases by Aeolun on Tuesday June 28, 2022 @07:05AM (#31906241)

Don’t forget

Noun_Collection_Function_20200406 Noun_Collection_Function_20200320_Backup

And

Noun_Collection_Function_ForJim

[ Parent | on HN ]

Re:Things to know about databases by SulphurSmell on Tuesday June 28, 2022 @11:23AM (#31908906)

I would be having words with the DBA about this. If there is a DBA. No DBA I would hire would allow this silliness. At least not in the actual application schema.

[ Parent | on HN ]

Re:Things to know about databases by spacemanmatt on Tuesday June 28, 2022 @07:32PM (#31914474)

> At least not in the actual application schema.

And that's how the scratchpad schema became mission-critical ;)

[ Parent | on HN ]

Re:Things to know about databases by Akronymus on Wednesday June 29, 2022 @08:02AM (#31918972)

Hey, at least you don't store gender in the address table, where one person can have multiple addresses.

https://news.ycombinator.com/item?id=27842820

[ Parent | on HN ]

Re:Things to know about databases by lazide on Monday June 27, 2022 @08:51PM (#31902844)

That will explain a lot probably about many things!

[ Parent | on HN ]

Re:Things to know about databases by teddyh on Tuesday June 28, 2022 @04:16AM (#31905400)

He said usually.

[ Parent | on HN ]

Re:Things to know about databases by SulphurSmell on Monday June 27, 2022 @06:44PM (#31901895)

This is going on my wall. Thanks so much.

[ Parent | on HN ]

Re:Things to know about databases by mmcnl on Wednesday June 29, 2022 @08:11AM (#31919051)

I got from a comment on HN a few months ago, so also thank the commenter that I don't remember.

[ Parent | on HN ]