CCP Static Data Dump
From EVEDev
The CCP Static Data Dump (SDD, in wiki often CCP DB) is part of the CCP Community Toolkit and provides an SQL RDMS database of objects and entities in EVE Online.
When working on pages in the wiki, you can embed database information in your pages using special Wiki editing syntax.
Contents |
[edit] Release
It is released officially at the EVE Community Toolkit website.
The current version is for Crucible 1.1 build 334471, and can be downloaded as a zip from the MSSQL Server 2008 : Crucible_1.1_334471_db.zip. You can unzip it using a program such as 7-zip on Windows and p7zip on Linux.
If you do not have database software, you can always install MSSQL Server 2008 Express Edition for free from Microsoft and work with the official CCP Database Dump files.
Previous release information is available at CCP Toolkit Release History.
It is also possible to create your own database dump using extractor tools on the game Cache. This could provide you with more up to date information on some objects.
[edit] Conversions
- MySQL, PostgreSQL, SQLite: [1]
[edit] Contents
The official toolkit website states that it contains:
Data:
- Map information such as solarsystems, constellations, regions
- jump connections, stargates, orbital bodies
- types, groups and categories for everything in-game
- manufacture and refine information for every said types
- and much more
Images:
- All in-game types, including blueprints
- Alliance and NPC corporation logos
In fact it also contains:
- You can improve the quality of this article by inserting more here...
[edit] Detailed Information
- Database Tables
- Accessing the CCP DB programmatically
- Common SQL Queries
- Foreign Key relationship graph for Tyrannis 1.0.3 (build 167296)
[edit] Community Tables
The EVE community has provided supplementary information that you can add to your database.
- Minerals distribution per solar systems
- Minerals distribution per solar system security class
- Ice lookup table
- Alliance graphic mappings
- NPC faction / corporation graphic mappings
[edit] Feature Requests
Please put feature requests in Database Dump Requests.
[edit] External Hosting
Below is a list of remote-accessible hosts that allow you to read the database dump in read-only mode for use in your small applications or websites. If your website has high traffic please consider hosting it yourself instead. They should list the version of the database, hostname, username, password, database name, and server type and server version.
- You can help the community by hosting a version of the database dump on your server and listing it here
- NOTE THIS IS FOR HOSTING ACCESS TO A DB SERVER, NOT FOR FLAT FILE DOWNLOAD.
* evetools.info proudly provides a remote database connection: dump version: cruc101, database: "evedump", hostname: "evetools.info", username: "evedump", password: "evedump1234", server: MySQL 5.0.51a
dump version: inc110, database: "evedump", hostname: "db.descention.net", username: "evedump", password: "evedump1234", server: MySQL 5.1.53

