DB Dump of past updates

[thorncorona]

Is it possible to get a DB dump of WSS?

[griffithchaffee]

Hi @thorncorona

Here is a direct download link with the latest story data (excludes session data for obvious reasons): wormstorysearch-2020-07-19.zip

Assuming you are using PostgreSQL, you can import the SQL file contained within the zip using a command similar to: cat wormstorysearch-2019-07-19.sql | psql -U postgres -h localhost postgres

List of tables:

archiveofourown_stories
archiveofourown_story_chapters
fanfiction_stories
fanfiction_story_chapters
identity_sessions # no data provided
questionablequesting_stories
questionablequesting_story_chapters
session_action_data # no data provided
spacebattles_stories
spacebattles_story_chapters
stories
story_authors
sufficientvelocity_stories
sufficientvelocity_story_chapters

[thorncorona]

Thanks!