EVE Technology Lab

Yes, but they are providing the SDE as a convenience for 3rd party developers...YAML isn't a convenience at all. It's pure crap, to be honest.

I am the technical lead developer of my team, and understand the value of having version control for what gets migrated between environments, but if you are going to provide data for other people to use, make it in a format that is easily used by a MAJORITY of the people that are going to want to use it. SQL was fine when it was in there, but there are a lot more standardized ways to share data...XML is old, but reliable enough for this....however, JSON is what is winning out across our LAN.

I wouldn't care if they removed the SQL database part of it, I create JSON data files for what I need out of it anyway....but something a little bit more standardized for public dissemination would sure go a long way to making a lot more people happy..(you know, the ones that haven't illegally hacked into the program/data to get their exports early)

According to the database,
"Civilian Miner" (typeID=3651) contains -2566 Trtanium (negative value!)

select * from invtypematerials
inner join invTypes on (invtypematerials.typeID = invTypes.typeID)
where invtypematerials.quantity < 0

Funny thing, you can see the same in-game. It also has some funny secret China blueprint.

umm, no. I should probably write something, but haven't.


blueprints.yaml is in the industryActivity tables

certificates.yaml is in the cert* tables

iconIDs.yaml is in eveIcons

typeIDs.yaml has:
the mastery information broken out into certMasteries
the trait information broken out into invTraits

There's additional information in there I've not broken out, as I've not needed it yet.




I've not touched graphicIDs.yaml yet. When/if I do, it'll probably go into a new table. Probably eveGraphics, to match the eveIcons table (which was a recreation of the table that it used to be in)

In case people are looking for another tool to do this kind of thing, the mysql utilities package has a bunch of useful tools in it, including one to compare DB schemas.

https://dev.mysql.com/downloads/utilities/

To compare schemas.
https://dev.mysql.com/doc/mysql-utilities/1.4/en/mysqldiff.html


To compare schemas, including at the data level.
https://dev.mysql.com/doc/mysql-utilities/1.4/en/mysqldbcompare.html

1.9 is out (oops. Missed this being released for around a week.)

Official release is on:
http://community.eveonline.com/community/fansites/toolkit/



Conversions:
Mysql:
https://www.fuzzwork.co.uk/dump/mysql56-crius-1.9-100804.tbz2

Sqlite:
https://www.fuzzwork.co.uk/dump/crius-1.9-100804/eve.db.bz2

Postgres
https://www.fuzzwork.co.uk/dump/crius-1.9-100804/postgres-crius-1.9-100804.dmp.bz2

Postgres dump is now done in postgres format, for restoration with pg_restore. excludes privileges.




Everything else:
https://www.fuzzwork.co.uk/dump/crius-1.9-100804/

But when they changes all the universe data, they put it out as an SQLite file...not to mention that post about yaml was several years ago and we've seen little in the movement to it until Cirus.

I think expecting whatever hodgepodge system they want to use that day will be what we get. 3rd party dev support is a collateral anyway, we can't expect much when it's not their primary goal. We just have to be flexible.

Hi Steve,

Looks like you have dups in industryActivityRaces. Two for every row it seems. If that was on purpose then I don't understand your devious scheme

Cheers,
sal

Hyperion 1.0 SDE is out. Let the conversions begin!

Just a heads up.
There are new categories added in dgmAttributeCategories.

Well in that case, some attributes changed category ID cause it broke EVEMon data files generator.

Edit: Yeap, they moved some attributes to category 17 (Speed).