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 Information Portal

 
  • Topic is locked indefinitely.
123Next page
 

Dev blog: EVE Universe Static Data Export

First post
Author
Previous Topic Next Topic
CCP Gargant
C C P
C C P Alliance
#1 - 2014-02-14 16:01:00 UTC  |  Edited by: CCP Phantom
The Universe has to be maintained - and here with some news on how that maintenance is going is CCP Nobody! He has written a devblog which introduces the Universe Data Migration, which has been in testing on SiSi now for some time. What does this mean for you?

Find out here!

CCP Gargant | EVE Universe esports Coordinator
Querns
Science and Trade Institute
Caldari State
#2 - 2014-02-14 16:10:24 UTC  |  Edited by: Querns
Nice, thanks for the update.

One question: The devblog said that x, y, z coordinates for solar systems may have changed. Do you or CCP Nobody have any ideas as to the scale of the changes (e.g.: are they off by meters, or kilometers, or AU, or even LY?) This might have an ancillary effect on capital jump geography, if the values in the new data export are also reflecting a change in the game data itself, and I'm just wondering if we should be rethinking how we move capital ships in-game because of these changes.

This post was crafted by the wormhole expert of the Goonswarm Economic Warfare Cabal, the foremost authority on Eve: Online economics and gameplay.
Mashie Saldana
V0LTA
New Eden Alliance 99013733
#3 - 2014-02-14 16:10:35 UTC
Oh, Friday devblog p0rn.

How to win EVE
Chribba
Otherworld Enterprises
Otherworld Empire
#4 - 2014-02-14 16:11:14 UTC
Lovely!

/c

★★★ Secure 3rd party service ★★★

Visit my in-game channel 'Holy Veldspar'

Twitter @ChribbaVeldspar
CCP Xhagen
C C P
C C P Alliance
#5 - 2014-02-14 16:14:27 UTC
Querns wrote:
Nice, thanks for the update.

One question: The devblog said that x, y, z coordinates for solar systems may have changed. Do you or CCP Nobody have any ideas as to the scale of the changes (e.g.: are they off by meters, or kilometers, or AU, or even LY?) This might have an ancillary effect on capital jump geography, if the values in the new data export are also reflecting a change in the game data itself, and I'm just wondering if we should be rethinking how we move capital ships in-game because of these changes.

They should only be off by a meter or two.

CCP Xhagen | Associate Producer | @strangelocation
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#6 - 2014-02-14 16:20:05 UTC  |  Edited by: Steve Ronuken
/me buries his head in his hands. More stuff to convert.

Wonder if anyone would notice if I just sneak in the old tables Blink

Edit:

On reading:
\o/

All looks good to me. I'll probably do conversions to mysql and postgres for it, and possibly a combined sqlite DB.

I'll get onto that conversion later today, when I'm at home.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Benny Ohu
Royal Amarr Institute
Amarr Empire
#7 - 2014-02-14 16:20:55 UTC
CCP Xhagen wrote:
They should only be off by a meter or two.

not just one metre but possibly two??

D: gearing up to shot statue
GavinGoodrich
Perkone
Caldari State
#8 - 2014-02-14 16:22:44 UTC
Somone mind giving a layman's version of what just happened? I mean that's great and all but most of that went over my head and lit it on fire (see avatar).

Haaaaaalp my head's on fire
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#9 - 2014-02-14 16:26:14 UTC
GavinGoodrich wrote:
Somone mind giving a layman's version of what just happened? I mean that's great and all but most of that went over my head and lit it on fire (see avatar).



They're moving where they're storing things like where planets and asteroids are.

This is so they can make changes more easily. Thankfully, they're giving us the compiled version, rather than the version that is in the build system (which is likely yaml, and a pain to deal with)

Being sqlite means it's easier to play with for most people, as they don't need to have MS SQL server.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
CCP Xhagen
C C P
C C P Alliance
#10 - 2014-02-14 16:35:07 UTC
Benny Ohu wrote:
CCP Xhagen wrote:
They should only be off by a meter or two.

not just one metre but possibly two??

D: gearing up to shot statue

Only if you can find it again!

CCP Xhagen | Associate Producer | @strangelocation
Marcel Devereux
Aideron Robotics
Aideron Robotics.
#11 - 2014-02-14 16:35:55 UTC
Can you guys move everything into source control? I would love to just get a sqlite database generated as an artifact from your build system. I seem to remember you promising to do this last Fanfest.
Lucas Kell
Solitude Trading
S.N.O.T.
#12 - 2014-02-14 16:36:55 UTC
Steve Ronuken wrote:
GavinGoodrich wrote:
Somone mind giving a layman's version of what just happened? I mean that's great and all but most of that went over my head and lit it on fire (see avatar).



They're moving where they're storing things like where planets and asteroids are.

This is so they can make changes more easily. Thankfully, they're giving us the compiled version, rather than the version that is in the build system (which is likely yaml, and a pain to deal with)

Being sqlite means it's easier to play with for most people, as they don't need to have MS SQL server.
What kind of weirdo doesn't have SQL server? :D

The Indecisive Noob - EVE fan blog.

Wholesale Trading - The new bulk trading mailing list.
Querns
Science and Trade Institute
Caldari State
#13 - 2014-02-14 16:37:34 UTC
CCP Xhagen wrote:
Querns wrote:
Nice, thanks for the update.

One question: The devblog said that x, y, z coordinates for solar systems may have changed. Do you or CCP Nobody have any ideas as to the scale of the changes (e.g.: are they off by meters, or kilometers, or AU, or even LY?) This might have an ancillary effect on capital jump geography, if the values in the new data export are also reflecting a change in the game data itself, and I'm just wondering if we should be rethinking how we move capital ships in-game because of these changes.

They should only be off by a meter or two.

Okay, crisis averted. Thanks for the followup :)

This post was crafted by the wormhole expert of the Goonswarm Economic Warfare Cabal, the foremost authority on Eve: Online economics and gameplay.
Peter Powers
Terrorists of Dimensions
#14 - 2014-02-14 16:41:15 UTC
CCP Nobody wrote:

What does this mean for the regular pod pilot? Players should not notice any difference what-so-ever.


FYI: we 3rd party guys are players as well.

3rdPartyEve.net - your catalogue for 3rd party applications
War Kitten
Panda McLegion
#15 - 2014-02-14 16:54:53 UTC
So when can we expect stars, moons, planets and other celestials to start orbiting each other?

I don't judge people by their race, religion, color, size, age, gender, or ethnicity. I judge them by their grammar, spelling, syntax, punctuation, clarity of expression, and logical consistency.
Atum
Eclipse Industrials
Quantum Forge
#16 - 2014-02-14 16:57:22 UTC
Except for finding a sqlite program as nice as Microsoft's freebie SQL Server Management Studio (suggestions please!) and pointing at the new file, does anything else need to change in how the queries that create EVEMap's data files work (yes, I'm still plinking at it as my 7-month old allows, but hey, it's working!)? At the moment, I use the raw MS-SQL database backup, pull it into SMS, run my SELECT scripts and export the results to a CSV file. If I'm reading this right, all but one of the tables involved (dbo.chrFactions) are being moved out of the static dump and into a new sqlite db, but apart from a meter here or there, none of the columns/data (apart from landmarks, which I don't use) is changing.
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#17 - 2014-02-14 17:02:10 UTC
Atum wrote:
Except for finding a sqlite program as nice as Microsoft's freebie SQL Server Management Studio (suggestions please!) and pointing at the new file, does anything else need to change in how the queries that create EVEMap's data files work (yes, I'm still plinking at it as my 7-month old allows, but hey, it's working!)? At the moment, I use the raw MS-SQL database backup, pull it into SMS, run my SELECT scripts and export the results to a CSV file. If I'm reading this right, all but one of the tables involved (dbo.chrFactions) are being moved out of the static dump and into a new sqlite db, but apart from a meter here or there, none of the columns/data (apart from landmarks, which I don't use) is changing.



I've heard that http://sourceforge.net/projects/sqlitebrowser/ isn't bad.


For the export, there's always the list command, on the command line tool.

I've never used it, but http://sqlitestudio.pl/ may suit you.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Makoto Priano
Kirkinen-Arataka Transhuman Zenith Consulting Ltd.
Arataka Research Consortium
#18 - 2014-02-14 17:12:04 UTC
So, the questions: is this the change needed to allow for creation of structures to not be tied to downtime, a la player-created stations? And would this change now allow players-- with new game mechanics, of course --to destroy stations and stargates? Or would this allow, say, wormhole signatures to retain their IDs across downtime?

Basically: obviously this has a lot of utility. Is this being deployed primarily for Team Gridlock purposes, or is its primary aim backbone for the summer expansion?

Itsukame-Zainou Hyperspatial Inquiries: exploring the edge of the known, advancing the state of the art. Would you like to know more?
Benny Ohu
Royal Amarr Institute
Amarr Empire
#19 - 2014-02-14 17:25:34 UTC
Makoto Priano wrote:
So, the questions: is this the change needed to allow for creation of structures to not be tied to downtime, a la player-created stations? And would this change now allow players-- with new game mechanics, of course --to destroy stations and stargates? Or would this allow, say, wormhole signatures to retain their IDs across downtime?

Basically: obviously this has a lot of utility. Is this being deployed primarily for Team Gridlock purposes, or is its primary aim backbone for the summer expansion?

Since CCP has talked about a content arc over the next few expansions that involves building stargates and new space, this might be foundation for developing that feature? I don't know computer :(
Gilbaron
The Scope
Gallente Federation
#20 - 2014-02-14 17:26:29 UTC
so, is this one of the "what could possibly go wrong" updates ?
123Next page