News for hackers. Stuff that matters.
Re:Making an Endpoint 50x Faster by GordonS on Saturday December 07, 2019 @05:58AM (#21729602)
TL;DR: a short article describing a normalised schema, with big performance gains when denormalising data.

Article is very application-specific, but is perhaps a reminder that denormalisation can be useful when working with relational databases.

Re:Making an Endpoint 50x Faster by mhd on Saturday December 07, 2019 @10:58AM (#21730898)
I wouldn't describe anything with a JSON kitchen sink field as "normalized".
Re:Making an Endpoint 50x Faster by setr on Saturday December 07, 2019 @04:30PM (#21732692)
If it was normalized, there wouldn't be a problem. You'd just index the subscriber list and postgres would handle the = or in queries properly.

But json to postgres 9.3 is no better than an abitrary string that stores a delimited list.

This is a denormalized workaround for a denormalized schema, with big performance gains.