Query Trello data with Postgres (JSON)
Recently, I was working on a project to automatically create Trello-cards via their API. To do that, I needed some id-values from the Trello-board which are not shown in the user-interface. But where does one get these values?
Glad you asked. Every Trello-board can be [exported to JSON][trello_export], and the values I was looking for are available in this export. However, JSON gives you the data in one big piece of text. Wouldn't it be handier to have it available as tabular data in a database?
So I created [this git-repository][git_repo] to do just that (you will need the [Postgres][postgresql]-database for this).
The table in which the JSON is stored, is modelled after an [idea of Rob Conery][conery] which basically is: store the JSON in a column, along with another column that uniquely identifies the document. This unique value is also available within the JSON itself.