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

data.visualize!

Sponsored · Your Podcast. Everywhere. Effortlessly. Share. Educate. Inspire. Entertain. You do you. We'll handle the rest. →
Avatar for Lukas Fittl Lukas Fittl
November 14, 2013
Programming
240
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
280
A Map For Monitoring PostgreSQL
Avatar for Lukas Fittl lfittl
2
410
Monitoring Postgres at Scale
Avatar for Lukas Fittl lfittl
1
490
Monitoring PostgreSQL at Scale
Avatar for Lukas Fittl lfittl
4
280
Postgres Performance for App Developers
Avatar for Lukas Fittl lfittl
2
330
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
630
PostgreSQL at a Web Startup
Avatar for Lukas Fittl lfittl
3
620

Other Decks in Programming

See All in Programming
Java × distroless で 軽量なコンテナイメージを / Java on Distroless
Avatar for Daisuke Garaike contour_gara
0
410
Transactional Change Stream Processing With Debezium and Apache Flink
Avatar for Gunnar Morling gunnarmorling
1
140
Claspは野良GASの夢をみるか
Avatar for てらうちたかし takter00
0
140
AI 時代のソフトウェア設計の学び方
Avatar for 増田 亨 masuda220
PRO
28
11k
Oxlintはいかにしてtsgolintのlint ruleを呼び出しているのか
Avatar for syumai syumai
2
1k
1人1案件のプロダクトエンジニア時代に、"プロセス監督"としてチャレンジしたこと
Avatar for のんちゃん non0113
0
350
Talking to terminals (and how they talk back) (KotlinConf 2026)
Avatar for Jake Wharton jakewharton
PRO
1
160
AIエージェントと協働するCLI開発 — BunとOpenClawで学んだこと
Avatar for よしこ yoshikouki
1
220
自動レビューエンジンの実装と運用 ~レビューのない世界へ~
Avatar for Kanato kurukuru1999
2
290
初めてのRubyKaigiはこう見えた
Avatar for asano jellyfish700
0
340
Composerを使ったサプライチェーン攻撃の様子を眺めてみる #phpstudy
Avatar for hideki kinjyo o0h
PRO
2
190
Lemonade + Foundry Toolkit でお手軽アプリ開発
Avatar for 瀬尾佳隆 seosoft
1
220

Featured

See All Featured
Google's AI Overviews - The New Search
Avatar for Barry Adams badams
0
1k
[RailsConf 2023 Opening Keynote] The Magic of Rails
Avatar for Eileen M. Uchitelle eileencodes
31
10k
Six Lessons from altMBA
Avatar for Skipper Chong Warson skipperchong
29
4.3k
Applied NLP in the Age of Generative AI
Avatar for Ines Montani inesmontani
PRO
4
2.3k
The Hidden Cost of Media on the Web [PixelPalooza 2025]
Avatar for Tammy Everts tammyeverts
2
310
WENDY [Excerpt]
Avatar for Tessa Abrams tessaabrams
11
38k
Test your architecture with Archunit
Avatar for Yoan thirion
1
2.3k
Dealing with People You Can't Stand - Big Design 2015
Avatar for Cassini Nazir cassininazir
367
27k
The Myth of the Modular Monolith - Day 2 Keynote - Rails World 2024
Avatar for Eileen M. Uchitelle eileencodes
28
3.5k
How to audit for AI Accessibility on your Front & Back End
Avatar for davetheseo davetheseo
0
390
How To Speak Unicorn (iThemes Webinar)
Avatar for Michelle Schulp Hunt marktimemedia
1
470
RailsConf 2023
Avatar for Aaron Patterson tenderlove
30
1.5k

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