Empires of Eve

My copy of Empires of Eve arrived today so here are some unboxing shots. If you can get the hardcover edition, purchase it. The finish quality and artwork really stands out.

Advertisements

Opening Day Skill Trading Jump Activity

With the February 2016  Release 1.0 came the addition of skill trading. Since I’m recording jump activity, I thought it would be neat to see how busy the major trade hubs were on the opening day of the Brainmeat Market(TM) (almost registered tradmark @Lockefox) bazaar.

Data taken from the /map/Jumps.xml.aspx API.

Another item to note is that we also saw an increase in the concurrent player count in Jita to 5,000.

 

2016-02-10_trade_hub_jumps_168_sample 2016-02-10_trade_hub_jumps_2352_sample

Jita to Amarr Route

2016-02-10_jumps_jitatoamarr_576_sample 2016-02-10_jumps_jitatoamarr_1176_sample


Reasons for Attending an Eve Player Gathering

If you have never attended a player gathering, it is an opportunity to witness the sheer passion, altruistic spirit, and friendless of the Eve community. Along with the playerbase, many of your favorite Devs are walking around, giving you the opportunity to have a face-to-face interaction with them. I had the oppournity to personally thank CCP Seagull for her passion and dedication on delivering a renewed vision of Eve Online. Many thanks to my partner in crime for the weekend, Lockefox (@HLIBIndustry).

IMG_0049 IMG_0045

Witnessing Vegas first hand.

 

 IMG_0039

Abusing the Planet Hollywood restaurant twitter hashtag.

IMG_0041 IMG_0043

Front row seats for new Capital reveal.

 

Watching some PvP action and bidding on server blades.

 

Seeing the Floating Nyx model and crowds.

 

Cheering for Structures with CCP Nullarbor.

Sharing a drink with @CCPQuant, talking statistics, and learning Icelandic for modern inventions like ‘refrigerator’ and ‘computer’.

IMG_0060

Witnessing the power of an open bar.

IMG_0054 IMG_0055

Being a guest on Hydrostatic Podcast.

IMG_0063


Joining Aideron Robotics

I’ll admit it, the “This is EVE” video combined with the momentum coming out of CCP got me excited about flying spaceships again. I decided to join Aideron Robotics and bolster the Gallente Militia.

I’ve got a good base for Gallente so I just need to round out some Drone and support skills.

2014-12-03_gallente_skills


One Month of Nullsec Manufacturing Index Changes

tl;dr The amount of Nullsec manufacturing has increased from July 23rd to August 23rd.

The evolution towards independent, self-sustainable manufacturing in Nullsec is an area of high interest to me. I want trade and manufacturing hubs to develop beyond what we have today, but given the need to import materials for invention and Tech 2 production, I don’t see it happening given the current industrial framework.

I wanted to see if the steps taken in Crius were moving us in the right direction so I turned to my data. I’ve been recording the system Index data from the API on an almost daily basis so I joined this data with sovereignty data to see if Nullsec manufacturing has been increasing.

The top 50 corporations by sum of their production have shown an increase on average of 46%. The overall change for all corporations has been 114%.

The full table is available below with conditional formatting placed on a narrow band excluding outliers to better visualize the changes.

2014-08-26-one_month_manufac_index_changes_nullsec


Challenges of Archiving Industry Index Values

If you have any interest in 3rd party development or databases, this post will be a entertaining as I share my current lackluster architecture for saving some of the new Eve API data.

I have a Raspberry Pi running MySQL that I use as a basic storage location for various databases. One of them is a new database that contains index values from the CREST API endpoint with a timestamp so I can start to develop a archive of the values.

The current solution I have for importing the new Index data isn’t very elegant. I’m using Lockefox’s Crius Toolset sheet to grab a CSV every day, adding two columns for a primary key and a timestamp, and importing into my table to get a table that looks like this:

“transactionID” “transactionDateTime” “solarSystemName” “solarSystemID” “manufacturing”
“103724” “2014-08-19 13:28:00” “Jouvulen” “30011392” “0.0339317910000”
“103725” “2014-08-19 13:28:00” “Urhinichi” “30040141” “0.0236668590000”
“103726” “2014-08-19 13:28:00” “Akiainavas” “30011407” “0.0285709850000”
“103727” “2014-08-19 13:28:00” “Seitam” “30041672” “0.0162879230000”
“103728” “2014-08-19 13:28:00” “BK4-YC” “30003757” “0.0143238350000”

It’s growing and starting to show how under-powered the Raspberry Pi is for data processing. Most of my issue stems from a lack of salable design on my part. I have no table indexes and am joining with the bulky mapDenormalize table.

I have a love-hate relationship with the mapDenormalize table. If you have ever worked with this table, you know that it is a beast: 502,558 rows, 15 columns with five of them being DOUBLE values coming in at 214MB. Normally not a problem for server with a lot of CPU cycles and RAM, but the 700MHz ARM processor on the Raspberry Pi has a hard time with multiple JOIN operations and GROUP BYs.

Here’s a query I was running against my dataset that ran for 15.5 minutes (!).

SELECT systemCosts.solarSystemName, systemCosts.transactionDateTime ,systemCosts.manufacturing, mapRegions.regionName, mapDenormalize.security
FROM systemCosts
JOIN mapDenormalize
ON (systemCosts.solarSystemID = mapDenormalize.solarSystemID)
JOIN mapRegions
ON (mapDenormalize.regionID = mapRegions.regionID)
GROUP BY transactionDateTime,solarSystemName

So two full table JOIN and two GROUP operations and a table with no indexes, uf. I sent a screenshot off to James, my development partner.

2014-08-04_terrible_query

My first solution was to remove extraneous data from the mapDenomalize table. After removing the groupID, constellationID, orbitID, x, y, z, radius, celestialIndex, and orbitIndex I trimmed the table down even further by deleting all entries that were not star systems. What was left was 7,929 rows coming in at around 1MB.

I’m glad to report that my terrible query is now running in 20 seconds. This was a small step to getting my growing index dataset to a usable state while I write something more permanent.


Today’s Connection Issues to Eve

 

Today we saw a large outage to CCP’s servers in London as the number of BGP routes advertised on the Internet passed a critical milestone. If you are unfamiliar with BGP, the easiest definition is that it is the protocol used to allow major ISPs to talk to each-other and share information on where to send traffic in order for it to reach its destination. Without ISPs peering using BGP, routers would not know to send traffic and nothing would reach the target host.

Certain models of Cisco routers that have not been modified from their default configuration became unstable after accepting more than 512,000 routes. Users all across the Internet saw strange behavior as routers began to drop traffic, slowly pass traffic through software routing, or crashing entirely. I saw my connection to CCP’s server in London from San Francisco become unreachable for several hours.

2014-08-12_eve_tq

This issue has been written about months ago, but it seems that a lot of people were caught by surprise. There is even a Cisco approved interim fix to buy more time by allocating additional memory space to store additional IPv4 routes (1).

Further reading on this topic can be found on this r/networking post.

(1) CAT 6500 and 7600 Series Routers and Switches TCAM Allocation Adjustment Procedures [link]