Tuesday, October 27, 2009

Analog Science Fiction And Fact Database

Analog Science Fiction and Fact, at one time had a database, but in the course of events it dissolved into the void. Fortunately, Dave Baranyi has been keeping up the index on an Excel Spreadsheet. This is seventy (70) + years of data!

For several years, as an occasional project, I have been working on my own personal database of Science Fiction Stories. In the hopes of getting the Analog stories back on-line, sometime in the future, I have developed an Access database based on Dave's spreadsheet. This database is a prototype, there is still a lot of work to do, mainly getting the database moved over to MySQL (which I do not yet know) and learning PHP. So it will be a long time before this really becomes usable, in terms of the internet.

Below is the opening screen. This is not meant to be "pretty", since this is a prototype. The Analog cover to the left is meant to show that the cover art can be added when this gets closer to being completed. Some of the boxes that are currently visible will disappear in the final version (whenever it gets done) since they are only needed temporarily for programming purposes.

If any Analog subscribers would like a copy of the database leave me a message on the readers forum. (Click on the images to see them better.)

When you click on an authors name, all stories by that author in Analog are displayed.

Below is a screen image, from my existing book database, that cycles the cover art with the magazine issue.

Hopefully, the current Analog project can be expanded to include all magazines, especially those out of print. Sample below from my existing book database.

1 comment:

Sonya said...

Yay! the database! Though I have found other book database type programs online, I have not found any that seem to work as well/reliably as yours does. :( There was actually one that basically quit working after 50 books. Not bc it was a trial, but actually just had errors after that for unknown reasons.