Fork me on GitHub

I have maps I want to store in Postgres, what is the recommended way of doing so? Ie I am scraping content, so I don't always have the same fields etc, so does a json column make sense?


@sjharms If you have any fields that are common, always present, I would pull those out as separate columns in the DB but otherwise storing the maps as JSON "blobs" seems reasonable. We do it in a few situations (albeit with Percona/MySQL -- PostgreSQL has proper support for querying against JSON I believe).

👍 1
✔️ 1