26 lines
976 B
Markdown
26 lines
976 B
Markdown
# zkill-susser
|
|
|
|
Simple tool to try find lossmails of ships fitting certain modules<br>
|
|
The idea is to find "an algos that died in faction warfare having at least 2 remote reps"
|
|
|
|
## Data
|
|
|
|
One half of the data is the eve static dump coming from [fuzzworks](https://www.fuzzwork.co.uk/dump/) specifically the [SQLite dump](https://www.fuzzwork.co.uk/dump/sqlite-latest.sqlite.bz2)<br>
|
|
The other half are the dumps from [everef](https://data.everef.net/killmails/)
|
|
|
|
Killmails are to be put into data in their .tar.bz2 format
|
|
|
|
## Database Setup
|
|
|
|
### EVE Static Data (SQLite)
|
|
|
|
The EVE static data comes as a SQLite database file. Extract the `.sqlite` file from the `.bz2` archive and place it in the project root as `sqlite-latest.sqlite`.
|
|
|
|
### Killmail Data (ClickHouse)
|
|
|
|
Killmail data is stored in ClickHouse. The schema and ingestion will be handled separately.
|
|
|
|
## Generating database types
|
|
|
|
Via [gorm gentool](https://gorm.io/gen/gen_tool.html)<br>
|
|
See mprocs.yaml for example |