| Pages: 1 :: [one page] |
|
|
| Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Vyzion Eyri
The Southern Legion
The Umbra Combine
2219
   |
Posted - 2013.12.15 11:34:00 -
[1] - Quote
I just used three acronyms in that thread title that I have no idea about; not even sure if I used them in a sentence correctly. Would love to correct that. So all you geniuses out there, where would you recommend me to begin reading and learning if I wanted to start manipulating the SDE Foxfour gave us to extract some data? Specifically, I'm trying to separate items into categories (based on the in-game Marketplace) with their respective statistics.
"When nothing is going your way, go out of your way to do nothing."
|
S Park Finner
DUST University
Ivy League
348
|
Posted - 2013.12.15 18:43:00 -
[2] - Quote
I suspect your web searches have uncovered all this already but here's an example of the tool set some folks use...
Also -- I don't know how much background you have so I hope I don't offend by being too basic.
http://www.sqlite.org/ -- the sqlite home page
http://sqliteman.com/ -- an sqlite database browser to let you look through the DB from a GUI
http://php.net/ -- the home page of one of the languages (a little old school now-a-days) that can be used to write your own programs that use sqlite databases. Sqlite access is one of the options as an add-on for php.
https://netbeans.org -- one of several integrated development environments that can be used to organize your development of java, html, and php components in the web site / application you may want to build.
http://symfony.com/ -- one of several "PHP frameworks for web projects" -- there are a lot of fiddly-bits to any web project and frameworks are tool kits a procedures for taking care of them while you focus on the stuff that makes your web project different from all the rest.
For tutorials a google search for the component like "sqlite tutorial" will give you a lot of options. The sites themselves usually have tutorials as well. You might want an sql (data base language) tutorial as well if you don't have any background in that.
One popular site is
http://www.w3schools.com/
It is but to keep the nerves at strain, to dry one's eyes and laugh at a fall, and baffled, get up and begin again.
|
Musta Tornius
Turalyon 514
Turalyon Alliance
781
|
Posted - 2013.12.16 10:14:00 -
[3] - Quote
Another thing that will help you along is cross referencing your results with grit breather's site for instance:
http://pct-gritb.rhcloud.com/sde/type/352602
It's quite useful even if he doesn't think so yet :P
Dust514 Weapon Range & Information
Team Fairy DUST
|
Turkevich
Subdreddit
Test Alliance Please Ignore
109
|
Posted - 2013.12.16 21:51:00 -
[4] - Quote
Do you have a PC running Windows? If so, grab SQLiteSpy. With it you can explore the database and try out SQL queries to extract the data you want. |
Musta Tornius
Turalyon 514
Turalyon Alliance
786
|
Posted - 2013.12.16 23:19:00 -
[5] - Quote
Vyzion Eyri wrote:I just used three acronyms in that thread title that I have no idea about; not even sure if I used them in a sentence correctly. Would love to correct that. So all you geniuses out there, where would you recommend me to begin reading and learning if I wanted to start manipulating the SDE Foxfour gave us to extract some data? Specifically, I'm trying to separate items into categories (based on the in-game Marketplace) with their respective statistics.
Oh one more thing, sorting by market place is a bit fiddly and most likely not the way you want to do it. The problem creeps up when aurum and isk items are mixed in with one another and then trying to apply tiers too, it just doesn't work very well.
DUST514 Weapon Range & Information
Team Fairy DUST
|
SponkSponkSponk
The Southern Legion
The Umbra Combine
592
|
Posted - 2013.12.19 00:59:00 -
[6] - Quote
Fuzzy Steve's reworking of the Dust SDE to be more like the Eve SDE.
https://www.fuzzwork.co.uk/dump/dust/
"Pulvis et umbra sumus. (We are but dust and shadow.)"
GÇò Horace, The Odes of Horace
|
SponkSponkSponk
The Southern Legion
The Umbra Combine
593
|
Posted - 2013.12.19 05:25:00 -
[7] - Quote
Alternatively, work with Lukas Rox to get the Dust SDE integrated with the Eve SDE, like this:
http://pozniak.pl/database/index.php?id=10&id2=0&marketGroupID=355469
Then the next step is to get a basic, unskinned table of contents for a particular category, like chuker:
http://games.chruker.dk/eve_online/market.php?group_id=572
then you can include it into a wiki page using the Include plugin:
http://www.mediawiki.org/wiki/Extension:Include
(it gets updated whenever you edit the page)
Then add some CSS and you're done. :)
"Pulvis et umbra sumus. (We are but dust and shadow.)"
GÇò Horace, The Odes of Horace
|
Mithridates VI
Imperfects
Negative-Feedback
2307
|
Posted - 2013.12.23 20:43:00 -
[8] - Quote
Check out GalaXQL to learn SQL with excellent visual feedback on what each query does.
It has a graphical galaxy from which you select various groups of stars and star systems from, allowing you to get a good feel for how each query works. Built on SQLite.
Please refrain from utilizing such inflammatory sarcasm in the future. GÇö CCP Eterne
|
|
|
| |
|
| Pages: 1 :: [one page] |