The Three Investigators Wiki
Advertisement
ISFDB: The Internet Speculative Fiction Database
Type of site
Online database
List of languages
OwnerAl von Ruff
Created byAl von Ruff and Ahasuerus
URLwww.isfdb.org
CommercialNo
RegistrationNone to view
Launched1995
Current status1,935,210 story titles from 225,074 authors[1]

The Internet Speculative Fiction Database (ISFDB) is a database of bibliographic information on genres considered speculative fiction, including science fiction and related genres such as fantasy fiction and horror fiction.[2][3] The ISFDB is a volunteer effort, with both the database and wiki being open for editing and user contributions. The ISFDB database and code are available under Creative Commons licensing.[4]

Purpose[]

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 online. ISFDB was the winner of the 2005 Wooden Rocket Award in the Best Directory Site category.[5]

While the ISFDB is primarily a bibliographic research database it also contains biographic data for books, authors, series, and publishers.

In 1998, Cory Doctorow wrote in Science Fiction Age: "The best all-round guide to things science-fictional remains the Internet Speculative Fiction Database".[3] 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."[6]

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.[7] It was also used in a series of tutorials by Lucid Imagination on Solr, an enterprise search platform.[8]

History[]

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.[9] Many of these bibliographies can still be found at The Linköping Science Fiction Archive.[10] In 1993, a searchable database of awards information was developed by Al von Ruff.[9] 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 contributor to rec.arts.sf.written) 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.[9][11]

The ISFDB was first located at an ISP in Champaign Illinois, but it suffered from constrained resources in disk space and database support, which limited its growth.[9] In October 1997 the ISFDB moved to SF Site, a major SF portal and review site.[3][9] Due to the rising costs of remaining with SF Site, the ISFDB moved to its own domain in December 2002. The site was quickly shut down by the hosting ISP due to high resource usage.[9][12]

In March 2003, after having been offline since January, the ISFDB began to be hosted by The Cushing Library Science Fiction and Fantasy Research Collection and Institute for Scientific Computation at Texas A&M University.[9][13][14] In 2007, after resource allocation problems with Texas A&M, the ISFDB became independently hosted on a hired server at the URL listed above.

The ISFDB was originally edited by a limited number of people, principally Al von Ruff and Ahasuerus.[15] However, in 2006 editing was opened to the general public on an Open Content basis. Changed content must be approved by one of a limited number of moderators, in an attempt to protect the accuracy of the content.[16]

Both the source code and content of the ISFDB are licensed under a Creative Commons Attribution license.[4] This was done on 27 February 2005.[9][17]

References[]

  1. "ISFDB Statistics". Internet Speculative Fiction Database. http://www.isfdb.org/cgi-bin/stats.cgi?4. 
  2. "Link Sites". SF Site. http://www.sfsite.com/depts/sites01.htm. 
  3. 3.0 3.1 3.2 Cory Doctorow (September 1998). "Internet Column from Science Fiction Age". Science Fiction Age. http://craphound.com/nonfic/16.html. "The best all-round guide to things science-fictional remains the Internet Speculative Fiction Database." 
  4. 4.0 4.1 "General disclaimer". ISFDB Wiki. ISFDB. http://www.isfdb.org/wiki/index.php/ISFDB:General_disclaimer#Copyright. 
  5. "2005 winners: Wooden Rocket Awards". SF Crowsnest. http://www.sfcrowsnest.com/wooden/wr_2005_winners.php. "14 Best Directory Site. Directories, online databases or search engines with a worthy SFF section. Winner: Internet Speculative Fiction Database www.isfdb.org." 
  6. Zenkat (2012-05-19). "The Freebase Blog » Blog Archive » Our latest mass data load: science fiction books". http://blog.freebase.com/2009/04/14/science-fiction-books/. "...it is widely considered one of the most authoritative sources about Science Fiction, Fantasy, and Horror literature available on the Internet." 
  7. <templatestyles src="Module:Citation/CS1/styles.css"></templatestyles>Halloway, Stuart Dabbs; Gehtland, Justin (2007). Rails For Java Developers (PDF). ISBN 978-0-9776166-9-5. Archived from the original (PDF) on 2011-07-10. Retrieved 2011-03-14.
  8. "Solr Powered ISFDB – Part #1". http://www.lucidimagination.com/blog/2011/01/21/solr-powered-isfdb-part1/. 
  9. 9.0 9.1 9.2 9.3 9.4 9.5 9.6 9.7 "Internet Speculative Fiction Database". onpedia. http://www.onpedia.com/encyclopedia/Internet-Speculative-Fiction-Database. 
  10. "The Linköping Science Fiction & Fantasy Archive". http://www.lysator.liu.se/sf_archive/. 
  11. "What's New". ISFDB. http://www.isfdb.org/wiki/index.php/What%27s_New. 
  12. Cory Doctorow (January 25, 2003). "Literary treasure needs new home". Boing Boing. http://www.boingboing.net/2003/01/25/literary-treasure-ne.html. 
  13. "ISFDB finds new home at Texas A&M". SFWA News. Science Fiction Writers of America. April 5, 2003. http://archive.sfwa.org/news/isfdbhome.htm. 
  14. Cory Doctorow (March 25, 2003). "ISFDB rises from the grave". Boing Boing. http://www.boingboing.net/2003/03/25/isfdb-rises-from-the.html. 
  15. "Major Contributors". ISFDB. http://www.isfdb.org/wiki/index.php/Major_Contributors. 
  16. Gandalara (December 23, 2006). "Changes to the ISFDB". Science Fiction Brewed Fresh Daily. Other*Worlds*Cafe. http://other-worlds-cafe.com/news/blog/?m=200612. 
  17. "What's New – 27 Feb 2005". ISFDB What's New. ISFDB. 27 February 2005. http://www.isfdb.org/wiki/index.php/What%27s_New_from_2005#What.27s_New_-_27_Feb_2005. 

External links[]

Advertisement