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

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
690
What's Missing for Postgres Monitoring
Avatar for Lukas Fittl lfittl
0
290
A Map For Monitoring PostgreSQL
Avatar for Lukas Fittl lfittl
2
410
Monitoring Postgres at Scale
Avatar for Lukas Fittl lfittl
1
500
Monitoring PostgreSQL at Scale
Avatar for Lukas Fittl lfittl
4
290
Postgres Performance for App Developers
Avatar for Lukas Fittl lfittl
2
340
GraphQL ❤ PostgreSQL -- P.S. aka BeatQL
Avatar for Lukas Fittl lfittl
1
650
Hacking PostgreSQL to Gain SQL Parsing Superpowers
Avatar for Lukas Fittl lfittl
1
640
PostgreSQL at a Web Startup
Avatar for Lukas Fittl lfittl
3
630

Other Decks in Programming

See All in Programming
関数型プログラミングのメリットって何だろう？
Avatar for わんこ(Wanko_IT) wanko_it
0
140
SREの積み重ねがAI駆動開発のガードレールになった ― 7つの実践/SRE Guardrails The 7
Avatar for TomoyaKitaura tomoyakitaura
7
1.9k
AI 輔助遺留系統現代化的經驗分享
Avatar for James Wang jame2408
1
1.2k
Vite+ Unified Toolchain for the Web
Avatar for Naoki Haba naokihaba
0
670
音楽のための関数型プログラミング言語mimiumにおける多段階計算の活用
Avatar for Tomoya Matsuura tomoyanonymous
1
260
Contextとはなにか
Avatar for chiroruxx chiroruxx
1
390
Observability in Practice：Grafana 與 Edge Device SRE 的那些事
Avatar for Blueswen blueswen
0
190
Developing with AI Agents — Codex, Claude Code & Cowork Practical Guide
Avatar for Daisuke Masuda x5gtrn
PRO
0
1.3k
Embedded SREと共に達成した会員管理システムのAWS移行 - SRE NEXT 2026 ランチスポンサーセッション
Avatar for ニフティ株式会社 niftycorp
PRO
0
670
AI がコードを書く時代における新卒エンジニアの仕事風景 (2026) / New Graduate Engineers in the Era of AI Coding (2026)
Avatar for sushichan044 sushichan044
0
200
1B+ /day規模のログを管理する技術
Avatar for Broadleaf Co., Ltd. broadleaf
0
130
はてなアカウント基盤 State of the Union
Avatar for cockscomb cockscomb
1
1.3k

Featured

See All Featured
Building a Scalable Design System with Sketch
Avatar for Laura Van Doore lauravandoore
463
34k
A Tale of Four Properties
Avatar for Chris Coyier chriscoyier
163
24k
Technical Leadership for Architectural Decision Making
Avatar for Kenny Baas-Schwegler baasie
3
430
Conquering PDFs: document understanding beyond plain text
Avatar for Ines Montani inesmontani
PRO
4
2.9k
Fantastic passwords and where to find them - at NoRuKo
Avatar for Phil Nash philnash
52
3.8k
A Guide to Academic Writing Using Generative AI - A Workshop
Avatar for Kenji Saito ks91
PRO
1
340
Breaking role norms: Why Content Design is so much more than writing copy - Taylor Woolridge
Avatar for UX Y'all uxyall
0
340
4 Signs Your Business is Dying
Avatar for Josh Pigford shpigford
187
22k
The AI Revolution Will Not Be Monopolized: How open-source beats economies of scale, even for LLMs
Avatar for Ines Montani inesmontani
PRO
3
3.5k
The Curse of the Amulet
Avatar for Matthew Lei leimatthew05
2
13k
The browser strikes back
Avatar for Jono Alderson jonoalderson
0
1.4k
SEO for Brand Visibility & Recognition
Avatar for Aleyda Solis aleyda
0
4.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