EVE Technology Lab

The SDE contains all the data you need, but it takes a while to make sense of it all.

I am in the process of creating an EVE companion app for Android, and I created a custom SQLite database based on the SDE to make things easier. It only contains the data for what I need to implement in the app (fitting tool, skill planner and item database mostly), and I created a number of views in the database which provide relevant data.

First, we have the following major views
EN_Categories - query for categories in categoryIDs.yaml
EN_Groups - groups in groupIDs.yaml
EN_Types - types in typeIDs.yaml
EN_TypeAttributes - for querying attributes for any item with a typeID.

Then I further broke it down into separate chunks. The names should be self explanatory.
EN_Charges, EN_ChargeAttributes AND EN_ChargeEffects
EN_Drones, EN_DroneAttributes and EN_DroneEffects
EN_Implants, EN_ImplantAttributes AND EN_ImplantEffects
EN_Modules, EN_ModuleAttributes AND EN_ModuleEffects
EN_Ships, EN_ShipAttributes and EN_ShipEffects
EN_Skills, EN_SkillAttributes and EN_SkillEffects
EN_Subsystems, EN_SubsystemAttributes AND EN_SubsystemEffects

I'm still studying the SDE to find out how to filter whether a particular module is a ship rig or not. It's probably in one of the attributes, and there are over 500 unique attributes to check, but I'll get to it at some point.

Note that there's a TranslatedContent table which contains the translations for the languages provided in the .yaml files, so it's possible to build views for other supported languages, if you'd like. You can use a tool like SQLiteStudio to examine the view queries to understand how the table JOINs work.

You can download the custom SQLite database which is based on the Vanguard SDE at https://www.dropbox.com/s/ld2j4snduc31m39/sde.zip?dl=0.

Hope this helps.

The slot a module needs is in dgmTypeEffects (dgmEffects defines which is which)