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
570
What's Missing for Postgres Monitoring
lfittl
0
190
A Map For Monitoring PostgreSQL
lfittl
2
360
Monitoring Postgres at Scale
lfittl
1
370
Monitoring PostgreSQL at Scale
lfittl
4
230
Postgres Performance for App Developers
lfittl
2
240
GraphQL ❤ PostgreSQL -- P.S. aka BeatQL
lfittl
1
560
Hacking PostgreSQL to Gain SQL Parsing Superpowers
lfittl
1
510
PostgreSQL at a Web Startup
lfittl
3
560
Other Decks in Programming
See All in Programming
WebフロントエンドにおけるGraphQL(あるいはバックエンドのAPI)との向き合い方 / #241106_plk_frontend
izumin5210
4
1.4k
RubyLSPのマルチバイト文字対応
notfounds
0
120
アジャイルを支えるテストアーキテクチャ設計/Test Architecting for Agile
goyoki
9
3.3k
Compose 1.7のTextFieldはPOBox Plusで日本語変換できない
tomoya0x00
0
190
Pinia Colada が実現するスマートな非同期処理
naokihaba
4
220
3 Effective Rules for Using Signals in Angular
manfredsteyer
PRO
0
100
初めてDefinitelyTypedにPRを出した話
syumai
0
400
イベント駆動で成長して委員会
happymana
1
320
Remix on Hono on Cloudflare Workers
yusukebe
1
290
CSC509 Lecture 11
javiergs
PRO
0
180
距離関数を極める! / SESSIONS 2024
gam0022
0
280
cmp.Or に感動した
otakakot
2
140
Featured
See All Featured
Fight the Zombie Pattern Library - RWD Summit 2016
marcelosomers
232
17k
Why You Should Never Use an ORM
jnunemaker
PRO
54
9.1k
Being A Developer After 40
akosma
86
590k
Put a Button on it: Removing Barriers to Going Fast.
kastner
59
3.5k
Faster Mobile Websites
deanohume
305
30k
Side Projects
sachag
452
42k
Bash Introduction
62gerente
608
210k
Into the Great Unknown - MozCon
thekraken
32
1.5k
Typedesign – Prime Four
hannesfritz
40
2.4k
RailsConf & Balkan Ruby 2019: The Past, Present, and Future of Rails at GitHub
eileencodes
131
33k
[Rails World 2023 - Day 1 Closing Keynote] - The Magic of Rails
eileencodes
33
1.9k
A Modern Web Designer's Workflow
chriscoyier
693
190k
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