intfiction.org

The Interactive Fiction Community Forum
It is currently Sat Nov 01, 2014 8:08 am

All times are UTC - 6 hours [ DST ]




Post new topic Reply to topic  [ 9 posts ] 
Author Message
 Post subject: IFDB database available
PostPosted: Sat Jul 21, 2012 6:17 pm 
Offline

Joined: Sat Jan 23, 2010 4:56 pm
Posts: 3506
After my experience at the "digital preservation" talk at the ELO conference last month, I asked Mike Roberts about getting a database dump of the IFDB service. This is now available on the Archive, in the ./info/ifdb directory:

http://ifarchive.org/indexes/if-archiveXinfoXifdb.html
http://ifarchive.org/if-archive/info/ifdb/

This is a MySQL dump containing all the public information in IFDB: game metadata, reviews, recommendation lists, comments, and so on. It contains public profile information, including your "who has played what" lists, but *excluding* passwords and other private account info. (As noted on the IFDB site, all this information is under a Creative Commons Attribution license.)

We plan to add a new (updated) dump every three months.

Hopefully this will be of some interest to IF researchers, today or someday. Thanks to Mike for agreeing to this and putting together the export process.


Top
 Profile Send private message  
 
PostPosted: Sat Jul 21, 2012 6:42 pm 
Offline
User avatar

Joined: Mon Oct 03, 2011 12:03 pm
Posts: 733
Location: Reading
If the internet is still around 100 years hence, I'm sure all the web-archaeologists doing their theses on the online presence of early 21st century interactive fiction will be very thankful.


Top
 Profile Send private message  
 
PostPosted: Sat Jul 21, 2012 10:04 pm 
Offline
User avatar

Joined: Wed Sep 01, 2010 1:50 am
Posts: 957
Location: Sydney, Australia
Neat!

- Wade


Top
 Profile Send private message  
 
PostPosted: Sat Jul 21, 2012 11:06 pm 
Offline
User avatar

Joined: Fri Apr 11, 2008 11:05 pm
Posts: 744
Location: Denver, Colorado
Awesome. Will the dumps be announced after this (on the IFDB news feed, or elsewhere?)

_________________
Games, Fonts, and Font-Toys For Gamers - http://www.cumberlandgames.com


Top
 Profile  
 
PostPosted: Sun Jul 22, 2012 9:47 am 
Offline

Joined: Sat Jan 23, 2010 4:56 pm
Posts: 3506
There's a "new additions to the Archive" RSS feed: http://ifarchive.org/indexes/archive.rss


Top
 Profile Send private message  
 
PostPosted: Sun Jul 22, 2012 9:50 am 
Offline
User avatar

Joined: Wed Oct 14, 2009 4:02 am
Posts: 1680
http://ifarchive.org/if-archive/new-since-last-post doesn't work :(, but it still linked to at http://ifarchive.org/indexes/if-archive.html


Top
 Profile Send private message  
 
PostPosted: Sun Jul 22, 2012 10:01 am 
Offline

Joined: Sat Jan 23, 2010 4:56 pm
Posts: 3506
Whoops, we retired that a couple of years ago. I'll remove it from the indexer template. (Should disappear tomorrow.)

Thanks.


Top
 Profile Send private message  
 
PostPosted: Fri Aug 17, 2012 2:08 pm 
Offline

Joined: Tue Dec 25, 2007 10:06 am
Posts: 1202
I can't find game ratings in the database. Are they not included?

_________________
Vorple UI libraryBeta testing siteBlog


Top
 Profile Send private message  
 
PostPosted: Fri Aug 17, 2012 2:18 pm 
Offline

Joined: Tue Dec 25, 2007 10:06 am
Posts: 1202
Never mind, found them: they're in the "reviews" table.

_________________
Vorple UI libraryBeta testing siteBlog


Top
 Profile Send private message  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 9 posts ] 

All times are UTC - 6 hours [ DST ]


Who is online

Users browsing this forum: Google Feedfetcher and 2 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Group