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

From	Νίκος Αλεξόπουλος <nikos.gr33k@gmail.com>
Newsgroups	comp.lang.python
Subject	Re: Adding 'download' column to existing 'visitors' table (as requested)
Date	2013-11-07 20:21 +0200
Organization	A noiseless patient Spider
Message-ID	<l5glme$kri$1@dont-email.me> (permalink)
References	(4 earlier) <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> <be2380Fi1vpU1@mid.individual.net>

Show all headers | View raw

Στις 7/11/2013 8:08 μμ, ο/η Neil Cerutti έγραψε:
> 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.

Exactly.

> 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.
That would be a problem yes.
But as you said above the deciding factor is the "how" we plan to use 
out stored data.

And my plan is to just display the records of all visitors per webpage 
with the last column being a list of this specific visitors 'downloads' 
as can be seen visually here:

http://superhost.gr/?show=log&page=index.html

'Δεν πραγματοποίηθηκαν ακόμη!' mean that this visitor hasn't download 
anything yet, if he does a drop down menu will appear in that place 
displaying his file picks.

People can download files from here:'http://superhost.gr/?page=files.py

(these torrent are just for testing reasons. later i will put my own 
selection of files)

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