~/talk

BI Tooling with Rails

Talkat GoRuCo 2014 · on Saturday, 2014-06-21· [ruby-on-rails, databases]
links:none on file
slides:none on file

A small Rails app called bi is open sourced at paperless post/bi and it replaces a thousand-plus nightly cron queries by letting non‑technical staff run parameterized reports and download CSVs on demand. It uses ActiveRecord to connect to multiple datasources (replica DBs, Graphite, Mixpanel, Elasticsearch) and relies on ERB SQL templates so one developer writes a query once and everyone can change dates or groupings. KPIs persist daily values and percent changes; initial release ships without auth.

AI-written summary · about

  1. 0:00Start
  2. 0:55OUR HODGEPODGE
  3. 2:58Optional Inputs
  4. 4:21QUESTIONS
~/search
type to search 6,249 conferences, 138,987 speakers and 185,172 talks
~/help
cmdctrl k
search every conference, speaker and series
/
focus the filter search
h
home
c
conferences
s
speakers
e
series
t
light / dark — the status bar button does the same
?
this help
esc
close this, then clear every filter — or just the search, while you are typing in it

Ignored while you are typing. Pages without a filter rail have no search to focus.