This page is not created by, affiliated with, or supported by Slack Technologies, Inc.
2016-03-14
Channels
- # beginners (74)
- # boot (23)
- # braid-chat (7)
- # cider (5)
- # clara (3)
- # cljsjs (17)
- # cljsrn (1)
- # clojure (105)
- # clojure-austin (9)
- # clojure-new-zealand (34)
- # clojure-poland (2)
- # clojure-russia (177)
- # clojure-uk (41)
- # clojure-ukraine (2)
- # clojurescript (130)
- # component (1)
- # core-async (2)
- # core-matrix (6)
- # cursive (7)
- # data-science (103)
- # datomic (24)
- # emacs (15)
- # funcool (4)
- # hoplon (21)
- # immutant (151)
- # ldnclj (76)
- # melbourne (1)
- # off-topic (8)
- # om (152)
- # om-next (1)
- # onyx (26)
- # parinfer (38)
- # re-frame (13)
- # reagent (14)
- # spacemacs (1)
- # vim (92)
- # yada (1)
Another question on the SQL-theme now that I have decided to go with Postgres: I understand that I can replace one-to-many relations that in MySQL has to be done with one child table pointing to a parent table with Postgres arrays. Does anyone have thoughts on when either approach should be used?
@vikeri: You mean you want to store table data in an array that belongs to the "parent" table? I am just asking, never heard of this feature before
@sveri: Imagine you have a table containing users and then each user has some pets, do you put a list of those pets in an array in the user table or do you create a separate table called pets where each pet is linked back to a user through the column user_id
@vikeri: Hm, If I have a given set of pets I guess I would put them into a different table, especially if the pets have additional attributes like age, color, whatever. If I want to store only pet names, an array seems useful.
@vikeri: Also I would wonder how the performance characteristics are in this case. What if I search for every user having a relation to pet X. Can I put indices on the arrays?
While talking about databases, I just found about how reddit scaled there database: http://highscalability.com/blog/2010/5/17/7-lessons-learned-while-building-reddit-to-270-million-page.html Lesson 3. Sounds interesting, almost like a key-key-value store. Anyone ever tried that?