Fork me on GitHub
#sql
<
2019-09-28
>
sjharms21:09:28

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?

seancorfield21:09:56

@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).

👍 4
✔️ 4