4 ms·
jsquery is absolutely amazing technology. A few years ago I prototyped a user path analysis DB where we replaced a 25GB time series database of user events wit
by fmajid 5y ago
jsquery is absolutely amazing technology.
A few years ago I prototyped a user path analysis DB where we replaced a 25GB time series database of user events with one where each user has one row with a JSONB array representing their entire history, and querying it using jsquery with GIN indexes took milliseconds. Things like "find me all the users who added item X to their cart and then went on to purchase item Y instead".
- xkcd-sucks 5y agoIf you don't mind me asking, how large could each row get and was there a strict upper limit? In the past we've seen a massive performance cliff after a few individual rows get over some size (maybe 50Mb?)