Partial EDDN updates

Sunday 19th July, 2015 · Posted by Roguey · 0 comments

For the past couple of days ive been testing some new code that looks for EDDN data, and adds it to the database. EDDN is a large trading network, where fellow commanders submit ware/ship prices to a feed using programs such as EliteOCR etc. EDDN is used by a few sites, as its one of the biggest resources for trade data. During the past couple of weeks ive noticed a drop in updates.

However before working on the EDDN code, I needed to import more stations - I had quite a few missing ones. So using an export log from eddb.io, I managed to import around 30,000 extra stations/outposts. While running the code, I also got it to add a few more details, such as system allegiance etc. The code took a long time to run - as it required a pc to go through the database checking to see if the station already exists, then update the details (so 1,000's of MySQL queries were done). So this process was done on my own test-server (where it doesnt matter if I tie it up for a couple of hours). After it had completed, then imported the database here.

With the stations imported, the next thing to do was to work on the code to send the EDDN data to the website (as I cant install the software on the webserver). So after a lot of experimenting I have managed to get something working. Eagled eye users made of noticed updates from EDDN during the past couple of days - increasing the updates from 1 or 2 a day, to 200+ (shown here). Ship and ware locations are both being updated with EDDN data (EDDN doesnt support equipment locations at the moment, otherwise that would be uploaded as well). So far - in the two or so days its been running - the amount of price data has doubled.



Although there is one slight negative; the only way I can watch the EDDN traffic is by leaving on a PC, and mine isnt on all the time (so some EDDN data will be missed unfortunately). However I do feel the EDDN data such make a big improvement.

A big thank-you to everyone who helped me with this, and maintain EDDN.

Comments

To post comments you need to register and log-in.