Newbie question about items.
Berlo.9237:
I have only today discovered the awesomeness that is the Guild Wars 2 API so I have been messing with some of it. Basically, without sending a bajillion HTTP requests to the web service, what is the most efficient way to pull down a list of every item in the game and their name?
smiley.1438:
Send a gazillion requests to the servers.
You can also download our database over here: http://de.gw2treasures.de/gw2treasures.sql.gz which is the backend of http://gw2treasures.de/
The backend of the backend is a slightly older version of my database repo over here: https://github.com/codemasher/gw2-database (haven’t done much commits recently because i’m waiting for the API v2. However, i’ll then try to keep the database itself as close as possible to the recent version)
Berlo.9237:
So obviously it’s not going to be efficient pulling this data and then displaying it on a jQuery table, it’s probably easier if I pull it all into a database and feed the web service from there.
That link to your database file gives me a 404 by the way.
smiley.1438:
Hmm, ok, maybe Darthmaim took it down for whatever reason. I’ll make a dump of the current one and upload it to my webserver to save you the hassle of polling the API 4*~36000 times. Just gimme a little time.
€:
for some reason the export was interrupted at ~6.5k items <.<
I’ll tell Darthmaim to re-upload the DB to the above URL^^
€€:
He told me, that he’ll be home in 4-5h and upload it then. https://twitter.com/darth_maim/status/509313054115659776
darthmaim.6017:
Here is the new link for a snapshot of the item database behind gw2treasures: http://gw2treasures.de/2014-09-09_items.sql.gz
Sorry that it took me so long, i was at work.