This page is not created by, affiliated with, or supported by Slack Technologies, Inc.
2019-09-28
Channels
- # announcements (2)
- # beginners (19)
- # calva (8)
- # cider (5)
- # cljsrn (13)
- # clojure (35)
- # clojure-conj (3)
- # clojure-spain (1)
- # clojure-uk (2)
- # clojurescript (4)
- # clojutre (4)
- # cursive (13)
- # data-science (2)
- # datascript (1)
- # datomic (5)
- # duct (4)
- # fulcro (76)
- # funcool (5)
- # jobs (5)
- # off-topic (10)
- # remote-jobs (7)
- # rewrite-clj (8)
- # spacemacs (3)
- # sql (2)
- # xtdb (25)
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).
👍 4
✔️ 4