Pages: [1] 2 3 4 :: one page |
|
Author |
Thread Statistics | Show CCP posts - 6 post(s) |
|
CCP Creber Cattus
C C P C C P Alliance
7
|
Posted - 2013.11.15 13:10:00 -
[1] - Quote
You can get it here
Noticeable changes are: The database dump is now exported from SQL Server 2012, so it can't be imported directly into SQL Server 2008 databases. tables that have to do with certificates have been removed from the database dump. certificates.yaml file has been added that contains data about the new certificates. [*] ship types (in the typesIDs.yaml file) now have a attribute called "masteries" that list all certificates needed for each mastery level. |
|
|
CCP Prism X
C C P C C P Alliance
1328
|
Posted - 2013.11.15 13:13:00 -
[2] - Quote
Why do you guys still do your dumps in MSSQL?! Nobody uses that bleep except you! Come join the NoSQL Revolution already! @CCP_PrismX EVE Database Developer and Expert Ranter Member of a Different Team, every day. |
|
|
CCP Prism X
C C P C C P Alliance
1328
|
Posted - 2013.11.15 13:15:00 -
[3] - Quote
Also, you only have four likes! Noob! @CCP_PrismX EVE Database Developer and Expert Ranter Member of a Different Team, every day. |
|
Peter Powers
Terrorists of Dimensions Free 2 Play
171
|
Posted - 2013.11.15 13:17:00 -
[4] - Quote
gave a fifth like, even if i don't like that mssql backup format. 3rdPartyEve.net - your catalogue for 3rd party applications |
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
2052
|
Posted - 2013.11.15 13:20:00 -
[5] - Quote
Thanks
Download started, so I can then go and poke through the rest of my process. Steve Ronuken for CSM 9! http://www.fuzzwork.co.uk/ Twitter: @fuzzysteve on Twitter |
|
Chribba
Otherworld Enterprises Otherworld Empire
10038
|
Posted - 2013.11.15 15:13:00 -
[6] - Quote
Thank you!
|
|
Rob Crowley
State War Academy
253
|
Posted - 2013.11.15 15:47:00 -
[7] - Quote
Ah, I love the smell of SDE in the morning. Smells like vicissitude.
Thanks! |
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
2055
|
Posted - 2013.11.15 16:37:00 -
[8] - Quote
https://www.fuzzwork.co.uk/dump/rubicon-1.0-93082/ https://www.fuzzwork.co.uk/dump/sqlite-latest.sqlite.bz2 (look ma! It's a symlink I'll try to keep pointing at the latest version!) https://www.fuzzwork.co.uk/dump/mysql56-rubicon-1.0-93082.tar.bz2 https://www.fuzzwork.co.uk/dump/rubicon-1.0-93082/postgres-rubicon-1.0-93082.sql.bz2 (floats converted to numerics) Steve Ronuken for CSM 9! http://www.fuzzwork.co.uk/ Twitter: @fuzzysteve on Twitter |
Hel O'Ween
Men On A Mission
32
|
Posted - 2013.11.15 17:08:00 -
[9] - Quote
Thanks! Now of to extract the stuff I need ...
CCP Prism X wrote:Why do you guys still do your dumps in MSSQL?! Nobody uses that bleep except you! Come join the NoSQL Revolution already!
I see what you did there ... EVEWalletAware - an offline wallet manager. |
Petrus Blackshell
Rifterlings Point Blank Alliance
2606
|
Posted - 2013.11.15 21:51:00 -
[10] - Quote
Thanks dude, but... is your server in good health? I'm trying to download the sqlite dump and it is stalling for large chunks of time (30+ seconds), missing data, and other stuff. Rifterlings - small gang frigate PvP - lowsec pirate operation, newbie-friendly, free ship program; Join today! www.rifterlings.com
Accidentally The Whole Frigate (blog) - Learning how to pew pew, one loss at a time - www.thewholefrigate.com |
|
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
2058
|
Posted - 2013.11.15 22:01:00 -
[11] - Quote
Petrus Blackshell wrote:Thanks dude, but... is your server in good health? I'm trying to download the sqlite dump and it is stalling for large chunks of time (30+ seconds), missing data, and other stuff.
I /think/ it's the network connection that's acting up, rather than the server. The monitoring software on the server itself isn't registering any problem, and the load is low.
But I do see it stalling sometimes. I'll dig, and have a yell at the support people.
anyway md5sums for files: sqlite file: 938546c5c004c3b06232044664a72993 postgres: bc01706e0a58f8ec46a4d27f7381073c mysql: b892df7fb6450cff8b6a79cf5e851e92 Steve Ronuken for CSM 9! http://www.fuzzwork.co.uk/ Twitter: @fuzzysteve on Twitter |
BinaryIdiot
Dreddit Test Alliance Please Ignore
0
|
Posted - 2013.11.16 05:19:00 -
[12] - Quote
You guys should export data in an interchange format so data can be...inter...changed (seriously, SQL dump? lol). |
Evanova Android
Traquenard Labs
14
|
Posted - 2013.11.18 02:00:00 -
[13] - Quote
The iconIDs.yaml file is illformed. There are "iconFile" entries that don't have single quotes (') around them, causing some parsers to think there are doubles instead of strings.
And yeah, why MSSQL? It's 2013! |
Rob Crowley
State War Academy
253
|
Posted - 2013.11.18 08:14:00 -
[14] - Quote
Evanova Android wrote:The iconIDs.yaml file is illformed. There are "iconFile" entries that don't have single quotes (') around them, causing some parsers to think there are doubles instead of strings. The quotes should be there if only for consistency's sake. But AFAICS all of those instances contain a "_", so it's really on the parsers if they can't tell it's a string. |
iskflakes
715
|
Posted - 2013.11.18 20:21:00 -
[15] - Quote
I would like my SDE dumps in a 300MB CSV file, thanks. - |
Zifrian
Licentia Ex Vereor Black Core Alliance
1102
|
Posted - 2013.11.18 23:16:00 -
[16] - Quote
Thanks!
I'm perfectly fine with MSSQL. I program in VB and use windows so it's easy cheesy for me. Only reason I still like it is because I don't want to update my crap to something I don't know anything about LOL
Maximze your Industry Potential! - Get EVE Isk per Hour! |
Zifrian
Licentia Ex Vereor Black Core Alliance
1102
|
Posted - 2013.11.18 23:53:00 -
[17] - Quote
BTW, new invention data (data cores, etc) for inventing the change with command ships isn't correct in the ramTypeRequirements table. The harbinger mats there don't have any records with activity = 8 for invention. Not sure of the others. I'm going to assume they are the same for all 4 for now. Maximze your Industry Potential! - Get EVE Isk per Hour! |
Aineko Macx
Royal Amarr Institute Amarr Empire
263
|
Posted - 2013.11.19 14:08:00 -
[18] - Quote
Zifrian wrote:BTW, new invention data (data cores, etc) for inventing the change with command ships isn't correct in the ramTypeRequirements table. The harbinger mats there don't have any records with activity = 8 for invention. Not sure of the others. I'm going to assume they are the same for all 4 for now. Confirming lack of requirements on activity = 8 on Harbinger Blueprint. |
Aineko Macx
Royal Amarr Institute Amarr Empire
263
|
Posted - 2013.11.19 19:26:00 -
[19] - Quote
A couple of inserts to complete the missing data:
Quote:INSERT INTO `ramTypeRequirements` VALUES (24699, 8, 20424, 16, 1, 0); INSERT INTO `ramTypeRequirements` VALUES (24699, 8, 25853, 1, 1, 0); INSERT INTO `ramTypeRequirements` VALUES (24699, 8, 25887, 16, 1, 0); INSERT INTO `ramTypeRequirements` VALUES (24701, 8, 20410, 16, 1, 0); INSERT INTO `ramTypeRequirements` VALUES (24701, 8, 20424, 16, 1, 0); INSERT INTO `ramTypeRequirements` VALUES (24701, 8, 25855, 1, 1, 0); INSERT INTO `ramTypeRequirements` VALUES (24703, 8, 20172, 16, 1, 0); INSERT INTO `ramTypeRequirements` VALUES (24703, 8, 20424, 16, 1, 0); INSERT INTO `ramTypeRequirements` VALUES (24703, 8, 25857, 1, 1, 0); INSERT INTO `ramTypeRequirements` VALUES (24697, 8, 20421, 16, 1, 0); INSERT INTO `ramTypeRequirements` VALUES (24697, 8, 20424, 16, 1, 0); INSERT INTO `ramTypeRequirements` VALUES (24697, 8, 25851, 1, 1, 0);
|
Veit o'Chron
Flying Spaceships n Stuff
0
|
Posted - 2013.11.19 21:59:00 -
[20] - Quote
Steve Ronuken wrote:conversion downloads
Thank you so much! |
|
Evanova Android
Traquenard Labs
14
|
Posted - 2013.11.19 23:42:00 -
[21] - Quote
Rob Crowley wrote:Evanova Android wrote:The iconIDs.yaml file is illformed. There are "iconFile" entries that don't have single quotes (') around them, causing some parsers to think there are doubles instead of strings. The quotes should be there if only for consistency's sake. But AFAICS all of those instances contain a "_", so it's really on the parsers if they can't tell it's a string.
Yes, and that's the problem, consistency. Either they all have quotes or they don't...Either way but one way only is consistency. |
Golden Gnu
EVE University Ivy League
104
|
Posted - 2013.11.20 12:34:00 -
[22] - Quote
@Steve Ronuken Thank you for the MySQL conversion Download is the meaning of life, upload is the meaning of intelligent life http://eve.nikr.net - home of jEveAssets |
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
2077
|
Posted - 2013.11.21 12:08:00 -
[23] - Quote
update invTypes set volume=200 where typeid=33400;
Steve Ronuken for CSM 9! http://www.fuzzwork.co.uk/ Twitter: @fuzzysteve on Twitter |
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
2078
|
Posted - 2013.11.21 16:18:00 -
[24] - Quote
https://github.com/fuzzysteve/yamlloader
https://www.fuzzwork.co.uk/dump/rubicon-1.0-93082/certCerts.sql.bz2 - 3 tables. Steve Ronuken for CSM 9! http://www.fuzzwork.co.uk/ Twitter: @fuzzysteve on Twitter |
Spc One
The Chodak Void Alliance
209
|
Posted - 2013.11.25 16:05:00 -
[25] - Quote
All Items & ID's:
http://www.netsky.org/db_rubicon1.0by_Spc_One.txt
All Items & ID's with description:
http://www.netsky.org/db_rubicon1.0Desc_by_Spc_One.txt
|
Gaius Henry
The Scope Gallente Federation
0
|
Posted - 2013.11.25 17:05:00 -
[26] - Quote
CCP Prism X wrote:Why do you guys still do your dumps in MSSQL?! Nobody uses that bleep except you! Come join the NoSQL Revolution already!
NoSQL usually refers to non-relational databases. But this dump _is_ relational (boys, if it's relational!). Also NoSQL databases usually don't handle big data very well.
I'd go with MySQL/PostgreSQL/whatever runnable on Linux at least.
Usually unofficial MySQL dumps lack of foreign keys. |
Aineko Macx
Royal Amarr Institute Amarr Empire
264
|
Posted - 2013.11.27 11:00:00 -
[27] - Quote
Gaius Henry wrote:Also NoSQL databases usually don't handle big data very well. Citation needed.
Quote:Usually unofficial MySQL dumps lack of foreign keys. I put together some ALTER TABLE commands to add them a while back. It's based on Crucible 1.1 so might need adaptation: http://pastebin.com/5dS84J8X |
|
CCP Creber Cattus
C C P C C P Alliance
21
|
Posted - 2013.11.29 16:30:00 -
[28] - Quote
Updated version of the SDE is now available. Rubicon 1.0.4
Get it here |
|
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
2099
|
Posted - 2013.11.29 18:09:00 -
[29] - Quote
Conversions, now including updated icon data and the new certificates (look for the cert* tables)
https://www.fuzzwork.co.uk/dump/mysql56-rubicon-1.0.4-93577.tar.bz2 https://www.fuzzwork.co.uk/dump/rubicon-1.0.4-93577/rubicon104.sqlite.bz2 https://www.fuzzwork.co.uk/dump/rubicon-1.0.4-93577/postgres-rubicon-1.0.4-93577.sql.bz2
csvs and sql dumps in. https://www.fuzzwork.co.uk/dump/rubicon-1.0.4-93577/ Steve Ronuken for CSM 9! http://www.fuzzwork.co.uk/ Twitter: @fuzzysteve on Twitter |
Rob Crowley
State War Academy
253
|
Posted - 2013.11.29 18:53:00 -
[30] - Quote
CCP Creber Cattus wrote:Updated version of the SDE is now available. Rubicon 1.0.4 Cool. CCP Creber Cattus best Cattus! Btw, did you misspell Creeper Cactus?
Though you can all thank me for doing some of the SDE fixes manually yesterday. I knew that would bring us an updated SDE within 24 hours. |
|
|
|
|
Pages: [1] 2 3 4 :: one page |
First page | Previous page | Next page | Last page |