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

Forum Index

EVE Forums » EVE Technology and Research Center » EVE Technology Lab » Rubicon SDE is out.

Topic is locked indefinitely.

Rubicon SDE is out. First post
Author

Previous Topic Next Topic

CCP Creber Cattus

C C P

C C P Alliance

Likes received: 44

#1 - 2013-11-15 13:10:36 UTC | Edited by: CCP Fozzie

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.

C C P C C P Alliance 1,689
CCP Prism X C C P C C P Alliance Likes received: 1,689	#2 - 2013-11-15 13:13:44 UTC 22 Why do you guys still do your dumps in MSSQL?! Nobody uses that bleep except you! Come join the NoSQL Revolution already! CCP Prism X Programmer on Team Gridlock & Expert Ranter


CCP Prism X C C P C C P Alliance Likes received: 1,689	#3 - 2013-11-15 13:15:11 UTC 11 Also, you only have four likes! Noob! CCP Prism X Programmer on Team Gridlock & Expert Ranter

Terrorists of Dimensions 271
Peter Powers Terrorists of Dimensions Likes received: 271	#4 - 2013-11-15 13:17:52 UTC gave a fifth like, even if i don't like that mssql backup format. 3rdPartyEve.net - your catalogue for 3rd party applications

Fuzzwork Enterprises Vote Steve Ronuken for CSM 6,759
Steve Ronuken Fuzzwork Enterprises Vote Steve Ronuken for CSM Likes received: 6,759	#5 - 2013-11-15 13:20:39 UTC 1 Thanks Download started, so I can then go and poke through the rest of my process. Woo! CSM XI! Fuzzwork Enterprises Twitter: @fuzzysteve on Twitter

Otherworld Enterprises Otherworld Empire 15,906
Chribba Otherworld Enterprises Otherworld Empire Likes received: 15,906	#6 - 2013-11-15 15:13:18 UTC Thank you! ★★★ Secure 3rd party service ★★★ Visit my in-game channel 'Holy Veldspar' Twitter @ChribbaVeldspar

State War Academy 312
Rob Crowley State War Academy Likes received: 312	#7 - 2013-11-15 15:47:48 UTC Ah, I love the smell of SDE in the morning. Smells like vicissitude. Thanks!

Steve Ronuken

Fuzzwork Enterprises

Vote Steve Ronuken for CSM

Likes received: 6,759

#8 - 2013-11-15 16:37:41 UTC

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)

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter

Men On A Mission 161
Hel O'Ween Men On A Mission Likes received: 161	#9 - 2013-11-15 17:08:05 UTC 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

Likes received: 3,297

#10 - 2013-11-15 21:51:18 UTC

Steve Ronuken 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.

Accidentally The Whole Frigate - For-newbies blog (currently on pause)

Steve Ronuken

Fuzzwork Enterprises

Vote Steve Ronuken for CSM

Likes received: 6,759

#11 - 2013-11-15 22:01:04 UTC | Edited by: Steve Ronuken

Petrus Blackshell wrote:

Steve Ronuken 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

That may be it cleared up now that I've disabled a 'performance' module.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter

BinaryIdiot Nexus 3
BinaryIdiot BinaryIdiot Nexus Likes received: 3	#12 - 2013-11-16 05:19:13 UTC 2 You guys should export data in an interchange format so data can be...inter...changed (seriously, SQL dump? lol).

Traquenard Labs 29
Evanova Android Traquenard Labs Likes received: 29	#13 - 2013-11-18 02:00:32 UTC 1 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! Evanova - The Android App for Eve Online

Rob Crowley

State War Academy

Likes received: 312

#14 - 2013-11-18 08:14:49 UTC

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.

954
iskflakes Likes received: 954	#15 - 2013-11-18 20:21:46 UTC 1 I would like my SDE dumps in a 300MB CSV file, thanks. -

Federal Defense Union Gallente Federation 1,825
Zifrian Federal Defense Union Gallente Federation Likes received: 1,825	#16 - 2013-11-18 23:16:47 UTC 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! - Download EVE Isk per Hour! Import CCP's SDE - EVE SDE Database Builder

Zifrian

Federal Defense Union

Gallente Federation

Likes received: 1,825

#17 - 2013-11-18 23:53:29 UTC

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! - Download EVE Isk per Hour!

Import CCP's SDE - EVE SDE Database Builder

Aineko Macx

Likes received: 367

#18 - 2013-11-19 14:08:13 UTC | Edited by: Aineko Macx

Zifrian wrote:

Confirming lack of requirements on activity = 8 on Harbinger, Myrmidon, Hurricane and Drake Blueprints.

iveeCore 3.0: The PHP engine for industrial activities and CREST library

Aineko Macx

Likes received: 367

#19 - 2013-11-19 19:26:44 UTC

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);

iveeCore 3.0: The PHP engine for industrial activities and CREST library

Republic University Minmatar Republic 0
Veit o'Chron Republic University Minmatar Republic Likes received: 0	#20 - 2013-11-19 21:59:48 UTC Steve Ronuken wrote: conversion downloads Thank you so much!