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.
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.
Jita to Amarr Route
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).
Witnessing Vegas first hand.
Abusing the Planet Hollywood restaurant twitter hashtag.
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’.
Witnessing the power of an open bar.
Being a guest on
apply to Aideron Robotics corp, computer blue screens #tweetfleet
— Blake (@K162space) November 26, 2014
I’ve got a good base for Gallente so I just need to round out some Drone and support skills.
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.
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
ON (systemCosts.solarSystemID = mapDenormalize.solarSystemID)
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.
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.
We are currently experiencing login issues with Tranquility. More information will be made available as we work on solving the problems!
— EVE Online Status (@EVE_status) August 12, 2014
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.
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]