The Scoop

  • Home
  • Projects
  • About The Scoop
  • Fixing Journalism
  • Departments
    • Apple
    • Asides
    • Broadcast
    • Campaign Finance
    • Car Tools
    • Data
    • DIY
    • django
    • Fed Data
    • FOIA
    • General
    • IRE
    • Journalism
    • Local Data
    • Mapping
    • Miscellany
    • NonGov Data
    • Online
    • Paper Trail
    • Presentations
    • Public Records
    • Python
    • Rails
    • SLA
    • Social Network Analysis
    • Sports
    • State Data
    • Teaching
    • Work
    • XML
  • Subscribe via RSS

Car Tools

« Previous Entries

Caspio’s Lessons

June 29th, 2008  |  by Derek  |  published in Car Tools, Journalism

Been awhile since I wrote about Caspio, and since then they’ve only gained more media clients, which I suppose could be a lesson for me. But I think not. Rather, I hope what we’ll see in the months and years to come are the lessons that Matt Wynn offers from his experiences using Caspio. Here’s [...]

Revision Control for Journalists

April 22nd, 2008  |  by Derek  |  published in Car Tools, General

I was all set to write a tract about why CAR folks should use revision control, but Rachel Greenham has done a fine guide to Subversion for Writers. The same applies to files produced in the CAR process, like SQL snippets and programming scripts. Do yourself a favor and use a revision control system. You’ll [...]

Teaching SQLite

January 23rd, 2008  |  by Derek  |  published in Car Tools, Teaching

Tomorrow marks the beginning of another semester of teaching CAR at George Washington University. It should have been last Thursday, but weather prevented me from getting back from New York in time. One of the issues that people who teach CAR have to deal with is which database manager to use. Most opt for MS [...]

Trial By Caspio

December 7th, 2007  |  by Derek  |  published in Car Tools, DIY

Update: a comment by James Glover from Dec. 8 got caught in my spam filter and I just found it today. It’s posted below.
So I did it. I signed up for the Caspio trial, despite the fact that I think the Terms of Service don’t allow me to do much with it. Anyway, onward! Ok, [...]

Object-Oriented CAR

October 31st, 2007  |  by Derek  |  published in Car Tools

As Adrian points out below, this might be more properly titled Data Normalization and CAR.
Like a lot of CAR folks, I got my start working with rows in tables. For a given story or project, you might need one database table or 20, but basically you “designed” the database - if you had that option [...]

« Previous Entries

Recent Comments

  • Derek on Ramsey County Judicial Election
  • John Guzik on Ramsey County Judicial Election
  • John Zhu on On Bomb-Throwing
  • Benj. on Caspio’s Lessons
  • palewire / Permalinks, low-rent data viz and other stupid Caspio tricks. on Trial By Caspio

Recent Posts

  • The Birth of Quadruplets, or Understanding the Process
  • DjangoCon
  • Caspio’s Lessons
  • The Future of News Libraries
  • SLA Wrap-Up


©2008 The Scoop
Powered by WordPress using the Gridline Lite theme by Graph Paper Press.