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
490
What's Missing for Postgres Monitoring
lfittl
0
160
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
220
GraphQL ❤ PostgreSQL -- P.S. aka BeatQL
lfittl
1
510
Hacking PostgreSQL to Gain SQL Parsing Superpowers
lfittl
1
420
PostgreSQL at a Web Startup
lfittl
3
550
Other Decks in Programming
See All in Programming
Micro Frontends for Java Microservices - Devnexus 2024
mraible
PRO
0
490
Prepare for Jakarta EE 11 - Performance and Developer Productivity
ivargrimstad
0
820
dbtのドメイン分割による データ基盤の改善とDigdagとの連携
sakama
0
350
検証も兼ねて個人開発でHonoとかと向き合った話
hanetsuki
1
1.1k
Kotlin Multiplatform at Stable and Beyond (Android Makers 2024)
zsmb
0
290
『Railsオワコン』と言われる時代に、なぜブルーモ証券はRailsを選ぶのか
free_world21
0
250
Site Reliability Engineering for GMO
pyama86
8
1k
OpenAPIを中心に考えるAPI開発入門 / Introduction to API Development with a Focus on OpenAPI
seike460
PRO
2
170
Goのmultiple errorsについて (2024年4月版)
syumai
4
920
Scalable Customer Journey Orchestration (CJO)
lewuathe
0
340
Node.js v22 で変わること
yosuke_furukawa
PRO
9
3.5k
Ruby GitHub Packages
bkuhlmann
0
630
Featured
See All Featured
Statistics for Hackers
jakevdp
789
220k
Creating an realtime collaboration tool: Agile Flush - .NET Oxford
marcduiker
14
1.5k
In The Pink: A Labor of Love
frogandcode
138
21k
GraphQLの誤解/rethinking-graphql
sonatard
50
9.2k
We Have a Design System, Now What?
morganepeng
43
6.8k
Why Our Code Smells
bkeepers
PRO
331
56k
Designing Dashboards & Data Visualisations in Web Apps
destraynor
226
51k
The Success of Rails: Ensuring Growth for the Next 100 Years
eileencodes
30
6k
Intergalactic Javascript Robots from Outer Space
tanoku
266
26k
Bash Introduction
62gerente
604
210k
Web Components: a chance to create the future
zenorocha
305
41k
For a Future-Friendly Web
brad_frost
172
9k
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