. Aegis Static Data Dump Conversion Delayed « Torchwood Archives
Torchwood Archives
9Jul/151

Aegis Static Data Dump Conversion Delayed

Update: Aegis SDE conversion is now available: https://www.fuzzwork.co.uk/dump/

Most of the players don't realize that almost all third party apps need to be updated every time there is a new release of EVE. This is because of the Static Data - a special database made by CCP and released to the third party developers of EVE. It used to happen two to four times a year, but with the new release cadence it now happens every 5 weeks.

Usually the process is rather simple: CCP releases a MS SQL backup with the static data (plus some tables in YAML files), then Steve Ronuken (rather famous third party developer and a CSM member) combines both MS SQL and YAML files into one databse and converts it to several formats, such as MySQL (by far the most popular one), PostgreSQL and SQLite.

In Aegis release, CCP has changed one of the core tables - invTypes - from MS SQL database table to a YAML file. And unfortunately it caused some trouble:

Steve Ronuken [1:42 PM] It's just because there's data missing, due to the conversion

Steve Ronuken [1:50 PM] invGroup, invCategory data is totally missing. much of invTypes is missing

and

Forum thread about Aegis 1.0 SDE - Released

What does this mean for a regular EVE Online player? Most of the third party apps will be stuck on Carnyx static database, meaning there will be no Hecate or new missile modules there. We have to wait until CCP rectifies the situation, so Steve can convert the DB for the rest of third party devs.

Maybe it would be a good idea for CCP to consider releasing a complete database in all popular formats (or at least one), instead of data being scattered between MS SQL backup and several YAML files?

Comments (1) Trackbacks (0)
  1. Just to add: They’ve added most of the data back in today. Just missing descriptions on invGroups and invCategories.

    After a couple of minor bugs, to do with published, it’s loaded in.


Leave a Reply

No trackbacks yet.