Thread: downloads & usage of Postgres on a per city basis
Does anybody remember a thread that mentioned some url or reference detailing postgres downloads or usage on a geographicbasis? cheers Robert Bernier
Robert, > Does anybody remember a thread that mentioned some url or reference > detailing postgres downloads or usage on a geographic basis? I'm afraid that I don't have any way to generate geograpic information. Sorry. -- Josh Berkus PostgreSQL @ Sun San Francisco
On December 15, 2006 09:36 pm, Josh Berkus wrote: > Robert, > > > Does anybody remember a thread that mentioned some url or reference > > detailing postgres downloads or usage on a geographic basis? > > I'm afraid that I don't have any way to generate geograpic information. > Sorry. Do you have IP addresses, if so I can convert those to country with somewhere around 95% accuracy -- Darcy Buskermolen Command Prompt, Inc. Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 PostgreSQL solutions since 1997 http://www.commandprompt.com/
Darcy, > Do you have IP addresses, if so I can convert those to country with > somewhere around 95% accuracy I'll check. Unfortuntely, I'm leaving town in 2 days so now is not the ideal time to produce such figures. The downloads database is on wwwmaster if you want to take a stab at it, but I have normalization code that weeds out duplicates and sorts by PG version & platform. -- Josh Berkus PostgreSQL @ Sun San Francisco
Josh Berkus wrote: > Darcy, > >> Do you have IP addresses, if so I can convert those to country with >> somewhere around 95% accuracy > > I'll check. Unfortuntely, I'm leaving town in 2 days so now is not the ideal > time to produce such figures. The downloads database is on wwwmaster if you > want to take a stab at it, but I have normalization code that weeds out > duplicates and sorts by PG version & platform. > The database on wwwmaster already contains the country code as returned by the ip-to-country mapping that's in the wwwmaster database. I'm unsure of how updated it is, but it should give you most of them the right way. So you can just use the field "country" along with whatever normalization you were already doing. //Magnus
Magnus, Darcy, > The database on wwwmaster already contains the country code as returned > by the ip-to-country mapping that's in the wwwmaster database. I'm > unsure of how updated it is, but it should give you most of them the > right way. So you can just use the field "country" along with whatever > normalization you were already doing. Oh, ok. I can do this when I get back. Or I can give Darcy rights on my server ... with the understanding that my scripts are not documented ... -- Josh Berkus PostgreSQL @ Sun San Francisco