These are chat archives for arenanet/api-cdi

11th
Jun 2017
Eearslya Sleiarion
@Eearslya
Jun 11 2017 05:23
alright who here's got a full items database? I'm beginning to realize my current serialization method is hack after hack
I wanna know how you guys do it
darthmaim
@darthmaim
Jun 11 2017 10:17
I have columns for all properties I want to filter/join on (name, type, ...)
everything else is in a big JSON column
David ReeƟ
@queicherius
Jun 11 2017 10:43
I dump it how the API spits it out into MongoDB, set indexes on the columns I filter often (id, name) and let it deal with the rest.
darthmaim
@darthmaim
Jun 11 2017 10:44
thats probably how I would do that now too
but my db is over 4 years old now :O
well, maybe not quite yet
I think I started late 2013
ChieftainAlex
@ChieftainAlex
Jun 11 2017 11:09
@that_shaman - with your remastered map of Tyria, did you draw the portal icons on later?
ChieftainAlex
@ChieftainAlex
Jun 11 2017 12:10
so I made a thing: https://wiki.guildwars2.com/index.php?title=Widget:World_map_(Guild_Wars_1)
I would have stuck it on the gw1 wiki but it hasn't got widgets enabled yet.
ChieftainAlex
@ChieftainAlex
Jun 11 2017 12:24
also with the same markers projected onto the gw2 basemap https://wiki.guildwars2.com/wiki/User:Chieftain_Alex/sandbox
smiley
@codemasher
Jun 11 2017 14:50
(that's how i process the data, @darthmaim may do it a little different ;) )