*** Welcome to piglix ***

Internet Speculative Fiction Database

ISFDB: The Internet Speculative Fiction Database
Type of site
Online database
Owner Al von Ruff
Created by Al von Ruff and Ahasuerus
Website www.isfdb.org
Commercial No
Registration None to view
Launched 1995
Current status 1,029,469 story titles from 126,852 authors

The ISFDB database indexes authors, novels, short stories, publishers, awards, and magazines. Additionally, it supports author pseudonyms, series, awards, and cover art plus interior illustration credits which is combined into integrated author, artist, and publisher bibliographies. An ongoing effort is verification of publication contents and secondary bibliographic sources against the database with the goals being data accuracy and to improve the coverage of speculative fiction to 100%. The current database statistics are available on line. ISFDB was the winner of the 2005 Wooden Rocket Award in the Best Directory Site category.

In 1998, Cory Doctorow wrote in Science Fiction Age: "The best all-round guide to things science-fictional remains the Internet Speculative Fiction Database". In April 2009, Zenkat wrote on Freebase "...it is widely considered one of the most authoritative sources about Science Fiction, Fantasy, and Horror literature available on the Internet."

As of May 2009, Quantcast estimates that the ISFDB is visited by over 32,000 people monthly.

As a real-world example of a non-trivial database, the schema and MySQL files from the ISFDB have been used in a number of tutorials. ISFDB schema and data were used throughout Chapter 9 of the book Rails For Java Developers. It was also used in a series of tutorials by Lucid Imagination on Solr, an enterprise search platform.

Several speculative fiction author bibliographies were posted to the USENET newsgroup rec.arts.sf.written from 1984 to 1994 by Jerry Boyajian, Gregory J. E. Rawlins and John Wenn. A more or less standard bibliographic format was developed for these postings. Many of these bibliographies can still be found at The Linköping Science Fiction Archive. In 1993, a searchable database of awards information was developed by Al von Ruff. In 1994, John R. R. Leavitt created the Speculative Fiction Clearing House (SFCH). In late 1994, he asked for help in-displaying awards information, and von Ruff offered his database tools. Leavitt declined, because he wanted code that could interact with other aspects of the site. In 1995, Al von Ruff and Ahasuerus (a prolific rec.arts.sf.written author) started to construct the ISFDB, based on experience with the SFCH and the bibliographic format finalized by John Wenn. The ISFDB went live in September 1995, and a URL was published in January 1996.


...
Wikipedia

...