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.
 

Odyssey SDE is out!

First post
Author
Previous Topic Next Topic
CCP Prism X
C C P
C C P Alliance
#1 - 2013-06-24 15:23:06 UTC  |  Edited by: CCP Prism X
Get it here!

Leave feedback in this post!

CCP Prism X

Programmer on Team Gridlock & Expert Ranter
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#2 - 2013-06-24 15:24:15 UTC
Or here, if you don't want an SQL server version!

https://forums.eveonline.com/default.aspx?g=posts&t=250491&find=unread

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Jercy Fravowitz
School of Applied Knowledge
Caldari State
#3 - 2013-06-24 16:06:25 UTC
... or get the 1.0.9 mysql, postgres, sqlite versions here ...

- more uptodate than 1.0.7!
- more complete!
- more compatible!
Tarlson
Garoun Investment Bank
Gallente Federation
#4 - 2013-08-13 23:50:55 UTC
When we gonna get 1.1?
Titus Balls
Sebiestor Tribe
Minmatar Republic
#5 - 2013-08-28 08:25:58 UTC
Will 1.1 be out before 3rd? I'd like to prepare my app for the changes.
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#6 - 2013-09-02 18:20:42 UTC  |  Edited by: Steve Ronuken
New version is out.

https://www.fuzzwork.co.uk/dump/mysql56-odyssey-1.1-91288.tar.bz2
https://www.fuzzwork.co.uk/dump/odyssey-1.1-91288/odyssey11.sqlite.bz2

https://www.fuzzwork.co.uk/dump/odyssey-1.1-91288/

https://www.fuzzwork.co.uk/dump/odyssey-1.1-91288/postgres-odyssey-1.1-91288.sql.bz2

This is converted using a new method, so there /may/ be issues with it. The row count matches what's in the MS SQL version, and when I retrieved the values using a utf8 capable client, I saw them.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#7 - 2013-09-03 10:05:31 UTC
Golden Gnu
The Golden Gnu Corp
#8 - 2013-09-03 12:02:32 UTC  |  Edited by: Golden Gnu
@fuzzysteve
Thank you! Big smile

EDIT: No UTF-8 problems found in the tables jEveAssets use. Great work!
It's awesome I do not have to install the MSSQL monster anymore Big smile

Creator of jEveAssets - the asset manager

"Download is the meaning of life, upload is the meaning of intelligent life"
Muscaat
EVE Markets
#9 - 2013-09-03 21:30:32 UTC
Many thanks as always, Steve Smile
Tennoku
Mercury Nation
#10 - 2013-09-17 00:50:15 UTC
Thanks for the postgres output!

One thing, I need to surround the table name with quotes:
select * from "mapRegions";

Seems the data file has quotes around all the table names, but that's easy for me to fix.
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#11 - 2013-09-17 02:51:08 UTC
Tennoku wrote:
Thanks for the postgres output!

One thing, I need to surround the table name with quotes:
select * from "mapRegions";

Seems the data file has quotes around all the table names, but that's easy for me to fix.



It's a side effect of the migration method I'm using. It preserves the case of the names, so to access them, you have to match the case. which means quotes.

I'm considering a case sensitive and a lowercased version. Though lowercasing everythign has a few issues of its own.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Tennoku
Mercury Nation
#12 - 2013-09-17 03:35:16 UTC
Steve Ronuken wrote:

It's a side effect of the migration method I'm using. It preserves the case of the names, so to access them, you have to match the case. which means quotes.

I'm considering a case sensitive and a lowercased version. Though lowercasing everythign has a few issues of its own.


Yeah, I just finished earlier converting the data file to no longer have the quotes, and noticed as you say that it puts everything lower case. I still prefer it without quotation marks though. Another issue is that xmin and xmax are system names, so I had to rename those columns :(

What are the issues with lowercasing?
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#13 - 2013-09-17 09:54:11 UTC
Mostly the xmax and xmin. Smile Along with a side order of 'I'm lazy and already wrote everything to use the case sensitive names' Blink

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Tennoku
Mercury Nation
#14 - 2013-09-17 10:52:06 UTC
Steve Ronuken wrote:
Mostly the xmax and xmin. Smile Along with a side order of 'I'm lazy and already wrote everything to use the case sensitive names' Blink


Even though the quotations are annoying, it *might* be best that you leave them in, just so that as much information as possible is preserved, and people can make their own choice to change it.

I'll be using without quotations, just lower case, because I'm working on a new project and don't want to have to type in quotations. Was very glad to find your postgres version :)