Upgrade to Pro — share decks privately, control downloads, hide ads and more …

data.visualize!

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

 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
Tweet

More Decks by Lukas Fittl

See All by Lukas Fittl
How to Scale Postgres - Automation, Tuning & Sharding
Avatar for Lukas Fittl lfittl
0
630
What's Missing for Postgres Monitoring
Avatar for Lukas Fittl lfittl
0
220
A Map For Monitoring PostgreSQL
Avatar for Lukas Fittl lfittl
2
370
Monitoring Postgres at Scale
Avatar for Lukas Fittl lfittl
1
400
Monitoring PostgreSQL at Scale
Avatar for Lukas Fittl lfittl
4
240
Postgres Performance for App Developers
Avatar for Lukas Fittl lfittl
2
280
GraphQL ❤ PostgreSQL -- P.S. aka BeatQL
Avatar for Lukas Fittl lfittl
1
580
Hacking PostgreSQL to Gain SQL Parsing Superpowers
Avatar for Lukas Fittl lfittl
1
560
PostgreSQL at a Web Startup
Avatar for Lukas Fittl lfittl
3
590

Other Decks in Programming

See All in Programming
Road to Ruby for A Linguistics Nerd
Avatar for Hayato Ishida hayat01sh1da
PRO
0
380
インプロセスQAにおいて大事にしていること / In-process QA Meetup
Avatar for MEDLEY, INC. medley
0
190
個人開発の学生アプリが企業譲渡されるまで
Avatar for akidon0000 akidon0000
2
1.2k
クラシルリワードにおける
iOSアプリ開発の取り組み
Avatar for fumito nakazawa funzin
1
210
OpenTelemetryで始めるベンダーフリーなobservability / Vendor-free observability starting with OpenTelemetry
Avatar for shiro seike seike460
0
130
Storybookの情報をMCPサーバー化する
Avatar for Shota Iwamatsu shota_tech
3
1.4k
プロフェッショナルとしての成長「問題の深掘り」が導く真のスキルアップ / issue-analysis-and-skill-up
Avatar for MinoDriven minodriven
8
2k
バイラテラルアップサンプリング
Avatar for Fadis fadis
3
630
Ruby で作る RISC-V CPU エミュレーター / RISC-V CPU emulator made with Ruby
Avatar for hachi (Hayao Kimura) hayaokimura
5
1.2k
Designing Your Organization's Test Pyramid ( #scrumniigata )
Avatar for teyamagu teyamagu
PRO
5
1.7k
“技術カンファレンスで何か変わる？” ──RubyKaigi後の自分とチームを振り返る
Avatar for shun ssagara00
0
160
リアーキテクチャの現場で向き合う 既存サービスの読み解きと設計判断
Avatar for ymiyamu ymiyamu
0
140

Featured

See All Featured
Gamification - CAS2011
Avatar for David Bonilla davidbonilla
81
5.3k
How STYLIGHT went responsive
Avatar for nonsquared nonsquared
100
5.5k
The Straight Up "How To Draw Better" Workshop
Avatar for Dennis Kardys denniskardys
233
140k
Six Lessons from altMBA
Avatar for Skipper Chong Warson skipperchong
28
3.8k
Site-Speed That Sticks
Avatar for Harry Roberts csswizardry
6
560
Java REST API Framework Comparison - PWX 2021
Avatar for Matt Raible mraible
31
8.6k
ReactJS: Keep Simple. Everything can be a component!
Avatar for Pedro Nauck pedronauck
667
120k
The Cult of Friendly URLs
Avatar for Andy Hume andyhume
78
6.4k
Measuring & Analyzing Core Web Vitals
Avatar for Philip Tellis bluesmoon
7
430
Become a Pro
Avatar for Speaker Deck speakerdeck
PRO
28
5.3k
RailsConf 2023
Avatar for Aaron Patterson tenderlove
30
1.1k
Responsive Adventures: Dirty Tricks From The Dark Corners of Front-End
Avatar for Vitaly Friedman smashingmag
251
21k

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