in your browser.
Searching Armory data like a relational database
Return to board index
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
could cause issues with performance. However, a set of pre-defined (well tested) reports based on the communities priorities should be feasible.
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.
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.
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.
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. =/
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.
You are not logged in. Please
to post a reply or
if you don't already have an account.
Connect with Wowhead
Other Fanbyte Sites
Hearthstone Top Decks
Final Fantasy XI
© 2021 Fanbyte