Upgrade to Pro — share decks privately, control downloads, hide ads and more …
Sign up for free

data.visualize!

Avatar for Lukas Fittl Lukas Fittl
November 14, 2013
Programming
250
4

 data.visualize!

Talk at vienna.rb on how we built https://pganalyze.com/ and other visualization products.

Avatar for Lukas Fittl

Lukas Fittl

November 14, 2013

More Decks by Lukas Fittl

See All by Lukas Fittl
How to Scale Postgres - Automation, Tuning & Sharding
Avatar for Lukas Fittl lfittl
0
710
What's Missing for Postgres Monitoring
Avatar for Lukas Fittl lfittl
0
320
A Map For Monitoring PostgreSQL
Avatar for Lukas Fittl lfittl
2
430
Monitoring Postgres at Scale
Avatar for Lukas Fittl lfittl
1
510
Monitoring PostgreSQL at Scale
Avatar for Lukas Fittl lfittl
4
310
Postgres Performance for App Developers
Avatar for Lukas Fittl lfittl
2
350
GraphQL ❤ PostgreSQL -- P.S. aka BeatQL
Avatar for Lukas Fittl lfittl
1
670
Hacking PostgreSQL to Gain SQL Parsing Superpowers
Avatar for Lukas Fittl lfittl
1
660
PostgreSQL at a Web Startup
Avatar for Lukas Fittl lfittl
3
660

Other Decks in Programming

See All in Programming
AIに “答え“を書かせるのを やめてみた
Avatar for akari ___akari11
0
130
AWS CDKのカスタムリソースでContinuum（旧Security Agent）を実装した話 | Implementing Continuum (formerly Security Agent) via AWS CDK Custom Resource
Avatar for アキキー | Akihisa Ikeda akihisaikeda
2
160
JAWS-UG 東京支部が始める、JAWS-UG支部コラボ / JAWS-UG lunchtime LT Collaboration
Avatar for y-ohgi y0hgi
0
290
Optunaを作ったときにやりたかったこと、その後 (2026/10/16, Optuna Meetup #3)
Avatar for Takuya Akiba iwiwi
2
1.2k
Verilogで学ぶCPU自作入門
Avatar for uyuki uyuki234
8
4.2k
Domain-Driven Transformation
Avatar for Henning Schwentner hschwentner
2
2.3k
FactoryBotをやめればRSpecは速くなるのか？
Avatar for nissyi yuta_onishi_97
0
980
Workers Cache を知る
Avatar for syumai syumai
0
370
R8 の設定見直しでアプリサイズ削減
Avatar for ANDPAD inc andpad
0
220
ソニーのクラウド共通基盤の変遷と AI時代の開発スタイルに合わせた進化 / The Journey of Sony’s Common Cloud Platform and Its Evolution for AI-Native Development
Avatar for KenjiYoneyama kenjiyoneyama
0
290
IBM Bob でAI駆動開発『QC-Playbook』
Avatar for 1kano ichirokano2
0
120
パスワード再設定メールのURLについて知っておこう
Avatar for uyuki uyuki234
0
170

Featured

See All Featured
The Power of CSS Pseudo Elements
Avatar for Geoffrey Crofte geoffreycrofte
82
6.6k
Keith and Marios Guide to Fast Websites
Avatar for Keith Pitt keithpitt
413
23k
Automating Front-end Workflow
Avatar for Addy Osmani addyosmani
1369
210k
Build your cross-platform service in a week with App Engine
Avatar for Jose L jlugia
234
19k
Mind Mapping
Avatar for Hélio Medeiros helmedeiros
1
400
VelocityConf: Rendering Performance Case Studies
Avatar for Addy Osmani addyosmani
331
25k
A Modern Web Designer's Workflow
Avatar for Chris Coyier chriscoyier
699
190k
Discover your Explorer Soul
Avatar for Emna emna__ayadi
2
1.3k
Site-Speed That Sticks
Avatar for Harry Roberts csswizardry
13
1.6k
The Limits of Empathy - UXLibs8
Avatar for Cassini Nazir cassininazir
2
730
Skip the Path - Find Your Career Trail
Avatar for Mark Kilby mkilby
1
260
RailsConf 2023
Avatar for Aaron Patterson tenderlove
30
1.6k

Transcript

  1. @LukasFittl data.visualize! # FIXME: Needs paradigm shiſt.

  2. Biz + UX + Dev @LukasFittl

  3. Recently: pganalyze.com usercycle.com

  4. Data Collection Data Storage Interface & Graphs

  5. Data Collection Data Storage Interface & Graphs

  6. Interface & Graphs

  7. Interface & Graphs

  8. Interface & Graphs !=

  9. Oh, its a button/label/slider/link! Interface & Graphs

  10. Forget fancy graphs, what are you displaying? Interface & Graphs

  11. Interface & Graphs

  12. Interface & Graphs

  13. Interface & Graphs

  14. Let The User Explore. Interface & Graphs

  15. Interface & Graphs

  16. Interface & Graphs

  17. Interface & Graphs

  18. Interface & Graphs d3.js —

  19. Interface & Graphs d3.js

  20. But, its complicated, kind of like vi(m). Interface & Graphs

  21. Interface & Graphs Rickshaw

  22. Interface & Graphs github.com/pganalyze/pgdatagraph

  23. Data Storage Interface & Graphs Data Collection

  24. Tracking Scripts Data Collection

  25. Data Collection Tracking Cron Jobs

  26. Its (usually) a JSON hash. Data Collection

  27. Data Collection

  28. Data Collection

  29. Historic data? Different queue! Data Collection

  30. Data Collection CreateEvent AssignCohorts PushToFrontend ApiController Data Storage Small &

    Fast Tasks.

  31. Data Collection Interface & Graphs Data Storage

  32. Data Storage Step 1: Store the Raw Data

  33. Data Storage Step 2: Add Caching Tables.

  34. Data Storage query_snapshots query_snapshot_hourlies

  35. Specialized Data Models Data Storage Event Signed Up Revenue Buckets

    ....

  36. @LukasFittl Thank you! pganalyze.com