Love at first query

exploring SQL with DuckDB

Transcript

5. DouEnergy
7. SQLite for analytics
10. We all love Postgres
11. S3, malloc for the Internet
12. Building and operating a pretty big storage system called S3
13. We all love AWS S3
15. How many of you can set up a Postgres on your laptop to analyze a CSV(JSON, Parquet) on AWS S3?
16. And...
17. In less 3 minutes
18. Or
19. DuckDB-wasm
20. just 3 seconds
21. SELECT * FROM 'https://r2duck2.douenergy.com/central-park-w eather.csv';
22. Demo 1
23. CREATE TABLE R2Weather AS FROM 'https://r2duck2.douenergy.com/central-park- weather.csv';
24. Annual average of maximum temperature ? (每一年的單日最高溫平均)
25. SELECT EXTRACT(YEAR FROM DATE) AS year, AVG(TMAX) as average_max_temp FROM R2weather GROUP BY year ORDER BY year;
26. Rolling average of the maximum temperature over the last 7 days for each date?(過去七日的最高溫平均)
27. 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;
28. Average maximum temperature？ precipitation(降雨量) 0.1 < precipitation < 0.2 0.4 < precipitation
29. 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;
43. Apache Arrow
44. Benchmark
45. Demo 2
46. 葛來分多 加10分
47. 葛來分多 再加10分
49. Two month ago 🔥
50. Duck Arts Defence 🦆🪄
51. Duck Arts Defence 🦆🪄
54. You may say I'm a SQLer But I'm not the only one. I hope someday you'll join us.
55. Thanks