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
Love at first query
Search
DouEnergy
August 02, 2023
Programming
1
160
Love at first query
exploring SQL with DuckDB
DouEnergy
August 02, 2023
Tweet
Share
More Decks by DouEnergy
See All by DouEnergy
The Last Gedi
douenergy
0
39
Other Decks in Programming
See All in Programming
o1モデルのプロンプトエンジニアリングって?
ktc_wada
0
270
Increased Performance and Developer Productivity with Jakarta EE 11
ivargrimstad
0
380
Pythonで改めて考える「クラス(class)」の使いどころ
os1ma
2
560
Architecture Decision Record (ADR)
nearme_tech
PRO
1
690
GoのIteratorに詳しくなってしまう
inatonix
1
200
XStateでReactに秩序を与えたい
gizm000
0
730
Method Swizzlingを行うライブラリにおけるマルチモジュール設計
yoshikma
0
120
Ebitengineの1vs1ゲーム WebRTCの活用
ponyo877
0
380
watsonx.ai Dojo #2 生成AIを使ったアプリ開発入門編
oniak3ibm
PRO
0
190
Modern Angular with the NGRX Signal Store New Rules for Your Architecture @BASTA! 2024 in Mainz
manfredsteyer
PRO
0
150
LangChainの現在とv0.3にむけて
os1ma
4
920
『ドメイン駆動設計をはじめよう』中核の業務領域
masuda220
PRO
5
1k
Featured
See All Featured
The Art of Delivering Value - GDevCon NA Keynote
reverentgeek
1
54
Rebuilding a faster, lazier Slack
samanthasiow
78
8.6k
Fontdeck: Realign not Redesign
paulrobertlloyd
80
5.1k
VelocityConf: Rendering Performance Case Studies
addyosmani
322
23k
Java REST API Framework Comparison - PWX 2021
mraible
PRO
27
7.4k
Gamification - CAS2011
davidbonilla
79
5k
Pencils Down: Stop Designing & Start Developing
hursman
119
11k
Writing Fast Ruby
sferik
623
60k
JavaScript: Past, Present, and Future - NDC Porto 2020
reverentgeek
45
4.8k
Building a Scalable Design System with Sketch
lauravandoore
459
32k
Code Review Best Practice
trishagee
62
16k
Docker and Python
trallard
39
3k
Transcript
None
None
None
None
DouEnergy
None
SQLite for analytics
None
None
We all love Postgres
S3, malloc for the Internet
Building and operating a pretty big storage system called S3
We all love AWS S3
None
How many of you can set up a Postgres on
your laptop to analyze a CSV(JSON, Parquet) on AWS S3?
And...
In less 3 minutes
Or
DuckDB-wasm
just 3 seconds
SELECT * FROM 'https://r2duck2.douenergy.com/central-park-w eather.csv';
Demo 1
CREATE TABLE R2Weather AS FROM 'https://r2duck2.douenergy.com/central-park- weather.csv';
Annual average of maximum temperature ? (每一年的單日最高溫平均)
SELECT EXTRACT(YEAR FROM DATE) AS year, AVG(TMAX) as average_max_temp FROM
R2weather GROUP BY year ORDER BY year;
Rolling average of the maximum temperature over the last 7
days for each date?(過去七日的最高溫平均)
SELECT DATE, TMAX, AVG(TMAX) OVER sevenday AS rolling_7_day_avg FROM R2weather
WINDOW sevenday AS(ORDER BY DATE ROWS BETWEEN 6 PRECEDING AND CURRENT ROW) LIMIT 20;
Average maximum temperature? precipitation(降雨量) 0.1 < precipitation < 0.2 0.4
< precipitation
SELECT COUNT(*) FILTER (WHERE PRCP BETWEEN 0.1 AND 0.2) low_days,
AVG(TMAX) FILTER (WHERE PRCP BETWEEN 0.1 AND 0.2) low_prcp_temp, COUNT(*) FILTER (WHERE 0.4 < PRCP) high_days, AVG(TMAX) FILTER (WHERE 0.4 < PRCP) high_prcp_temp FROM R2Weather;
None
None
None
None
None
None
None
None
None
None
None
None
None
Apache Arrow
Benchmark
Demo 2
葛來分多 加10分
葛來分多 再加10分
None
Two month ago 🔥
Duck Arts Defence 🦆🪄
Duck Arts Defence 🦆🪄
None
None
You may say I'm a SQLer But I'm not the
only one. I hope someday you'll join us.
Thanks