3 ms·
More from a document database rather than an OLTP standpoint, but working with JSON data in Postgres I'd really like to see: * Exclusion Constraints support fo
by laurencerowe 5y ago
More from a document database rather than an OLTP standpoint, but working with JSON data in Postgres I'd really like to see:
* Exclusion Constraints support for GIN indexes (which supports Arrays and JSONB.) This would allow unique keys on array elements without having to use triggers to put the individual array elements in another table.
* Array element foreign keys, which I think is a subset of the Inclusion Constraints proposal (which would additionally allow constraints into ranges.)
* A faster procedural language. While plv8 is an improvement over plpgsql, it still seems substantially slower than running the equivalent in a separate NodeJS process. (Possibly just build issues for me.)