themarshallproject / hall-of-justice

Working with criminal justice data.
http://hallofjustice.sunlightfoundation.com/
BSD 3-Clause "New" or "Revised" License
14 stars 7 forks source link

Test PostgreSQL optimization of CSV generator #21

Closed dcloud closed 9 years ago

dcloud commented 9 years ago

See also #20.

Some things that would need addressed:

  1. translation of category ids to names
  2. state abbrs to full names (or not?)
  3. sensible translation of array fields to lists
  4. on-the-fly CSV generation for searches.

It would be easier to do the first 3 via Django.

Search: you'd want to make the search result queryset available to the next function which would generate the CSV.

dcloud commented 9 years ago

Streaming dl works fine for the near future.