These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

EVE Technology Lab

 
  • Topic is locked indefinitely.
 

Eve static data
Author
Previous Topic Next Topic
OverLord Minion
Federal Navy Academy
Gallente Federation
#1 - 2013-05-18 16:23:19 UTC
I've been messing a bit with Eve API and I find myself trying to escape the static data dump.

The official data is in MSSQL database backup ( http://community.eveonline.com/community/fansites/toolkit/ ) and I found some MySQL exports.

Anyone has any webservices or dumps to text files that I can manipulate to use as I see fit? :)
I just don't have and don't want to create a database instance just so that I can do the exports into a format that can fit my application.
Drapko Nitzhonot
Abdera Logistics
#2 - 2013-05-18 17:48:33 UTC
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#3 - 2013-05-18 19:21:58 UTC
As well as the xls (for tables which have less than 65,000 rows, and possibly have embedded line breaks) and csv (greater than 65000 rows) exports, there's also the sqlite version.

http://www.fuzzwork.co.uk/dump/retribution-1.1-84566/eve.db.bz2

Sqlite is a pretty good thing to use, if you're wanting to embed it into an application (with low concurrency). Advantages of sql, without the disadvantage of needing an additional server process.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Cypherous
Liberty Rogues
Aprilon Dynasty
#4 - 2013-05-19 12:39:31 UTC
Considering how often the dataset will change and be updated it might be worth installing a local MySQL instance to enable you to play with the data, sadly the only instances of the server i have are either locally installed or are hosted online in a way that the public doesn't have direct access :)
Joepopo
Worthless Carebears
The Initiative.
#5 - 2013-05-20 06:13:00 UTC
Install your own database like mssql or mysql. You don't want to navigate all this data without the flexibility sql queries will give you.