as we are currently moving back into w-space from some russian invoked 3 month break in lowsec, I started getting back into development of the WormBoard wormhole comparison site. (Refer to this thread in the old forums: https://forums-archive.eveonline.com/default.aspx?g=posts&t=518935). To collect new ideas and show some progress I decided to let an in-dev installment run in parallel:

Jump to page and scroll found corporation into view doesn’t work properly if the selected sorting column isn’t leading to unambiguous results (e.g. if you sort by efficiency and the searched corp is amongst many that are 100% you will most likely end up on the wrong page and/or scrollposition)

Data now available 'til yesterday (2017.10.10), old version isn’t updating anymore since a couple of days already, v1.0 will replace the old v0.2 somewhere in the next few… Also we are back in business :

Massive performance improvement incoming, data is now aggregated on the database like it should be, instead of pulling nearly 100k records from it and do the aggregation in java … Took me like 3h to figure how to aggregate a list of comma separated character_id’s set-like, aka ignoring duplicates, in Postgres native SQL. For those who wonder:

New version deployed, this is mostly a huge historic data update, changelist:

Data back to 2012 (next version will have the entire history of w-space covered)

2 new experimental Charts, Day of the Week distribution for kills and average players on kill + Top 10 vs selected Corp vs the rest of w-space in absolute ISK killed, number of kills and active players

Active players, Timezone and the 2 new Dialogs now work with all of the selectable periods

Internet Explorer support is discontinued cuz it simply sucks for modern web development

Oh, and the USTZ correction checkbox in day of the week doesn’t and will never work… I build it in before thinking of that the precise time of a kill is lost in my database already due daily aggregates, so cannot do what I intended to do there