3 ms·

Very exciting stuff happening in the PG world. One of the items I'm watching is support for foreign keys in arrays - https://commitfest.postgresql.org/17/1252/

by jarym 8y ago

Very exciting stuff happening in the PG world. One of the items I'm watching is support for foreign keys in arrays - https://commitfest.postgresql.org/17/1252/ https://commitfest.postgresql.org/17/1252/ Author is currently stuck and I hope someone with the right knowledge can help him out so he can continue the work.

danharaj 8y ago
Oh damn that'd be great. Similarly, foreign keys in json(b).
- mlevental 8y ago
  why? so that you can simulate nosql hacks in an rdbms...?
  - joevandyk 8y ago
    Sometimes joins (and left joins) can be much more expensive than if the foreign keys are in a single indexable column.