posted Monday, September 16, 2002 - 07:59 PM (#1799)
The current status of the searchable archive.
All strips up to the beginning of this year have been entered and moderated. Strips are entered in the format of:
How many panels
then, for each panel:
Location(s) (I can't recall if we allowed 2 locations for split scenes or if we just made a split location entry)
Plot important props (much arguing here, I believe the current status is that ken and I have the final "agree to disagree" on it, he tries to include everything ("what if someone wants to see how many times jon had a sneaky cigarette?") and I include nothing, Nothing I tells ya!). Props included costumes.
Characters in the scene and any speech they uttered. A special character called correction for times when jon's grammar is "better" than ours repeats phrases in those cases.
A slight issue arose when we discovered a couple of things:
One, this project was done separate from the goats site and so has some data which is extra and so I'll need to do some munging and cleaning.
Two, As I wrote the stuff it was written in asp (and boy was it ugly - the focus was data entry not a user experience hehehe) with an MS SQL backend (spell corporate whore). I tried not to be too transact idiomatic but there are some things which won't work from my old stuff on the goats boxes (mySQL has no saved queries / views). The raw data itself is fine though.
Three, phillip has a beautiful and wonderful naming convention which I buggered up completely at the time. Since then I have adopted a variation of his and have decided I'd like to clean that up a little first before moving on much (I'm actually working on that in the background now)
Lastly, I suck at perl (although I'm getting better) and have got a new job this year (which has much less uhh "free learning time") so it has pretty much languished. The data entry site even went down as it was on my previous employers machines.
So. If someone good at perl (mod_perl, mason and mySQL if I recall correct) and willing to submit to phillip's naming conventions, my particular db design and luvrhino's pedantry is willing to jump on as the front end designer it would probably push us to move forward, otherwise I'll do it eventually.
Special thanks for the data entry have to go out to a bunch of people that gave up their lives for significant portions of last year to do the data entry: ken, chuck, dha, drew, davidb, punkalicia, mjfgates and stu. These people are primarily from the havoc known as goats fans and shows that roses do indeed grow from manure.
So for the resulting search engine / data entry.
Some thought will have to be given to the data entry. Who does it? who moderates it? the moderation took me a while to get to a point where I felt I was being consistent and I think the others that had a go felt the same way.
The searches can be quite complex if desired. (This could be resource costly and phillip may want to join in on that aspect if no other) Certainly I can help anyone doing the front end with sql queries etc although it is not a particularly complex db.
Lastly what it looks like is probably of some importance to people. I guess anything there would have to be run past jon(?).
So feel free to jump in with offers of help, questions etc.
All strips up to the beginning of this year have been entered and moderated. Strips are entered in the format of:
How many panels
then, for each panel:
Location(s) (I can't recall if we allowed 2 locations for split scenes or if we just made a split location entry)
Plot important props (much arguing here, I believe the current status is that ken and I have the final "agree to disagree" on it, he tries to include everything ("what if someone wants to see how many times jon had a sneaky cigarette?") and I include nothing, Nothing I tells ya!). Props included costumes.
Characters in the scene and any speech they uttered. A special character called correction for times when jon's grammar is "better" than ours repeats phrases in those cases.
A slight issue arose when we discovered a couple of things:
One, this project was done separate from the goats site and so has some data which is extra and so I'll need to do some munging and cleaning.
Two, As I wrote the stuff it was written in asp (and boy was it ugly - the focus was data entry not a user experience hehehe) with an MS SQL backend (spell corporate whore). I tried not to be too transact idiomatic but there are some things which won't work from my old stuff on the goats boxes (mySQL has no saved queries / views). The raw data itself is fine though.
Three, phillip has a beautiful and wonderful naming convention which I buggered up completely at the time. Since then I have adopted a variation of his and have decided I'd like to clean that up a little first before moving on much (I'm actually working on that in the background now)
Lastly, I suck at perl (although I'm getting better) and have got a new job this year (which has much less uhh "free learning time") so it has pretty much languished. The data entry site even went down as it was on my previous employers machines.
So. If someone good at perl (mod_perl, mason and mySQL if I recall correct) and willing to submit to phillip's naming conventions, my particular db design and luvrhino's pedantry is willing to jump on as the front end designer it would probably push us to move forward, otherwise I'll do it eventually.
Special thanks for the data entry have to go out to a bunch of people that gave up their lives for significant portions of last year to do the data entry: ken, chuck, dha, drew, davidb, punkalicia, mjfgates and stu. These people are primarily from the havoc known as goats fans and shows that roses do indeed grow from manure.
So for the resulting search engine / data entry.
Some thought will have to be given to the data entry. Who does it? who moderates it? the moderation took me a while to get to a point where I felt I was being consistent and I think the others that had a go felt the same way.
The searches can be quite complex if desired. (This could be resource costly and phillip may want to join in on that aspect if no other) Certainly I can help anyone doing the front end with sql queries etc although it is not a particularly complex db.
Lastly what it looks like is probably of some importance to people. I guess anything there would have to be run past jon(?).
So feel free to jump in with offers of help, questions etc.
