Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.python > #58661

Re: Adding 'download' column to existing 'visitors' table (as requested)

References <l5cr5p$ihv$1@dont-email.me> <l5e01f$ala$2@dont-email.me> <l5g52n$aq5$1@dont-email.me> <mailman.2127.1383832372.18130.python-list@python.org> <l5g6uq$llt$1@dont-email.me>
Date 2013-11-08 01:37 +1100
Subject Re: Adding 'download' column to existing 'visitors' table (as requested)
From Chris Angelico <rosuav@gmail.com>
Newsgroups comp.lang.python
Message-ID <mailman.2130.1383835037.18130.python-list@python.org> (permalink)

Show all headers | View raw

On Fri, Nov 8, 2013 at 1:09 AM, Νίκος Αλεξόπουλος <nikos.gr33k@gmail.com> wrote:
> Why create a whole new 'downloads' table and associate it with the with a
> foreign key with the 'visitors' table you idiot when you can just have an
> extra column at the end of the current 'visitor's table?
>
> Both 'downloader' and 'downlaod' is associated by being in the same record.
>
> By your logic every time we want to store an extra piece of information we
> have to create an extra database table.
>
> Too much hussle for no good reason....

Go to your local library and pick up a book on database design - or
possibly you'll find it on Wikipedia. There ARE good reasons for the
"hassle" of normalization. There are times when you consciously
denormalize (I often read tables into memory for a (read-only) cache,
and denormalize aggressively), but the rule of thumb is: It's normal
to normalize.

ChrisA

Back to comp.lang.python | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Adding 'download' column to existing 'visitors' table (as requested) Nick the Gr33k <nikos.gr33k@gmail.com> - 2013-11-06 09:30 +0200
  Re: Adding 'download' column to existing 'visitors' table (as requested) Nick the Gr33k <nikos.gr33k@gmail.com> - 2013-11-06 09:38 +0200
    Re: Adding 'download' column to existing 'visitors' table (as requested) Nick the Gr33k <nikos.gr33k@gmail.com> - 2013-11-06 10:28 +0200
  Re: Adding 'download' column to existing 'visitors' table (as requested) Denis McMahon <denismfmcmahon@gmail.com> - 2013-11-06 17:59 +0000
    Re: Adding 'download' column to existing 'visitors' table (as requested) rusi <rustompmody@gmail.com> - 2013-11-06 10:09 -0800
    Re: Adding 'download' column to existing 'visitors' table (as requested) Mark Lawrence <breamoreboy@yahoo.co.uk> - 2013-11-06 18:18 +0000
    Re: Adding 'download' column to existing 'visitors' table (as requested) Νίκος Αλεξόπουλος <nikos.gr33k@gmail.com> - 2013-11-07 15:37 +0200
      Re: Adding 'download' column to existing 'visitors' table (as requested) Joel Goldstick <joel.goldstick@gmail.com> - 2013-11-07 08:52 -0500
        Re: Adding 'download' column to existing 'visitors' table (as requested) Νίκος Αλεξόπουλος <nikos.gr33k@gmail.com> - 2013-11-07 16:09 +0200
          Re: Adding 'download' column to existing 'visitors' table (as requested) Chris Angelico <rosuav@gmail.com> - 2013-11-08 01:37 +1100
          Re: Adding 'download' column to existing 'visitors' table (as requested) Joel Goldstick <joel.goldstick@gmail.com> - 2013-11-07 10:11 -0500
            Re: Adding 'download' column to existing 'visitors' table (as requested) Νίκος Αλεξόπουλος <nikos.gr33k@gmail.com> - 2013-11-07 19:52 +0200
              Re: Adding 'download' column to existing 'visitors' table (as requested) Neil Cerutti <neilc@norwich.edu> - 2013-11-07 18:08 +0000
                Re: Adding 'download' column to existing 'visitors' table (as requested) Νίκος Αλεξόπουλος <nikos.gr33k@gmail.com> - 2013-11-07 20:21 +0200
      Re: Adding 'download' column to existing 'visitors' table (as requested) Grant Edwards <invalid@invalid.invalid> - 2013-11-07 15:06 +0000
  Re: Adding 'download' column to existing 'visitors' table (as requested) Piet van Oostrum <piet@vanoostrum.org> - 2013-11-07 09:14 -0400
    Re: Adding 'download' column to existing 'visitors' table (as requested) Sibylle Koczian <nulla.epistola@web.de> - 2013-11-07 17:03 +0100
      Re: Adding 'download' column to existing 'visitors' table (as requested) Piet van Oostrum <piet@vanoostrum.org> - 2013-11-09 00:27 -0400
        Re: Adding 'download' column to existing 'visitors' table (as requested) Robert Kern <robert.kern@gmail.com> - 2013-11-09 08:45 +0000
    Re: Adding 'download' column to existing 'visitors' table (as requested) Tim Chase <python.list@tim.thechases.com> - 2013-11-07 10:54 -0600

csiph-web