DROP your DATABASE

What’s wrong with a database?

If by “database” you mean “place to store data,” then nothing! Places to store data are great.

  1. Find data for your story: CSVs, Excel files, map data and so on.
  2. Load that data an SQL database.
  3. Use that SQL database to inform and present your story.

Switch already

It’s scary to switch away from SQL. But it’s worth it.

  • we-the-tweeple: a single-file database in a special text format. “Database” was 313 lines, running both client-side and server-side. The database size was 3.5MB uncompressed. (JavaScript)
  • predictions-2016: a few Google Sheets TSVs and some TSVs output from R. “Database” was pretty complicated, but SQL couldn’t have made any task simpler. (JavaScript)
  • primaries-2016: some Google Sheets and Associated Press Elections API responses. “Database” was too complicated, because we were trying to make it look like SQL; we did better for the general election. (Ruby)
  • decision-2016: some Google Sheets and Associated Press Elections API responses. (JavaScript)

--

--

Journalist, ex software engineer

Love podcasts or audiobooks? Learn on the go with our new app.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Adam Hooper

Adam Hooper

Journalist, ex software engineer