Changes between Version 1 and Version 2 of OpenData


Ignore:
Timestamp:
09/06/2011 01:33:30 PM (3 years ago)
Author:
jacob
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • OpenData

    v1 v2  
    11{{{
    22#!rst
    3 ====================
    4 Django's data portal
    5 ====================
     3========================================
     4Django's contribution data
     5========================================
    66
    77Inspired by David Eaves, here's some information on accessing Django's
     
    2121There's two ways to access the data: `Trac's RPC interface`_ and the `daily
    2222data dumps`_.
     23
     24Daily data dumps
     25----------------
     26
     27These are direct data dumps of the Trac database, collected nightly, in various
     28formats. They're sanitized to remove some tables with senstive info (session
     29data, etc.) but are otherwise complete.
     30
     31Dumps are currently available in the following formats:
     32
     33    * CSV_ (tar'd & bzipped directory; one CSV file per table; ~35MB).
     34
     35.. _csv: https://www.djangoproject.com/m/data/django-trac-csv.tar.bz2
     36
     37The database schema is documented at
     38http://trac.edgewall.org/wiki/TracDev/DatabaseSchema. The most interesting
     39tables are probabably the ``ticket`` and ``ticket_change`` tables.
     40``ticket_change``, in particular, contains each change ever made to a ticket
     41and so probably has some of the most itnersting data available.
    2342
    2443Trac's RPC interface
     
    6281.. _xmlrpclib: http://docs.python.org/library/xmlrpclib.html
    6382
    64 Daily data dumps
    65 ----------------
    66 
    67 These are direct data dumps of the Trac database, collected nightly, in various
    68 formats. They're sanitized to remove some tables with senstive info (session
    69 data, etc.) but are otherwise complete.
    70 
    71 Dumps are currently available in the following formats:
    72 
    73     * CSV_ (tar'd & bzipped directory; one CSV file per table; ~35MB).
    74 
    75 .. _csv: https://www.djangoproject.com/m/data/django-trac-csv.tar.bz2
    76 
    77 The database schema is documented at
    78 http://trac.edgewall.org/wiki/TracDev/DatabaseSchema. The most interesting
    79 tables are probabably the ``ticket`` and ``ticket_change`` tables.
    80 ``ticket_change``, in particular, contains each change ever made to a ticket
    81 and so probably has some of the most itnersting data available.
    82 
    8383Mashups
    8484=======
     
    9393==========
    9494
    95 If you've got questions, please contact JKM (``jacob -at- jacobian.org``).
     95If you've got questions, please contact Jacob Kaplan-Moss (``jacob -at- jacobian.org``).
    9696
    9797}}}
Back to Top