Issue number

[Sascha]

Hi,

today I downloaded the database from dev.comics.org/data and I tried
to figure out how to find the issue number. If I am not mistaken
data_item holds the equivalent of an issue, but where is the issue
number? Could sombody kindly give me Somerset hints?

Thanks a lot.

Sascha

[Ralf Haring]

It should be number column in the gcd_issue table.
http://dev.comics.org/data/2009-10-10/schema-vieuxbois-innodb.sql

CREATE TABLE `gcd_issue` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`number` varchar(50) NOT NULL,

-Ralf

> --
> GCD-Tech mailing list - gcd-...@googlegroups.com
> To unsubscribe send email to gcd-tech-u...@googlegroups.com
> For more options, visit this group at http://groups.google.com/group/gcd-tech

[Henry Andrews]

She's looking at the other schema. I'll explain in a bit.
-henry

----- Original Message ----
> From: Ralf Haring <ralf....@gmail.com>
> To: gcd-...@googlegroups.com
> Sent: Mon, November 23, 2009 9:36:26 AM
> Subject: Re: [gcd-tech] Issue number
>
> It should be number column in the gcd_issue table.
> http://dev.comics.org/data/2009-10-10/schema-vieuxbois-innodb.sql
>
> CREATE TABLE `gcd_issue` (
> `id` int(11) NOT NULL AUTO_INCREMENT,
> `number` varchar(50) NOT NULL,
>
> -Ralf
>

[Henry Andrews]

(um.. it occurs to me that I really have no idea if "Sascha" is a male or female name in Germany, or wherever is relevant- my apologies if I guessed wrong)

-henry


----- Original Message ----
> From: Henry Andrews <andrew...@yahoo.com>
> To: gcd-...@googlegroups.com
> Sent: Mon, November 23, 2009 9:52:34 AM
> Subject: Re: [gcd-tech] Issue number
>

[Sascha]

Hi,

> (um.. it occurs to me that I really have no idea if "Sascha" is a male or female name in Germany, or wherever is relevant- my apologies if I guessed wrong)

don't worry about that. Even though I am a male (at least last time I
checked) the name is used for male and female (e.g. female in france,
but I guess the name is spelled Sasha then, not sure though). Just
like Maria.

But back to the original topic.

Yes, I downloaded the data for the other schema from here:
http://dev.comics.org/data/2009-08-07/full-newfun.zip

Before we go into much detail I have a question: Since I am new to gcd
I don't know which database layout is the one I should use. data-
vieuxbois.zip seems to be an alternative, right?

Regards
The-certainly-male Sascha

[Henry Andrews]

Hi Sascha,
You're looking at the "New Fun" schema, which is definitely not human-friendly. It's designed to handle any complex situation that might come up (for instance, a volume and issue number in the indicia, but an entirely different issue number on the cover, with no volume number- in that case it will give you at least three numbers plus information on how to figure out which one you want). You need four or five tables to come up with anything resembling an issue number. We're also not using it right now. I recommend saving yourself a considerable headache and using the schema from our current beta release. It's the one marked "vieuxbois" here: http://dev.comics.org/data/2009-10-10/

You will need to create a database (for instance "CREATE DATABASE gcd DEFAULT CHARACTER SET utf8;") and then load a schema file, and then the data file. The InnoDB schema is what we use, and has proper foreign keys. It takes a *long* time to load (at least a half hour my 3GHz dual core CPU / 8GB RAM machine, up to five or so hours on an older one). The MyISAM schema has no foreign keys, but loads *much* faster (it will still take a while on an old computer, maybe 20 or 30 minutes, but nothing like the InnoDB one).

In the vieux bois schema (which will have some relatively minor changes within the next week), as Ralf said you want gcd_issue.number, and maybe gcd_issue.volume.

thanks,

-henry


----- Original Message ----

[Sascha]

Hi,

>   You're looking at the "New Fun" schema, which is definitely not human-friendly.  It's designed to handle any complex situation that might come up (for instance, a volume and issue number in the indicia, but an entirely different issue number on the cover, with no volume number- in that case it will give you at least three numbers plus information on how to figure out which one you want).  You need four or five tables to come up with anything resembling an issue number.  We're also not using it right now.  I recommend saving yourself a considerable headache and using the schema from our current beta release.  It's the one marked "vieuxbois" here:http://dev.comics.org/data/2009-10-10/

all right. Thanks for the answer. I already had the headache all day
long. :) Tomorrow I will download and have a look at it.

Regards,
Sascha

[Sascha]

> Before we go into much detail I have a question: Since I am new to gcd
> I don't know which database layout is the one I should use. data-
> vieuxbois.zip seems to be an alternative, right?

Henry already answered that questions.

Regards,
Sascha

[Henry Andrews]

Yup, as noted in my other message you want vieuxbois. Things are very chaotic here right now as we're scrambling to get the online indexing system back online :-) So the dumps are kind of just thrown out there sporadically and the documentation that you might find on the wiki is at best an approximation of what's going on. But "0.2 vieux bois" (named for http://en.wikipedia.org/wiki/Histoire_de_M._Vieux_Bois ) is the current release we're working on.

Anyway, welcome aboard! Are you working on any particular project or just interested in the data?

thanks,

-henry


----- Original Message ----

[Sascha]

Hi,

> Anyway, welcome aboard!  Are you working on any particular project or just interested in the data?

thanks for the welcome. I felt welcomed right away. :)

Yes I am working on a particular project, but I would rather not talk
about it right now until the the outcome of that project is available
in its full glory...at least in my dreams it will be glorious...but I
promise I will send an email to this group as soon as the time has
come.

Regards,
Sascha