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
Lukas Fittl
November 14, 2013
Programming
4
220
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
500
What's Missing for Postgres Monitoring
lfittl
0
170
A Map For Monitoring PostgreSQL
lfittl
2
340
Monitoring Postgres at Scale
lfittl
1
330
Monitoring PostgreSQL at Scale
lfittl
4
220
Postgres Performance for App Developers
lfittl
2
230
GraphQL ❤ PostgreSQL -- P.S. aka BeatQL
lfittl
1
510
Hacking PostgreSQL to Gain SQL Parsing Superpowers
lfittl
1
430
PostgreSQL at a Web Startup
lfittl
3
550
Other Decks in Programming
See All in Programming
Docker_OSS_ホスティング入門
satokoki645
0
120
dbtのドメイン分割による データ基盤の改善とDigdagとの連携
sakama
0
490
デフォルトにして至高、RubyMineの大好きな所
ruzia
0
1.2k
Open AI APIを使う前に知っておきたいアカウントTier の話
akki_megane
0
110
Apache Hive 4 on Treasure Data
ryukobayashi
1
460
PHPコードの実行モデルを理解する / Understanding-the-PHP-Execution-Model
shin1x1
0
130
From Spring Boot 2 to Spring Boot 3 with Java 21 and Jakarta EE
ivargrimstad
0
980
CDKコントリビュートの最初の壁を越えよう! -簡単issueの見つけ方-
badmintoncryer
3
390
TypeScriptの型とパフォーマンス (TSKaigi 2024)
ypresto
12
2.8k
ts-morphを使ってコードリプレイスとASTへのハードルを下げる!
nyawach
2
220
一文字エイリアスのすすめ
fujimura
0
130
2024 コーディング研修
ckazu
1
550
Featured
See All Featured
Become a Pro
speakerdeck
PRO
13
4.6k
How GitHub Uses GitHub to Build GitHub
holman
468
290k
Building Adaptive Systems
keathley
32
1.9k
How to Ace a Technical Interview
jacobian
273
22k
"I'm Feeling Lucky" - Building Great Search Experiences for Today's Users (#IAC19)
danielanewman
221
21k
What's new in Ruby 2.0
geeforr
337
31k
Java REST API Framework Comparison - PWX 2021
mraible
PRO
18
7k
In The Pink: A Labor of Love
frogandcode
138
21k
Raft: Consensus for Rubyists
vanstee
133
6.3k
Fantastic passwords and where to find them - at NoRuKo
philnash
39
2.5k
Building Better People: How to give real-time feedback that sticks.
wjessup
356
18k
Visualization
eitanlees
137
14k
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