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
640
What's Missing for Postgres Monitoring
lfittl
0
230
A Map For Monitoring PostgreSQL
lfittl
2
380
Monitoring Postgres at Scale
lfittl
1
420
Monitoring PostgreSQL at Scale
lfittl
4
250
Postgres Performance for App Developers
lfittl
2
290
GraphQL ❤ PostgreSQL -- P.S. aka BeatQL
lfittl
1
590
Hacking PostgreSQL to Gain SQL Parsing Superpowers
lfittl
1
570
PostgreSQL at a Web Startup
lfittl
3
590
Other Decks in Programming
See All in Programming
PostgreSQLのRow Level SecurityをPHPのORMで扱う Eloquent vs Doctrine #phpcon #track2
77web
2
510
チームで開発し事業を加速するための"良い"設計の考え方 @ サポーターズCoLab 2025-07-08
agatan
1
360
ISUCON研修おかわり会 講義スライド
arfes0e2b3c
1
440
PHPで始める振る舞い駆動開発(Behaviour-Driven Development)
ohmori_yusuke
2
360
設計やレビューに悩んでいるPHPerに贈る、クリーンなオブジェクト設計の指針たち
panda_program
6
2k
PicoRuby on Rails
makicamel
2
130
Rubyでやりたい駆動開発 / Ruby driven development
chobishiba
1
670
Quand Symfony, ApiPlatform, OpenAI et LangChain s'allient pour exploiter vos PDF : de la théorie à la production…
ahmedbhs123
0
180
Claude Code + Container Use と Cursor で作る ローカル並列開発環境のススメ / ccc local dev
kaelaela
7
3.6k
『自分のデータだけ見せたい!』を叶える──Laravel × Casbin で複雑権限をスッキリ解きほぐす 25 分
akitotsukahara
2
630
Azure AI Foundryではじめてのマルチエージェントワークフロー
seosoft
0
160
コードの90%をAIが書く世界で何が待っているのか / What awaits us in a world where 90% of the code is written by AI
rkaga
52
33k
Featured
See All Featured
Six Lessons from altMBA
skipperchong
28
3.9k
Distributed Sagas: A Protocol for Coordinating Microservices
caitiem20
331
22k
Fireside Chat
paigeccino
37
3.5k
Site-Speed That Sticks
csswizardry
10
690
Exploring the Power of Turbo Streams & Action Cable | RailsConf2023
kevinliebholz
34
5.9k
Responsive Adventures: Dirty Tricks From The Dark Corners of Front-End
smashingmag
251
21k
個人開発の失敗を避けるイケてる考え方 / tips for indie hackers
panda_program
107
19k
Performance Is Good for Brains [We Love Speed 2024]
tammyeverts
10
950
"I'm Feeling Lucky" - Building Great Search Experiences for Today's Users (#IAC19)
danielanewman
229
22k
Embracing the Ebb and Flow
colly
86
4.7k
Intergalactic Javascript Robots from Outer Space
tanoku
271
27k
Designing for humans not robots
tammielis
253
25k
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