public inbox for [email protected]
help / color / mirror / Atom feedCounting clicks, Download page?
13+ messages / 7 participants
[nested] [flat]
* Counting clicks, Download page?
@ 2004-11-22 00:11 Josh Berkus <[email protected]>
2004-11-22 00:28 ` Re: Counting clicks, Download page? Gavin M. Roy <[email protected]>
2004-11-22 00:50 ` Re: Counting clicks, Download page? Marc G. Fournier <[email protected]>
2004-11-22 01:07 ` Re: Counting clicks, Download page? Joshua D. Drake <[email protected]>
0 siblings, 3 replies; 13+ messages in thread
From: Josh Berkus @ 2004-11-22 00:11 UTC (permalink / raw)
To: pgsql-www
Folks,
Is there any way we can log the number of times people request an FTP mirror
from the download mirrors page? While it wouldn't be an accurate count of
downloads, it would give us better numbers than we have now.
Thoughts?
--
--Josh
Josh Berkus
Aglio Database Solutions
San Francisco
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Counting clicks, Download page?
2004-11-22 00:11 Counting clicks, Download page? Josh Berkus <[email protected]>
@ 2004-11-22 00:28 ` Gavin M. Roy <[email protected]>
2004-11-22 00:32 ` Re: Counting clicks, Download page? Josh Berkus <[email protected]>
2 siblings, 1 reply; 13+ messages in thread
From: Gavin M. Roy @ 2004-11-22 00:28 UTC (permalink / raw)
To: [email protected]; +Cc: pgsql-www
Maybe a good way is to create a simple perl script that counts out of
some standard logfile formats and provides the numbers in a file that
would be accessable but hidden in the ftp file structure... maybe .stats
or something... then we could easily make a ftp script to retrive the
information for a stats page. If we agree that it's something that
we'll ask/require our mirrors to use on a crontab, I'll be happy to code
something that works against proftp and apache, with abstraction for the
regex to split out the data.
Gavin
Josh Berkus wrote:
>Folks,
>
>Is there any way we can log the number of times people request an FTP mirror
>from the download mirrors page? While it wouldn't be an accurate count of
>downloads, it would give us better numbers than we have now.
>
>Thoughts?
>
>
>
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Counting clicks, Download page?
2004-11-22 00:11 Counting clicks, Download page? Josh Berkus <[email protected]>
2004-11-22 00:28 ` Re: Counting clicks, Download page? Gavin M. Roy <[email protected]>
@ 2004-11-22 00:32 ` Josh Berkus <[email protected]>
0 siblings, 0 replies; 13+ messages in thread
From: Josh Berkus @ 2004-11-22 00:32 UTC (permalink / raw)
To: Gavin M. Roy <[email protected]>; +Cc: pgsql-www
Gavin,
> If we agree that it's something that
> we'll ask/require our mirrors to use on a crontab,
We can ask, but only a few will cooperate. Our biggest mirrors are university
sites who won't run anything -- at least, that's what I've been told.
--
--Josh
Josh Berkus
Aglio Database Solutions
San Francisco
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Counting clicks, Download page?
2004-11-22 00:11 Counting clicks, Download page? Josh Berkus <[email protected]>
@ 2004-11-22 00:50 ` Marc G. Fournier <[email protected]>
2 siblings, 0 replies; 13+ messages in thread
From: Marc G. Fournier @ 2004-11-22 00:50 UTC (permalink / raw)
To: Josh Berkus <[email protected]>; +Cc: pgsql-www
we could do something similar to what justin had done with techdocs, and
'wrapper' the redirect to the ftp site in a php/perl script that logs the
click thru to the mirror ... same could be done with the www mirrors also
... the 'link' would just have to point back to scripts.postgresql.org ...
On Sun, 21 Nov 2004, Josh Berkus wrote:
> Folks,
>
> Is there any way we can log the number of times people request an FTP mirror
> from the download mirrors page? While it wouldn't be an accurate count of
> downloads, it would give us better numbers than we have now.
>
> Thoughts?
>
> --
> --Josh
>
> Josh Berkus
> Aglio Database Solutions
> San Francisco
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
----
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: [email protected] Yahoo!: yscrappy ICQ: 7615664
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Counting clicks, Download page?
2004-11-22 00:11 Counting clicks, Download page? Josh Berkus <[email protected]>
@ 2004-11-22 01:07 ` Joshua D. Drake <[email protected]>
2 siblings, 0 replies; 13+ messages in thread
From: Joshua D. Drake @ 2004-11-22 01:07 UTC (permalink / raw)
To: [email protected]; +Cc: pgsql-www
Josh Berkus wrote:
>Folks,
>
>Is there any way we can log the number of times people request an FTP mirror
>from the download mirrors page? While it wouldn't be an accurate count of
>downloads, it would give us better numbers than we have now.
>
>
Why don't we do it the way PHP does it. They have a link goes to
itself with some get parameters and then referrs to the real download site.
This would allow us to easily keep track of the specific clicks.
J
>Thoughts?
>
>
>
--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - [email protected] - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL
Attachments:
[text/x-vcard] jd.vcf (285B, 2-jd.vcf)
download | inline:
begin:vcard
fn:Joshua Drake
n:Drake;Joshua
org:Command Prompt, Inc.
adr:;;PO Box 215 ;Cascade Locks;OR;97014;US
email;internet:[email protected]
title:Consultant
tel;work:503-667-4564
tel;fax:503-210-0334
x-mozilla-html:FALSE
url:http://www.commandprompt.com
version:2.1
end:vcard
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Counting clicks, Download page?
@ 2004-11-22 09:51 Dave Page <[email protected]>
2004-11-22 10:59 ` Re: Counting clicks, Download page? Alexey Borzov <[email protected]>
2004-11-22 13:06 ` Re: Counting clicks, Download page? Oleg Bartunov <[email protected]>
2004-11-22 16:25 ` Re: Counting clicks, Download page? Marc G. Fournier <[email protected]>
0 siblings, 3 replies; 13+ messages in thread
From: Dave Page @ 2004-11-22 09:51 UTC (permalink / raw)
To: [email protected]; pgsql-www
Nope, not as it stands. Virtually everything is static HTML now for speed and mirror-ability. If you want to log ftp mirror selections, then it'll need to go back to being a php script on one server, giving us a single point of failure on perhaps the second most important part of the site (next to the front page).
/D
-----Original Message-----
From: [email protected] on behalf of Josh Berkus
Sent: Mon 11/22/2004 12:11 AM
To: [email protected]
Subject: [pgsql-www] Counting clicks, Download page?
Folks,
Is there any way we can log the number of times people request an FTP mirror
from the download mirrors page? While it wouldn't be an accurate count of
downloads, it would give us better numbers than we have now.
Thoughts?
--
--Josh
Josh Berkus
Aglio Database Solutions
San Francisco
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Counting clicks, Download page?
2004-11-22 09:51 Re: Counting clicks, Download page? Dave Page <[email protected]>
@ 2004-11-22 10:59 ` Alexey Borzov <[email protected]>
2004-11-22 17:45 ` Re: Counting clicks, Download page? Josh Berkus <[email protected]>
2 siblings, 1 reply; 13+ messages in thread
From: Alexey Borzov @ 2004-11-22 10:59 UTC (permalink / raw)
To: Dave Page <[email protected]>; +Cc: [email protected]; pgsql-www
Hi,
Dave Page wrote:
> Nope, not as it stands. Virtually everything is static HTML now for speed and mirror-ability. If you want to log ftp mirror selections, then it'll need to go back to being a php script on one server, giving us a single point of failure on perhaps the second most important part of the site (next to the front page).
In fact the mirror selection page now *should* be a dynamic page on one
server only (and that's the main reason I am so concerned about that
server's performance). In any other case you'll *not* be able to use
ip2country.
But current implementation of mirror selection will not give any useful
stats: it will only show how many people went to an FTP mirror, not
whether they actually downloaded something.
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Counting clicks, Download page?
2004-11-22 09:51 Re: Counting clicks, Download page? Dave Page <[email protected]>
2004-11-22 10:59 ` Re: Counting clicks, Download page? Alexey Borzov <[email protected]>
@ 2004-11-22 17:45 ` Josh Berkus <[email protected]>
0 siblings, 0 replies; 13+ messages in thread
From: Josh Berkus @ 2004-11-22 17:45 UTC (permalink / raw)
To: Alexey Borzov <[email protected]>; +Cc: Dave Page <[email protected]>; pgsql-www
Alexey,
> But current implementation of mirror selection will not give any useful
> stats: it will only show how many people went to an FTP mirror, not
> whether they actually downloaded something.
Yeah, but that's more information than we have now.
--
Josh Berkus
Aglio Database Solutions
San Francisco
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Counting clicks, Download page?
2004-11-22 09:51 Re: Counting clicks, Download page? Dave Page <[email protected]>
@ 2004-11-22 13:06 ` Oleg Bartunov <[email protected]>
2 siblings, 0 replies; 13+ messages in thread
From: Oleg Bartunov @ 2004-11-22 13:06 UTC (permalink / raw)
To: Dave Page <[email protected]>; +Cc: [email protected]; pgsql-www
It could be done without touching pages, just configure mod_rewrite
properly. I think it's not difficult for mirrors add several lines
to httpd.conf
Oleg
On Mon, 22 Nov 2004, Dave Page wrote:
> Nope, not as it stands. Virtually everything is static HTML now for speed and mirror-ability. If you want to log ftp mirror selections, then it'll need to go back to being a php script on one server, giving us a single point of failure on perhaps the second most important part of the site (next to the front page).
>
> /D
>
>
> -----Original Message-----
> From: [email protected] on behalf of Josh Berkus
> Sent: Mon 11/22/2004 12:11 AM
> To: [email protected]
> Subject: [pgsql-www] Counting clicks, Download page?
>
> Folks,
>
> Is there any way we can log the number of times people request an FTP mirror
> from the download mirrors page? While it wouldn't be an accurate count of
> downloads, it would give us better numbers than we have now.
>
> Thoughts?
>
>
Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: [email protected], http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Counting clicks, Download page?
2004-11-22 09:51 Re: Counting clicks, Download page? Dave Page <[email protected]>
@ 2004-11-22 16:25 ` Marc G. Fournier <[email protected]>
2 siblings, 0 replies; 13+ messages in thread
From: Marc G. Fournier @ 2004-11-22 16:25 UTC (permalink / raw)
To: Dave Page <[email protected]>; +Cc: [email protected]; pgsql-www
On Mon, 22 Nov 2004, Dave Page wrote:
> Nope, not as it stands. Virtually everything is static HTML now for
> speed and mirror-ability. If you want to log ftp mirror selections, then
> it'll need to go back to being a php script on one server, giving us a
> single point of failure on perhaps the second most important part of the
> site (next to the front page).
I thought that all mirrors had a requirement to have php enabled? could
we do an email->database gateway, where the mirror would email in stats
that a script on the server side could then parse and dump into the
database?
the other option would be a php script that checked if
scripts.postgresql.org was reachable, and if so, did a GET request to do
the dump before redirecting to the mirror itself ... assuming a fairly
short timeout on the check ...
> > /D
>
>
> -----Original Message-----
> From: [email protected] on behalf of Josh Berkus
> Sent: Mon 11/22/2004 12:11 AM
> To: [email protected]
> Subject: [pgsql-www] Counting clicks, Download page?
>
> Folks,
>
> Is there any way we can log the number of times people request an FTP mirror
> from the download mirrors page? While it wouldn't be an accurate count of
> downloads, it would give us better numbers than we have now.
>
> Thoughts?
>
> --
> --Josh
>
> Josh Berkus
> Aglio Database Solutions
> San Francisco
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to [email protected] so that your
> message can get through to the mailing list cleanly
>
----
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: [email protected] Yahoo!: yscrappy ICQ: 7615664
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Counting clicks, Download page?
@ 2004-11-22 09:54 Dave Page <[email protected]>
0 siblings, 0 replies; 13+ messages in thread
From: Dave Page @ 2004-11-22 09:54 UTC (permalink / raw)
To: [email protected]; Gavin M. Roy <[email protected]>; +Cc: pgsql-www
-----Original Message-----
From: [email protected] on behalf of Josh Berkus
Sent: Mon 11/22/2004 12:32 AM
To: Gavin M. Roy
Cc: [email protected]
Subject: Re: [pgsql-www] Counting clicks, Download page?
Gavin,
> If we agree that it's something that
> we'll ask/require our mirrors to use on a crontab,
> We can ask, but only a few will cooperate. Our biggest mirrors are university
> sites who won't run anything -- at least, that's what I've been told.
Yes, thats what I've found in the past. Only the smaller mirrors will help out - mainly because they're run by fans of the project. The bigger ones mirror tens or even hundreds of sites, and simply don't start mucking about with stats for us.
Regards, Dave
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Counting clicks, Download page?
@ 2004-11-23 09:48 Dave Page <[email protected]>
0 siblings, 0 replies; 13+ messages in thread
From: Dave Page @ 2004-11-23 09:48 UTC (permalink / raw)
To: Alexey Borzov <[email protected]>; +Cc: [email protected]; pgsql-www
> -----Original Message-----
> From: Alexey Borzov [mailto:[email protected]]
> Sent: 22 November 2004 11:00
> To: Dave Page
> Cc: [email protected]; [email protected]
> Subject: Re: [pgsql-www] Counting clicks, Download page?
>
> Hi,
>
> Dave Page wrote:
> > Nope, not as it stands. Virtually everything is static HTML
> now for speed and mirror-ability. If you want to log ftp
> mirror selections, then it'll need to go back to being a php
> script on one server, giving us a single point of failure on
> perhaps the second most important part of the site (next to
> the front page).
>
> In fact the mirror selection page now *should* be a dynamic
> page on one server only (and that's the main reason I am so
> concerned about that server's performance).
Don't worry about that - it's in hand.
> In any other case
> you'll *not* be able to use ip2country.
As I vaguely seem to recall stating at the time it was implemented. It's
only a minor convenience thing (seeing as most ppl know their own
country), and puts both load on the server, and creates a single point
of failure.
> But current implementation of mirror selection will not give
> any useful
> stats: it will only show how many people went to an FTP
> mirror, not whether they actually downloaded something.
Agreed.
Regards, Dave.
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Counting clicks, Download page?
@ 2004-11-23 09:51 Dave Page <[email protected]>
0 siblings, 0 replies; 13+ messages in thread
From: Dave Page @ 2004-11-23 09:51 UTC (permalink / raw)
To: Marc G. Fournier <[email protected]>; +Cc: [email protected]; pgsql-www
> -----Original Message-----
> From: Marc G. Fournier [mailto:[email protected]]
> Sent: 22 November 2004 16:25
> To: Dave Page
> Cc: [email protected]; [email protected]
> Subject: Re: [pgsql-www] Counting clicks, Download page?
>
> I thought that all mirrors had a requirement to have php
> enabled?
No, not for years. And many now don't.
Regards, Dave.
^ permalink raw reply [nested|flat] 13+ messages in thread
end of thread, other threads:[~2004-11-23 09:51 UTC | newest]
Thread overview: 13+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-11-22 00:11 Counting clicks, Download page? Josh Berkus <[email protected]>
2004-11-22 00:28 ` Gavin M. Roy <[email protected]>
2004-11-22 00:32 ` Josh Berkus <[email protected]>
2004-11-22 00:50 ` Marc G. Fournier <[email protected]>
2004-11-22 01:07 ` Joshua D. Drake <[email protected]>
2004-11-22 09:51 Re: Counting clicks, Download page? Dave Page <[email protected]>
2004-11-22 10:59 ` Alexey Borzov <[email protected]>
2004-11-22 17:45 ` Josh Berkus <[email protected]>
2004-11-22 13:06 ` Oleg Bartunov <[email protected]>
2004-11-22 16:25 ` Marc G. Fournier <[email protected]>
2004-11-22 09:54 Re: Counting clicks, Download page? Dave Page <[email protected]>
2004-11-23 09:48 Re: Counting clicks, Download page? Dave Page <[email protected]>
2004-11-23 09:51 Re: Counting clicks, Download page? Dave Page <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox