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
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
670
What's Missing for Postgres Monitoring
Avatar for Lukas Fittl lfittl
0
260
A Map For Monitoring PostgreSQL
Avatar for Lukas Fittl lfittl
2
390
Monitoring Postgres at Scale
Avatar for Lukas Fittl lfittl
1
460
Monitoring PostgreSQL at Scale
Avatar for Lukas Fittl lfittl
4
270
Postgres Performance for App Developers
Avatar for Lukas Fittl lfittl
2
310
GraphQL ❤ PostgreSQL -- P.S. aka BeatQL
Avatar for Lukas Fittl lfittl
1
610
Hacking PostgreSQL to Gain SQL Parsing Superpowers
Avatar for Lukas Fittl lfittl
1
600
PostgreSQL at a Web Startup
Avatar for Lukas Fittl lfittl
3
600

Other Decks in Programming

See All in Programming
CSC307 Lecture 04
Avatar for Javier Gonzalez-Sanchez javiergs
PRO
0
650
Fluid Templating in TYPO3 14
Avatar for Simon Praetorius s2b
0
110
ゆくKotlin くるRust
Avatar for TATSUNO Yasuhiro exoego
1
210
副作用をどこに置くか問題：オブジェクト指向で整理する設計判断ツリー
Avatar for Koya Masuda koxya
1
560
AIエージェントの設計で注意するべきポイント6選
Avatar for Har1101 har1101
7
3.3k
フロントエンド開発の勘所 -複数事業を経験して見えた判断軸の違い-
Avatar for Yoichiro Kubo heimusu
7
2.7k
Denoのセキュリティに関する仕組みの紹介 (toranoana.deno #23)
Avatar for uki00a uki00a
0
260
フルサイクルエンジニアリングをAI Agentで全自動化したい 〜構想と現在地〜
Avatar for Kaito Minatoya kamina_zzz
0
390
[KNOTS 2026登壇資料]AIで拡張‧交差する プロダクト開発のプロセス および携わるメンバーの役割
Avatar for hisatake hisatake
0
170
QAフローを最適化し、品質水準を満たしながらリリースまでの期間を最短化する #RSGT2026
Avatar for shibayu36 shibayu36
2
4.1k
今こそ知るべき耐量子計算機暗号(PQC)入門 / PQC: What You Need to Know Now
Avatar for mackey0225 mackey0225
3
350
なるべく楽してバックエンドに型をつけたい！(楽とは言ってない)
Avatar for HIBIKI CUBE hibiki_cube
0
130

Featured

See All Featured
The Anti-SEO Checklist Checklist. Pubcon Cyber Week
Avatar for Ryan Jones ryanjones
0
51
CoffeeScript is Beautiful & I Never Want to Write Plain JavaScript Again
Avatar for Sam Stephenson sstephenson
162
16k
Git: the NoSQL Database
Avatar for Brandon Keepers bkeepers
PRO
432
66k
The AI Revolution Will Not Be Monopolized: How open-source beats economies of scale, even for LLMs
Avatar for Ines Montani inesmontani
PRO
3
2.9k
Performance Is Good for Brains [We Love Speed 2024]
Avatar for Tammy Everts tammyeverts
12
1.4k
Lightning talk: Run Django tests with GitHub Actions
Avatar for Sarah Abderemane sabderemane
0
110
Agile Leadership in an Agile Organization
Avatar for Dr. Kim W Petersen kimpetersen
PRO
0
75
SEO Brein meetup: CTRL+C is not how to scale international SEO
Avatar for Linda Hogenes lindahogenes
0
2.3k
Unsuck your backbone
Avatar for Amy Palamountain ammeep
671
58k
Why Our Code Smells
Avatar for Brandon Keepers bkeepers
PRO
340
58k
Responsive Adventures: Dirty Tricks From The Dark Corners of Front-End
Avatar for Vitaly Friedman smashingmag
254
22k
YesSQL, Process and Tooling at Scale
Avatar for Rocio Delgado rocio
174
15k

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