Code

Changes between Version 1 and Version 2 of OpenData


Ignore:
Timestamp:
09/06/11 11:33:30 (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}}}