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

From	Neil Cerutti <neilc@norwich.edu>
Newsgroups	comp.lang.python
Subject	Re: Adding 'download' column to existing 'visitors' table (as requested)
Date	2013-11-07 18:08 +0000
Organization	Norwich University
Message-ID	<be2380Fi1vpU1@mid.individual.net> (permalink)
References	(3 earlier) <mailman.2127.1383832372.18130.python-list@python.org> <l5g6uq$llt$1@dont-email.me> <CAPTjJmpwckCLhnz=KuQPxNFCjA4TUU=X35q+uaApMzHwJ+NRBg@mail.gmail.com> <mailman.2131.1383837084.18130.python-list@python.org> <l5gk15$b2p$1@dont-email.me>

Show all headers | View raw

On 2013-11-07, ?????????? ??????????????????????
<nikos.gr33k@gmail.com> wrote:
> I called you an idiot, because in your previous and current
> message you called me too.
>
> I know that splitting information across tables and maintain
> foreign keys for retain relationships between them is a
> necessary thing but in my case i only just an extra pieces of
> information to eb associated with my visitor, a possible file
> download. and i have decided just to add an extra colum to the
> existing 'visitors' database and this is adequate.

Non-normalized data is sometimes a fine idea. How you plan to use
the data once it is stored will be the deciding factor.

One big win with databases is that you can query them really
easily using SQL. Non-normalized data negates that advantage.

How would you write a query to discover all the visitors who
downloaded file XYZ? With your storage scheme, you can't. So by
storing the data this way, you are promising yourself that you'll
never need to write that query, or at least, you won't need to do
it very often.

> I still don't know why you push me to create an extra table
> instead.

Because it's usually the right thing to do.

-- 
Neil Cerutti

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