Skip to content


Subversion checkout URL

You can clone with
Download ZIP
Django site for multimedia annotations facilitating collaboration on video and image analysis. Developed at the Columbia Center for New Media Teaching and Learning
JavaScript Python HTML CSS Cucumber Makefile

Merge pull request #349 from ccnmtl/sqlparse-0.1.16

:arrow_up: sqlparse 0.1.16. PMT #101212
latest commit da23e61287
@sdreher sdreher authored



Build Status

Mediathread is a Django site for multimedia annotations facilitating collaboration on video and image analysis. Developed at the Columbia Center for New Media Teaching and Learning (CCNMTL)

CODE: (see wiki for some dev documentation)


Python 2.7 (Python 2.6 is still supported, but we encourage you to upgrade.)
Postgres (or MySQL)
Flowplayer installation for your site (See below for detailed instructions)
Flickr API Key if you want to bookmark from FLICKR


  1. Clone Mediathread

    git clone

  2. Build the database
    For Postgres (preferred):
    A. Create the database createdb mediathread

    For MySQL: (Note: Mediathread is not well-tested on recent version of MySQL.)
    A. Edit the file requirements.txt
    - comment out the line psycopg2
    - uncomment the MySQL-python line.

    B. Create the database

    echo "CREATE DATABASE mediathread" | mysql -uroot -p mysql

  3. Customize settings
    Create a file in the mediathread subdirectory. Override the variables from that you need to customize for your local installation. At a minimum, you will need to customize your DATABASES dictionary.

    For more extensive customization and template overrides, you can create a deploy_specific directory to house a site-specific file:

     $ mkdir deploy_specific
     $ touch deploy_specific/
     $ touch deploy_specific/

    Edit the deploy_specific/ and override values in like the DATABASES dictionary. This is where we add custom settings and templates for our deployment that will not be included in the open-sourced distribution.

  4. Build the virtual environment Bootstrap uses virtualenv to build a contained library in ve/


The rest of the instructions work like standard Django. See: for more details.

  1. Sync the database

    ./ syncdb. # When asked to create a superuser, do so. ./ migrate # completes the south migration setup

  2. Run locally (during development only) ./ runserver

Go to your site in a web browser.

  1. The default database is not very useful. You'll need to create a course and some users. Login with the superuser you created in Step #5.

  2. Click the 'Create a Course' link.

    • Click the "+" to make a group. Name it something like "test_course"
    • Click the "+" to make a faculty group. Name it something like "test_course_faculty"
      • In the "Add users to group" field...
        • add yourself as a faculty member by putting your username with a "" in front like this "admin"
        • add some fellow faculty/student accounts -- you can create new accounts right here (read the instructions under the textarea)
      • Click "Save" and then click the upper-right link "Django administration" to get back to the regular site (yeah, not the most intuitive).
  3. Experiment with saving assets by visiting:


Mediathread makes use of the Django Sites framework.

By default, Django creates a site called "" with an id of 1. This id is referenced in as SITE_ID=1.

In your production environment, RENAME to your domain.

If a new site is created, update SITE_ID= in your deploy_specific/ or


ALLOWED_HOSTS is "a list of strings representing the host/domain names that this Django site can serve. This is a security measure to prevent an attacker from poisoning caches and password reset emails with links to malicious hosts by submitting requests with a fake HTTP Host header, which is possible even under many seemingly-safe web server configurations." More here:

Make sure the ALLOWED_HOSTS is set properly in your deploy_specific/ or


For deployment to Apache, see our sample configuration in apache/sample.conf. This directory also contains standard django.wsgi file which can be used with other webservers


To support bookmarking assets from a variety of external sites, Mediathread instances must be accessible via http:// and https://


Mediathread instantiates a Flowplayer .swf or HTML5 player to play many video flavors. Flowplayer requires you to have a local installation and will not allow you to serve the player off their site. Free versions exist for both players. Here are the basic instructions to install Flowplayer on your systems and point Mediathread at it.

  1. Both versions are available here.
  2. Install both versions on a public server on your site.
  3. In the same directory as the Flash player, also install: - flowplayer.rtmp-3.2.13.swf - flowplayer.pseudostreaming-3.2.13.swf -

  4. In your or (better) deploy_specific/ set FLOWPLAYER_SWF_LOCATION, like so:
    FLOWPLAYER_SWF_LOCATION= 'http://servername/directory/flowplayer-3.2.15.swf' FLOWPLAYER_HTML5_LOCATION = 'http:///flowplayer-5.5.0/flowplayer.min.js'
    FLOWPLAYER_PSEUDOSTREAMING_PLUGIN = 'flowplayer.pseudostreaming-3.2.11.swf'
    FLOWPLAYER_RTMP_PLUGIN = 'flowplayer.rtmp-3.2.11.swf'

  • For Flash, the plugins are picked up automatically from the same directory, so don't need the full path.
  • These are the versions we are currently using in production here at CU.


In your or (better) deploy_specific/ specify your Flickr api key.


Mediathread's About & Help pages are constructed using the Django Flat Pages architecture. ( In order to setup pages for your site, follow these steps:

  1. Navigate to the Mediathread /admin/ area, Flatpages.

  2. Create a new flat page, e.g. url: /help/ or /about/, select your domain site site and add content.

  3. Save.

  4. The page should be immediately available by navigating to yourdomain/help/ or yourdomain/about/


Our help documentation tailored for the Columbia community and our in-house video upload system is here:

And, Nate Autune helpfully added this a few months ago, "Thanks to Rebecca Darling from Wellesley College, who graciously gave permission to re-publish her "Mediathread Guide for Students" under a Creative Commons license. Here is a link to where you can download it:"


  1. Current development on the Mediathread bookmarklet is aimed at supporting the standard set forth by ( This format includes a system of hierarchal terms and their associated values. Use of the metadata terms itemscope, itemtype, and itemprop are used to help stucture the data such that Mediathread can make sense of what metadata is assocaited to the item or items being brought into the application. Examples of this structure can be found here:

  2. Use the Google Rich Snippet test tool to test your structure:

  3. It is also worth noting that the LRMI (Learning Resource Metadata Initiative) has been working with in creating a more robust set of property (itemprop) terms that have been accepted into the standard. Some of these terms may be useful in determining what might best describe a data set or collection. Here is a link to this new specification:

Something went wrong with that request. Please try again.