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
Line 3: Line 3:
= 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 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 Fuzzwork SDE Conversions ==
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.
Once extracted the files can be opened in the appropriate application that supports the file format.
Once extracted the files can be opened in the appropriate application that supports the file format.
== What each table contains ==
== What each table contains ==
{| class="wikitable sortable"
{| class="wikitable sortable"