Toggle menu
Toggle preferences menu
Toggle personal menu
Not logged in
Your IP address will be publicly visible if you make any edits.

Static Data Export: Difference between revisions

From EVE University Wiki
How to use the fuzzwork dumps: Updated to reflect the actual state of SDE vs SDE Conversions
Line 2: Line 2:


= Fuzzwork SDE Conversions =
= Fuzzwork SDE Conversions =
To aide fellow developers and players in consuming this data without having to extract or convert from Microsoft SQL Server format every time Steve Ronuken has hosted conversions in PostgreSQL, SQLite and MySQL readable formats. They can be found at [https://www.fuzzwork.co.uk Fuzzwork] under SDE or more directly at [https://www.fuzzwork.co.uk/dump www.fuzzwork.co.uk/dump]. Individual table data can be found in [//en.wikipedia.org/wiki/Comma-separated_values CSV] and [//en.wikipedia.org/wiki/SQL SQL] (MySQL) formats (compressed) here [https://www.fuzzwork.co.uk/dump/latest www.fuzzwork.co.uk/dump/latest].
To aide fellow developers and players in consuming this data without having to extract or convert from Microsoft SQL Server format every time Steve Ronuken has hosted conversions in PostgreSQL, SQLite and MySQL readable formats. They can be found at [https://www.fuzzwork.co.uk Fuzzwork] under SDE or more directly at [https://www.fuzzwork.co.uk/dump www.fuzzwork.co.uk/dump]. Individual table data can be found in [//en.wikipedia.org/wiki/Comma-separated_values CSV] and [//en.wikipedia.org/wiki/SQL SQL] (MySQL) formats here [https://www.fuzzwork.co.uk/dump/latest www.fuzzwork.co.uk/dump/latest].
== Opening a file from the SDE ==
== Opening a file from the SDE ==
To extract data from compressed files, use [https://ss64.com/bash/tar.html tar] for <code>.tar.bz2</code> files or [https://ss64.com/osx/bzip.html bunzip2] for <code>.bz2</code> files in linux, and something like [http://www.7-zip.org/ 7-zip] for either format in windows.
To extract data from compressed files, use [https://ss64.com/bash/tar.html tar] for <code>.tar.bz2</code> files or [https://ss64.com/osx/bzip.html bunzip2] for <code>.bz2</code> files in linux, and something like [http://www.7-zip.org/ 7-zip] for either format in windows.