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

Groups > comp.lang.python > #37695

Re: mysql solution

Show all headers | View raw

On Fri, 25 Jan 2013 07:43:53 -0800 (PST), Ferrous Cranus
<nikos.gr33k@gmail.com> declaimed the following in
gmane.comp.python.general:

> 
> what do you mean by that?
> 
>  " Furthermore, your "visitors" table is only saving the most recent 
> "useros" and "browser" data... Is that what you really want -- or do you 
> want to log ALL users that visit the page. "
> 
> If the same hostname  visits my webpage multiple times i only update the userOS, bwoswer, date information. 
> 

	And what use will you make of that? Consider that "hostname" is not
something unique to a user. Heck, unless on pays for a fixed domain, a
DHCP system "hostname" can change from one user to another every day
(common DHCP "lease" is 24 hours; every 24 hours a DSL connection
renegotiates an IP number, and many ISPs embed that IP number into a DNS
name).

E:\UserData\Wulfraed\My Documents>tracert 76.249.16.247

Tracing route to adsl-76-249-16-247.dsl.klmzmi.sbcglobal.net
[76.249.16.247]
over a maximum of 30 hops:

  1     2 ms    <1 ms    <1 ms  192.168.2.1
  2     1 ms     1 ms     1 ms
adsl-76-249-16-247.dsl.klmzmi.sbcglobal.net [76.249.16.247]

Trace complete.

	If I reboot my DSL modem, I'll probably get a different IP number,
and hence a different host name (lovely, I pay for Earthlink DSL in
Grand Rapids, but they apparently are hosted on old AT&T [SBC] servers
located in Kalamazoo). Note how the IP number is in the name (I checked
my DSL modem to find the IP number assigned to me). 

	Also, with NAT, I could start up my two laptops and my Nook HD+
browsers -- giving three different operating systems, three browser
versions, etc. and all will appear to be from the same hostname... 

	To me, the result is meaningless -- it only shows the most recent
access but no history.

> What do you mean?
> 
> And also: why does the table 'visitors' ahs to have an auto increment column ID what for?

	Habbit -- I /always/ create an auto-increment primary key for a
table; after all, maybe next year you expand the system and now need a
way to reference the older table. Better to have a unique primary key
that is not dependent upon data fields available for use.
-- 
	Wulfraed                 Dennis Lee Bieber         AF6VN
        wlfraed@ix.netcom.com    HTTP://wlfraed.home.netcom.com/

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

Thread

mysql solution Ferrous Cranus <nikos.gr33k@gmail.com> - 2013-01-24 03:04 -0800
  Re: mysql solution Chris Angelico <rosuav@gmail.com> - 2013-01-24 22:16 +1100
    Re: mysql solution Ferrous Cranus <nikos.gr33k@gmail.com> - 2013-01-24 05:31 -0800
      Re: mysql solution Chris Angelico <rosuav@gmail.com> - 2013-01-25 01:46 +1100
    Re: mysql solution Ferrous Cranus <nikos.gr33k@gmail.com> - 2013-01-24 05:31 -0800
  Re: mysql solution Lele Gaifax <lele@metapensiero.it> - 2013-01-24 12:25 +0100
    Re: mysql solution Ferrous Cranus <nikos.gr33k@gmail.com> - 2013-01-24 04:01 -0800
      Re: mysql solution Lele Gaifax <lele@metapensiero.it> - 2013-01-24 13:22 +0100
        Re: mysql solution Ferrous Cranus <nikos.gr33k@gmail.com> - 2013-01-24 05:24 -0800
          Re: mysql solution Lele Gaifax <lele@metapensiero.it> - 2013-01-24 14:37 +0100
            Re: mysql solution Ferrous Cranus <nikos.gr33k@gmail.com> - 2013-01-24 06:35 -0800
            Re: mysql solution Ferrous Cranus <nikos.gr33k@gmail.com> - 2013-01-24 06:35 -0800
              Re: mysql solution Duncan Booth <duncan.booth@invalid.invalid> - 2013-01-24 15:19 +0000
                Re: mysql solution Chris Angelico <rosuav@gmail.com> - 2013-01-25 02:27 +1100
                Re: mysql solution Lele Gaifax <lele@metapensiero.it> - 2013-01-24 16:39 +0100
                Re: mysql solution Ferrous Cranus <nikos.gr33k@gmail.com> - 2013-01-24 10:22 -0800
                Re: mysql solution Ferrous Cranus <nikos.gr33k@gmail.com> - 2013-01-24 10:22 -0800
        Re: mysql solution Ferrous Cranus <nikos.gr33k@gmail.com> - 2013-01-24 05:24 -0800
    Re: mysql solution Ferrous Cranus <nikos.gr33k@gmail.com> - 2013-01-24 04:01 -0800
  Re: mysql solution Chris Angelico <rosuav@gmail.com> - 2013-01-24 22:29 +1100
  Re: mysql solution Dennis Lee Bieber <wlfraed@ix.netcom.com> - 2013-01-24 15:43 -0500
    Re: mysql solution Ferrous Cranus <nikos.gr33k@gmail.com> - 2013-01-25 07:43 -0800
      Re: mysql solution Dennis Lee Bieber <wlfraed@ix.netcom.com> - 2013-01-25 16:56 -0500
        Re: mysql solution Ferrous Cranus <nikos.gr33k@gmail.com> - 2013-01-26 02:35 -0800
        Re: mysql solution Ferrous Cranus <nikos.gr33k@gmail.com> - 2013-01-26 02:35 -0800
    Re: mysql solution Ferrous Cranus <nikos.gr33k@gmail.com> - 2013-01-25 07:43 -0800

csiph-web