EVE Technology Lab

I've been building some web applications for eve and found myself hesitant to import and host the eve database dump for each project. After research and googling It seems there are only a couple community hosted mysql databases but nothing that allows API calls.

So I built one:

• RESTful w/ JSONp support
• HTTP Auth
• Distributed, HA system
• CDN api endpoints
• Hosted on AWS
• 250ms response (tested w/ 250 concurrent connections)

http://evesql.com

This service allows me to query exactly what I need from my web apps and only maintain the eve database in one place. Msg me if you'd like the staging link.

Does anyone know of a service similar to above?
Would this type of service be of interest to anyone else?

Excellent point.

As with using any service, there's always the chance it will no longer exist at some point down the road. As a software designer for a Saas company, I see many saas startups and even established saas services shut down after a period of time. Economics plain and simple.

The advantage I have here over most is my knowledge and experience with the Saas industry, cloud providers, and building a scalable service. Obviously if my hosted service is loosing me money every month, it's more likely I'll shut it down at some point down the road. So the key is building a scalable service that doesn't cost me anything every month.

And that's what I did.

If eve developers do end up wanting to use a service such as mine, then that presents a economics issue. So what I'd like to find out from fellow developers is if said service would be of interest, if so how much is it worth to you, or is it something I should bundle up and open source?

Well now that you bring up the infrastructure, It's not a single endpoint. It's actually a high availability, distributed system. One feature I haven't turned on yet is caching the api endpoints on a cdn (For development purposes, the cdn cache can cause issues). The beauty here is that the eve database is completely static, so I'm able to cache all the api endpoints with long expire times.




From what I briefly ready, EMDR isn't a CDN, it's a distributed HA service.

This project is built using rails3.2 with MySQL. Each eve database table is manually imported with the table structure having to be made into a migration. I'm staying very strict with the eve naming conventions and primary_key/foreign_key assignments.

Rails has been stripped down to only need the minimal layers for an api service, this has improved response time just a little but mostly reduced the memory overhead.

So from a site that needs to lookup item information by type id, you would do a get call either from the client-side or server-side. Although I built this service with the client-side users in mind.

Get:
http://evedb-dummy-url.com/api/v1/inventory/type/233.json?callback=evedb

This will return the inventory information for 233 in JSON format:

evedb({"basePrice":"4000.0","capacity":0.0,"chanceOfDuplicating":0.07,"description":"Consists of two components: a shell of titanium and a core of iridium atoms suspended in plasma state. Railguns launch the shell directly, while particle blasters pump the plasma into a cyclotron and process the plasma into a bolt that is then fired. ","groupID":85,"iconID":1326,"marketGroupID":106,"mass":0.1,"portionSize":100,"published":1,"raceID":null,"typeID":233,"typeName":"Iridium Charge L","volume":0.025})


I'll work on getting a link up to play with.