This site makes extensive use of JavaScript.
Please enable JavaScript in your browser.
Live
PTR
10.2.7
PTR
10.2.6
Beta
Searching Armory data like a relational database
Post Reply
Return to board index
Post by
Borgthor
All the data from the Armory that sites like wowhead collect sits in a relational database, right? However, I'm yet to find a tool that allows you to search the data using the full power of the underlying database.
For example, what I'm after is a search like:
select characters, date completed from guild X where achievement Y = completed
Does anyone know of a tool that has this type of flexibility in searching the Armory data?
Is there (or could there) be plans to develop a tool along these lines for wowhead?
If there is, naturally wowhead needs to be cautious about the scope of the tool, since letting people query for
anything
could cause issues with performance. However, a set of pre-defined (well tested) reports based on the communities priorities should be feasible.
Post by
Malgayne
Something like
this
?
The trouble is that we can only import data from the Armory so fast, so we focus on updating and storing the profiles that people are actually looking at—meaning there may be (and probably are) more people in that guild who have completed that achievement, but we haven't pulled the data for those characters from the Armory yet. So it's not yet a perfect solution—but it would be difficult for anyone to produce such a solution without special Armory access privileges.
Post by
Borgthor
Yes, absolutely something exactly like that! I really should have looked for the create a filter link in the profiler.
I understand the limitation of having the data available to search on. I'll test it out and see how I go.
Post by
Borgthor
Yup, you're right... the limitation of each character having been actively viewed through the profiler makes the results a little hit and miss.
There are a few sites around that (while still limiting their download speed) queue large queries for the armory... if anyone has another site that has the functionality of the profiler filter, but can guarantee an up to date result (or queue the request) let me know.
Post by
Malgayne
We can't search the armory directly using queues like this, so queueing the request doesn't seem feasible. As it is we update something like 110 profiles per minute constantly, all the time—any more and the Armory throttles our requests. =/
Post by
Borgthor
Wow, 110 queries a minute seems like a lot. Multiply that by the number of sites like wowhead that use the upper limit of requests / minute... the number of people that actually view the armory directly... that's a LOT of traffic.
Maybe I'm going about this the wrong way, and I should be trying to get Blizzard themselves to implement something like this directly. Given that, like any large organisation, they probably have a list of development priorities that stretches as far as the eye can see... not sure I like my chances.
Post Reply
You are not logged in. Please
log in
to post a reply or
register
if you don't already have an account.