These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

EVE Technology Lab

 
  • Topic is locked indefinitely.
 

Trying to setup backend, get & save?

First post
Author
Mike Bergstrom
Harmonic Network
#1 - 2017-01-23 05:14:12 UTC
I don't have much know-how with web based applications, and I'm more interested in working on the frontend than backend.

I'm trying to use this as a means to learn Javascript and more UI based things. I just need data! I thought what other kind of data would be better than my own Character data from Eve!

So I'm trying to find best practices/the easiest way to make that data available to me without hitting cache limits or being put on a API timeout. I would like to be able to grab my character data (skillsheet, wallet, etc.) and save it on my linux server, I'm just not sure how to approach this or what can best handle it.

Should I use mysql as a means to store the data? How would I make that data available for me to use via javascript? And the most important, how can I automatically update that data without me giving input?

I'm not looking to be spoonfed here, I'm just tried of google searching to no avail.

If anyone has an idea of where I should begin my search, or just know of something I can setup and go then great!

If I'm posting in the incorrect area, I apologize.

Thanks for your time
-Mike
qu1ckkkk
The Warp Core Stabilizers
Goonswarm Federation
#2 - 2017-01-23 18:17:46 UTC
Shameless plug. You can setup SeAT and only use the workers to populate the database with data. You can then build the front end as you wish.

https://github.com/eveseat/seat

Proud developer of SeAT! A Simple Eve API & Corporation Management Tool.

Project Page: https://github.com/eveseat/seat

Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#3 - 2017-01-23 21:04:21 UTC
Mysql is a suitable store, yes. Something like postgres is also suitable, though slightly harder to work with.

You need _something_ backend to run things. php is a common choice, and widely available.

Node.js is another popular choice. It's basically server side javascript (I dislike the concept, but eh, it's popular)

You'd use a script/program server side, to present data to the client side javascript. AJAX is a common way to do this. (yay, jquery :D )

As for updating it without your input, that's what cronjobs are for.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter

Blacksmoke16
Resilience.
#4 - 2017-01-24 06:29:05 UTC
Ruby on Rails \o/ with rake files and Whenever gem to handle the scheduled tasks :)
Mike Bergstrom
Harmonic Network
#5 - 2017-01-25 05:05:12 UTC
Wow thanks for the replies everyone!

After a bit of playing I was able to find out how to remotely grab the data via Jquery and convert to a json file and save it on the server. Which is great!

However I'm currently under the impression that grabbing the data from these sorts of links:

https://api.eveonline.com/char/CharacterSheet.xml.aspx?keyID=8763092&vCode=yGvQ7LtC9qsCFTn7O8YVHgZzkROGHIUB15hViuL0HtnxtqfHKdGNacdS3O427HQ8&characterID=96990995

Might not be the best way to go about this? I've been looking more into the api side of things and it seems like this is the "Old" api and might be going out the window/not completely up-to-date. Is this the case and would I be better off getting all of my character data from else where?

I see the ESI/swagger api already provides json files of some sort, so I'm currently looking into how to use it.

@Steve thanks! I actually had no idea cronjobs existed, so that's handy!

@qui1ckkkk That's quite neat, I'll check it out! My corp ceo might be interested in that!

@Blacksmoke16 That sounds interesting, but I don't want to focus on multiple languages at once. I'll look into it but I think I wont be going that direction.

Thanks again everyone!