-
activerecord-summarize
Transparently combine many reporting queries (on the same tables) into one fast query—even when queries have different groups or scopes.
-
InfluxDB
Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
"summarize-like": I came up with early versions of the technique—surely not for the first time in the world, but new for me—several years ago for the sake of the Track1099 dashboard. But it was pages of hard-to-reason-about code, and it didn't occur to me that the techniques could fruitfully be generalized until last year (see summarize's predecessor, multi_count here), and it was in the last month or so that I worked out the more powerful and readable and less footgun-infested API of summarize—and its correspondingly enhanced implementation.
Related posts
-
BasedUUID: URL-friendly, Base32-encoded UUIDs for Rails models
-
Building a dashboard in our portal that will be making heavy-ish queries to supply data to various bars/charts - would elasticsearch suffice to maximize query efficiency, or is there another best practice.
-
activerecord-summarize, a gem that parallelizes related .count/.sum queries by automatically building a single query to answer all of them at once
-
Wipe_out: Library for removing and clearing data in Rails AR models
-
BasedUUID: URL-friendly, Base32-encoded UUIDs for Rails models