Database updated

mjp

Keep my good eye on the beat
Moderator
Founding member
Over 5000 posts
#1
In the never ending battle between good and evil, we make one small step toward the good tonight, as I have completed phase I of the database update.

The last book added to the old database was Slouching Toward Nirvana, so there are a lot of new entries.

Also, the interface has been changed to provide better results pages. Now instead of a long list with duplicate titles and no order, things are tidier and more readable.

There is an advanced search and some other bells and whistles that still need to be finished up, but that old database has been mocking me for years, so I wanted to get the new data out there and freshen the joint up a bit.

I trust that you'll tell me when you find broken stuff. I've been staring at code for the better part of 10 hours, so I'm sure there's some slop somewhere.
 
#4
labor of love, or obsessed buckethead? you be the judge. i love him either way.
We do too, but thanks for taking care of the whole carnal thing so we don't have to.

Looks good on first glance, mjp. Great work. And I learned something:

The Whores, The People At Taco Stands, The Bus Drivers, The Cops, The Killers, The Janitors, The Highschool Teachers, The Priests And The Garbagemen was written by Buk, not Hosh.

Now, if you could just reconcile all the nearly identical works with different titles and highlight edits made by JM in red and those made by Buk in blue, we'll be all set. I can wait until tomorrow evening for that.
 

mjp

Keep my good eye on the beat
Moderator
Founding member
Over 5000 posts
#6
Now, if you could just reconcile all the nearly identical works with different titles and highlight edits made by JM in red and those made by Buk in blue, we'll be all set.
I'll get right on that.

Minus the different colored edit comparisons (for now anyway), something along those lines is already in the works. Check out the Alternate titles/versions line in this entry. If you click on the alternate title it takes you to the other publication. There are only about 30 entries in that table at the moment, but it's something that will be there in the future for a lot more titles.

There's only one Forum item entry right now, but you can see the idea behind it.

There is something else in the works that I can't really talk about because it might ruffle some feathers. But it will be cool. You know, someday.

FYI: The database currently contains:
  • 4175 poems and stories in 113 books
  • 1609 poems and stories in 703 magazines
  • 56 broadsides
  • 682 manuscripts
  • 1 other items
  • 1 forum links
 

cirerita

Founding member
Over 1000 posts
#9
Labor of love, indeed. Thanks for the update. I'm sure the Alternate Titles part was a bit of a headache, wasn't it?

One thing which was cool in the old database was the ability to list everything by year, by magazine, by book, etc. Will that work in the new one?
 

mjp

Keep my good eye on the beat
Moderator
Founding member
Over 5000 posts
#10
Where do we put the money when it goes to pay per view?
Look for the pocket icon and tuck something in there.

One thing which was cool in the old database was the ability to list everything by year, by magazine, by book, etc. Will that work in the new one?
Yeah, that's part of the advanced search. It's all in place, I just have to make it work somehow. ;)
 

hank solo

Just practicin' steps and keepin' outta the fights
Moderator
Founding member
Over 1000 posts
#11
Cool. Looking good.

Anyone using the old Firefox search plug in will need an update. You must remove the old version first.

The new one is here.

NB: This plug-in performs the loose match search function.
 
#12
I'll get right on that.

Minus the different colored edit comparisons (for now anyway), something along those lines is already in the works. Check out the Alternate titles/versions line in this entry. If you click on the alternate title it takes you to the other publication. There are only about 30 entries in that table at the moment, but it's something that will be there in the future for a lot more titles.
Excellent! That's going to take some dirty fingernails to bring it anywhere near completion, so thanks for taking that on in any fashion.
 

Bukfan

"The law is wrong; I am right"
Over 5000 posts
#14
It looks great! I can't even begin to imagine the hours mjp has spent on this. Thanks for the update!
 
Last edited by a moderator:

mjp

Keep my good eye on the beat
Moderator
Founding member
Over 5000 posts
#17
The advanced search features have been activated. They are basically just filters, but they can be pretty useful. I wasn't going to do it today, but there you go. If I didn't do it today it might have been another 4 years.
 

esart

esart.com
Founding member
Over 500 posts
#18
he's actually still tinkering with it and ironing out the kinks, etc. it really is a labor of love and i know we all appreciate his hard work. but i have to tell you guys that i share an office with mjp and right now he's driving me absolutely bonkers! every time something doesn't work right, he gets duly frustrated and he is vocal about it. i sit at my computer and i try to read things on the internets that interest me, but it's near impossible when you have a cranky old man talking to himself behind you. let's hope he gets this thing fixed soon for all our sakes. LOL!!!!
 

Stavrogin

Over 1000 posts
#19
mjp's workplace.jpg


To keep yourself from going bonkers crack him over the head with something. Do you have a heavy duty stapler (the key word is heavy)? I think I speak for everyone in saying we can wait just a few more days.
 

mjp

Keep my good eye on the beat
Moderator
Founding member
Over 5000 posts
#20
There are a lot of staplers in here, but many other things that would make much better weapons.

---

In order to distract everyone from the bugs and glitches in the new database, I present you with this wonderful guessing contest:
  • The old database consisted of one table with 5,599 records. The new database has 10 tables and...how many records?
To help your guess I'll tell you that two of those tables only have one entry each, two have over 4000 each and the total is a five digit number.

Closest guess wins an Absence of the Hero ARC, a Good Humor Strawberry Shortcake frozen treat wrapper and a Mother's Joy Raisin Bran box top. You must be 18 or older to play, void where prohibited.
 

LickTheStar

Sad Flower in the Sand
Over 1000 posts
#23
Glad to see this insane project has been updated and continued. Looks great! I've been hearing about this since I showed up! Advanced Search is especially useful.
 

esart

esart.com
Founding member
Over 500 posts
#24
...well, a (sometimes) cranky old man that i love to grow old and (sometimes) cranky with myself.
 
#30
By definition, any guess is potentially laughable (even my noble attempt which was scientifically-enhanced by choosing random numbers that added up to 10,000+). Can't win if you don't play.
 
Top