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
640
What's Missing for Postgres Monitoring
Avatar for Lukas Fittl lfittl
0
230
A Map For Monitoring PostgreSQL
Avatar for Lukas Fittl lfittl
2
380
Monitoring Postgres at Scale
Avatar for Lukas Fittl lfittl
1
420
Monitoring PostgreSQL at Scale
Avatar for Lukas Fittl lfittl
4
260
Postgres Performance for App Developers
Avatar for Lukas Fittl lfittl
2
300
GraphQL ❤ PostgreSQL -- P.S. aka BeatQL
Avatar for Lukas Fittl lfittl
1
590
Hacking PostgreSQL to Gain SQL Parsing Superpowers
Avatar for Lukas Fittl lfittl
1
580
PostgreSQL at a Web Startup
Avatar for Lukas Fittl lfittl
3
590

Other Decks in Programming

See All in Programming
CEDEC2025 長期運営ゲームをあと10年続けるための0から始める自動テスト ~4000項目を50%自動化し、月1→毎日実行にした3年間~
Avatar for アカツキゲームス_Tech akatsukigames_tech
0
150
技術的負債で信頼性が限界だったWordPress運用をShifterで完全復活させた話
Avatar for adachi.ryo rvirus0817
1
2.1k
オホーツクでコミュニティを立ち上げた理由―地方出身プログラマの挑戦 / TechRAMEN 2025 Conference
Avatar for はる lemonade_37
2
490
画像コンペでのベースラインモデルの育て方
Avatar for tattaka tattaka
3
1.9k
Scale out your Claude Code ~⁨⁩自社専用Agentで10xする開発プロセス~
Avatar for Yuku Kotani yukukotani
9
2.6k
コーディングエージェント時代のNeovim
Avatar for KEY60228 key60228
1
100
兎に角、コードレビュー
Avatar for mitohato14 mitohato14
0
150
GUI操作LLMの最新動向: UI-TARSと関連論文紹介
Avatar for Kazuki Fujikawa kfujikawa
0
1k
20250808_AIAgent勉強会_ClaudeCodeデータ分析の実運用〜競馬を題材に回収率100%の先を目指すメソッドとは〜
Avatar for Kakeru Sato kkakeru
0
200
Dart 参戦！！静的型付き言語界の隠れた実力者
Avatar for Kuno Ayana kno3a87
0
210
TDD 実践ミニトーク
Avatar for Daisuke Garaike contour_gara
0
140
デザインシステムが必須の時代に
Avatar for Yosuke Furukawa yosuke_furukawa
PRO
2
110

Featured

See All Featured
No one is an island. Learnings from fostering a developers community.
Avatar for Antonio thoeni
21
3.4k
ReactJS: Keep Simple. Everything can be a component!
Avatar for Pedro Nauck pedronauck
667
120k
Done Done
Avatar for chrislema chrislema
185
16k
Producing Creativity
Avatar for Steve Smith orderedlist
PRO
347
40k
Why Our Code Smells
Avatar for Brandon Keepers bkeepers
PRO
338
57k
Git: the NoSQL Database
Avatar for Brandon Keepers bkeepers
PRO
431
65k
Building an army of robots
Avatar for Kyle Neath kneath
306
46k
Build your cross-platform service in a week with App Engine
Avatar for Jose L jlugia
231
18k
BBQ
Avatar for Matthew Crist matthewcrist
89
9.8k
Balancing Empowerment & Direction
Avatar for Lara Hogan lara
2
590
Exploring the Power of Turbo Streams & Action Cable | RailsConf2023
Avatar for Kevin Liebholz kevinliebholz
34
6k
Writing Fast Ruby
Avatar for Erik Berlin sferik
628
62k

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