Hi, If I could suggest a small change in order to make a better index on that table. I made a similar table at one point, but for faster lookups I… (I know I'm about to be butchered)… I hashed the UA string…. using md5 no less, but I must say that +500K devices later I haven't had a single problem. Also, it would be a good idea to add a column that points to the device's information source (in my case it was WURFL/UAProf).
Good stuff on this thread. Regards, -- Carlos D'Agostino Sent with Sparrow (http://www.sparrowmailapp.com/?sig) On Tuesday, March 26, 2013 at 8:24 PM, Reza wrote: > Would anyone be opposed to using tomcat and mysql? I was just going to make a > simple table with a few columns: > > -user agent > -reason > > -status > -comment > > Reason could be new, defect, unknown. Status could be submited, reviewed, > rejected. The UI would allow for entries to be submitted and then a > 'developer view' would allow for moving the user agents thru the other status > stages. > > This should take less than a day to build and might get things moving. > > > ________________________________ > From: Bertrand Delacretaz <[email protected] > (mailto:[email protected])> > To: [email protected] > (mailto:[email protected]) > Sent: Tuesday, March 26, 2013 1:18 PM > Subject: Re: Device Recognition for Embedded > > On Tue, Mar 26, 2013 at 6:10 PM, Werner Keil <[email protected] > (mailto:[email protected])> wrote: > > > > What exactly does "nginx!" mean? > > It's a web server - there's nothing usable at > http://devicemap-vm.apache.org/ for now, but that (Linux) machine is > ready for installing useful stuff. > > -Bertrand
