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
230
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
600
What's Missing for Postgres Monitoring
lfittl
0
210
A Map For Monitoring PostgreSQL
lfittl
2
370
Monitoring Postgres at Scale
lfittl
1
390
Monitoring PostgreSQL at Scale
lfittl
4
230
Postgres Performance for App Developers
lfittl
2
260
GraphQL ❤ PostgreSQL -- P.S. aka BeatQL
lfittl
1
570
Hacking PostgreSQL to Gain SQL Parsing Superpowers
lfittl
1
540
PostgreSQL at a Web Startup
lfittl
3
570
Other Decks in Programming
See All in Programming
Amazon ECS とマイクロサービスから考えるシステム構成
hiyanger
2
490
2,500万ユーザーを支えるSREチームの6年間のスクラムのカイゼン
honmarkhunt
6
5.1k
Djangoアプリケーション 運用のリアル 〜問題発生から可視化、最適化への道〜 #pyconshizu
kashewnuts
1
230
Formの複雑さに立ち向かう
bmthd
1
720
Java Webフレームワークの現状 / java web framework at burikaigi
kishida
9
2.2k
チームリードになって変わったこと
isaka1022
0
190
法律の脱レガシーに学ぶフロントエンド刷新
oguemon
5
730
Open source software: how to live long and go far
gaelvaroquaux
0
620
Amazon Q Developer Proで効率化するAPI開発入門
seike460
PRO
0
110
Bedrock Agentsレスポンス解析によるAgentのOps
licux
2
720
『GO』アプリ バックエンドサーバのコスト削減
mot_techtalk
0
130
Kubernetes History Inspector(KHI)を触ってみた
bells17
0
200
Featured
See All Featured
Creating an realtime collaboration tool: Agile Flush - .NET Oxford
marcduiker
27
1.9k
Building Your Own Lightsaber
phodgson
104
6.2k
Faster Mobile Websites
deanohume
306
31k
GitHub's CSS Performance
jonrohan
1030
460k
Writing Fast Ruby
sferik
628
61k
Code Review Best Practice
trishagee
66
17k
GraphQLの誤解/rethinking-graphql
sonatard
68
10k
Site-Speed That Sticks
csswizardry
3
370
[RailsConf 2023] Rails as a piece of cake
palkan
53
5.2k
What's in a price? How to price your products and services
michaelherold
244
12k
Principles of Awesome APIs and How to Build Them.
keavy
126
17k
The Success of Rails: Ensuring Growth for the Next 100 Years
eileencodes
44
7k
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