Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Features
Speaker Deck
PRO
Sign in
Sign up for free
Search
Search
data.visualize!
Search
Sponsored
·
SiteGround - Reliable hosting with speed, security, and support you can count on.
→
Lukas Fittl
November 14, 2013
Programming
4
240
data.visualize!
Talk at vienna.rb on how we built
https://pganalyze.com/
and other visualization products.
Lukas Fittl
November 14, 2013
Tweet
Share
More Decks by Lukas Fittl
See All by Lukas Fittl
How to Scale Postgres - Automation, Tuning & Sharding
lfittl
0
680
What's Missing for Postgres Monitoring
lfittl
0
270
A Map For Monitoring PostgreSQL
lfittl
2
400
Monitoring Postgres at Scale
lfittl
1
460
Monitoring PostgreSQL at Scale
lfittl
4
280
Postgres Performance for App Developers
lfittl
2
320
GraphQL ❤ PostgreSQL -- P.S. aka BeatQL
lfittl
1
620
Hacking PostgreSQL to Gain SQL Parsing Superpowers
lfittl
1
610
PostgreSQL at a Web Startup
lfittl
3
610
Other Decks in Programming
See All in Programming
今更考える「単一責任原則」 / Thinking about the Single Responsibility Principle
tooppoo
3
1.4k
コーディングルールの鮮度を保ちたい / keep-fresh-go-internal-conventions
handlename
0
160
Claude Code、ちょっとした工夫で開発体験が変わる
tigertora7571
0
200
CSC307 Lecture 11
javiergs
PRO
0
590
nuget-server - あなたが必要だったNuGetサーバー
kekyo
PRO
0
170
Go1.26 go fixをプロダクトに適用して困ったこと
kurakura0916
0
330
AIとペアプロして処理時間を97%削減した話 #pyconshizu
kashewnuts
1
200
Raku Raku Notion 20260128
hareyakayuruyaka
0
430
2026/02/04 AIキャラクター人格の実装論 口 調の模倣から、コンテキスト制御による 『思想』と『行動』の創発へ
sr2mg4
0
680
DevinとClaude Code、SREの現場で使い倒してみた件
karia
1
920
日本だけで解禁されているアプリ起動の方法
ryunakayama
0
370
RAGでハマりがちな"Excelの罠"を、データの構造化で突破する
harumiweb
9
2.5k
Featured
See All Featured
Helping Users Find Their Own Way: Creating Modern Search Experiences
danielanewman
31
3.1k
Game over? The fight for quality and originality in the time of robots
wayneb77
1
130
Organizational Design Perspectives: An Ontology of Organizational Design Elements
kimpetersen
PRO
1
620
My Coaching Mixtape
mlcsv
0
63
Leadership Guide Workshop - DevTernity 2021
reverentgeek
1
230
Ten Tips & Tricks for a 🌱 transition
stuffmc
0
84
Fantastic passwords and where to find them - at NoRuKo
philnash
52
3.6k
New Earth Scene 8
popppiees
1
1.7k
The #1 spot is gone: here's how to win anyway
tamaranovitovic
2
980
Are puppies a ranking factor?
jonoalderson
1
3.1k
Prompt Engineering for Job Search
mfonobong
0
180
Accessibility Awareness
sabderemane
0
73
Transcript
@LukasFittl data.visualize! # FIXME: Needs paradigm shiſt.
Biz + UX + Dev @LukasFittl
Recently: pganalyze.com usercycle.com
Data Collection Data Storage Interface & Graphs
Data Collection Data Storage Interface & Graphs
Interface & Graphs
Interface & Graphs
Interface & Graphs !=
Oh, its a button/label/slider/link! Interface & Graphs
Forget fancy graphs, what are you displaying? Interface & Graphs
Interface & Graphs
Interface & Graphs
Interface & Graphs
Let The User Explore. Interface & Graphs
Interface & Graphs
Interface & Graphs
Interface & Graphs
Interface & Graphs d3.js —
Interface & Graphs d3.js
But, its complicated, kind of like vi(m). Interface & Graphs
Interface & Graphs Rickshaw
Interface & Graphs github.com/pganalyze/pgdatagraph
Data Storage Interface & Graphs Data Collection
Tracking Scripts Data Collection
Data Collection Tracking Cron Jobs
Its (usually) a JSON hash. Data Collection
Data Collection
Data Collection
Historic data? Different queue! Data Collection
Data Collection CreateEvent AssignCohorts PushToFrontend ApiController Data Storage Small &
Fast Tasks.
Data Collection Interface & Graphs Data Storage
Data Storage Step 1: Store the Raw Data
Data Storage Step 2: Add Caching Tables.
Data Storage query_snapshots query_snapshot_hourlies
Specialized Data Models Data Storage Event Signed Up Revenue Buckets
....
@LukasFittl Thank you! pganalyze.com