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

data.visualize!

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.

Lukas Fittl

November 14, 2013
Tweet

More Decks by Lukas Fittl

See All by Lukas Fittl
How to Scale Postgres - Automation, Tuning & Sharding
lfittl
0
610
What's Missing for Postgres Monitoring
lfittl
0
210
A Map For Monitoring PostgreSQL
lfittl
2
370
Monitoring Postgres at Scale
lfittl
1
390
Monitoring PostgreSQL at Scale
lfittl
4
230
Postgres Performance for App Developers
lfittl
2
270
GraphQL ❤ PostgreSQL -- P.S. aka BeatQL
lfittl
1
570
Hacking PostgreSQL to Gain SQL Parsing Superpowers
lfittl
1
540
PostgreSQL at a Web Startup
lfittl
3
580

Other Decks in Programming

See All in Programming
Rails 1.0 のコードで学ぶ find_by* と method_missing の仕組み / Learn how find_by_* and method_missing work in Rails 1.0 code
maimux2x
1
190
パスキーのすべて ── 導入・UX設計・実装の紹介 / 20250213 パスキー開発者の集い
kuralab
3
890
生成AIで加速するテスト実装 - ロリポップ for Gamersの事例と 生成AIエディタの活用
kinosuke01
0
110
Bedrock Agentsレスポンス解析によるAgentのOps
licux
3
920
GoとPHPのインターフェイスの違い
shimabox
2
210
なぜイベント駆動が必要なのか - CQRS/ESで解く複雑系システムの課題 -
j5ik2o
14
4.6k
お前もAI鬼にならないか？👹Bolt & Cursor & Supabase & Vercelで人間をやめるぞ、ジョジョー！👺
taishiyade
7
4.2k
推しメソッドsource_locationのしくみを探る - はじめてRubyのコードを読んでみた
nobu09
2
250
負債になりにくいCSSをデザイナとつくるには？
fsubal
10
2.6k
Amazon Q Developer Proで効率化するAPI開発入門
seike460
PRO
0
120
How mixi2 Uses TiDB for SNS Scalability and Performance
kanmo
40
16k
Learning Kotlin with detekt
inouehi
1
110

Featured

See All Featured
Distributed Sagas: A Protocol for Coordinating Microservices
caitiem20
330
21k
How to Think Like a Performance Engineer
csswizardry
22
1.4k
Refactoring Trust on Your Teams (GOTO; Chicago 2020)
rmw
33
2.8k
Writing Fast Ruby
sferik
628
61k
How to Ace a Technical Interview
jacobian
276
23k
Testing 201, or: Great Expectations
jmmastey
42
7.2k
A Philosophy of Restraint
colly
203
16k
Building Flexible Design Systems
yeseniaperezcruz
328
38k
The MySQL Ecosystem @ GitHub 2015
samlambert
250
12k
Six Lessons from altMBA
skipperchong
27
3.6k
Speed Design
sergeychernyshev
27
810
A Modern Web Designer's Workflow
chriscoyier
693
190k

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