PostgreSQL 地理資料應用 by 張友謙

Room IB101
Room IB201
Room IB202
Room IB301
Room IB302
Room IB304
Room IB305
Room IB306
Room IB401
Room IB408
Room IB501
Room IB502
Room IB503
Room E2-102

09:00
09:20
10:00
10:10
10:35
10:40
10:45
10:50
11:00
11:05
11:10
11:20
11:25
11:30
11:35
11:40
11:45
12:00
12:05
12:10
12:15
12:25
12:30
12:35
12:40
12:45
12:50
12:55
13:00
13:10
13:15
13:20
13:25
13:45
13:50
13:55
14:00
14:10
14:15
14:20
14:30
14:40
14:45
14:55
15:00
15:05
15:10
15:15
15:20
15:30
15:35
16:05
09:00 ~ 09:20 Main & Misc.
Day 2 - Opening & Highlights
IB101 20 mins
09:20 ~ 09:50 Main & Misc.
自己玩量子電腦程式
IB101 30 mins Mandarin Begineer
10:00 ~ 10:50 Main & Misc.
(TBC)
IB101 50 mins
10:00 ~ 10:10 Open Source Privacy
開源隱私社群軌介紹
IB201 10 mins
10:00 ~ 10:30 OSC (OSPN) Special Track
Like small call center system by AWS connect and lambda
IB202 30 mins English Begineer
10:00 ~ 10:30 Ruby
當 Rails 遇上 Docker，環境部署原來是這樣！？
IB301 30 mins Mandarin Begineer
10:00 ~ 10:40 PostgreSQL
小步快跑！快用 PostgreSQL 數位轉型
IB302 40 mins Mandarin Skilled
10:00 ~ 11:00 Other OSS Topics
Tutorial: 线下公益社区的开源化改造
IB304 60 mins Mandarin Begineer
10:00 ~ 11:00 BoF
BoF Room (Empty)
IB305 60 mins
10:00 ~ 10:45 BSDTW x Cat System Workshop
Software Update for Embedded Systems
IB306 45 mins Mandarin Begineer
10:00 ~ 10:30 Open Web Technologies
點對點通訊加密的實踐
IB401 30 mins Mandarin Skilled
10:00 ~ 16:00 HackRoom
HACKROOM
IB408 360 mins
10:00 ~ 10:50 Julia language
Julia pattern matching and data structure
IB501 50 mins Mandarin Skilled
10:00 ~ 10:40 Open Hardware
Raspberry Pi histories, tips and use cases
IB502 40 mins English Begineer
10:00 ~ 10:50 OpenStreetMap x Wikidata
從零開始的Wikidata編輯工作坊
IB503 50 mins Mandarin Begineer
10:00 ~ 10:30 Let’s read the source code
Where is the source code?
E2-102 30 mins Mandarin Begineer
10:10 ~ 10:40 Open Source Privacy
Data Privacy for all
IB201 30 mins English Begineer
10:35 ~ 11:05 OSC (OSPN) Special Track
Hacking the third SmartPhoneOS, Linux and *BSD on Mobile devices in 2019
IB202 30 mins English Advanced
10:40 ~ 11:20 Ruby
Building Rails with Trailblazer, The Good, Bad and Ugly.
IB301 40 mins Mandarin Begineer
10:40 ~ 11:10 Open Web Technologies
用 WebRTC 建立半分散式網路
IB401 30 mins Mandarin Skilled
10:40 ~ 11:10 Let’s read the source code
How to Debug Using GDB
E2-102 30 mins Mandarin Skilled
10:45 ~ 11:25 PostgreSQL
PostgreSQL Foreign Data Wrapper Introduction
IB302 40 mins Mandarin Skilled
10:45 ~ 11:25 Open Hardware
CutiePi 開放樹莓派平板
IB502 40 mins Mandarin Begineer
10:50 ~ 11:20 Open Source Privacy
加強 Android 隱私的工具和技巧
IB201 30 mins Mandarin Begineer
10:50 ~ 11:35 BSDTW x Cat System Workshop
When ONNC meets NVDLA - 當開源專案交會時互放的光亮
IB306 45 mins Mandarin Advanced
10:50 ~ 11:40 OpenStreetMap x Wikidata
Wikidata 資料輕鬆取用
IB503 50 mins Mandarin Begineer
11:00 ~ 11:50 Main & Misc.
國際開放原始碼專案經營 - 從失敗中學習
IB101 50 mins Mandarin
11:00 ~ 12:00 BoF
開源社 BoF - 企業在開源x商業x社群的實踐
IB305 60 mins Mandarin
11:00 ~ 12:10 Julia language
Julia 技術發展論壇：從 Julia 看資料科學與 AI
IB501 70 mins Mandarin Begineer
11:05 ~ 11:20 Other OSS Topics
Not-that-lightning Talk - 1
IB304 15 mins
11:10 ~ 11:40 OSC (OSPN) Special Track
TWtrends: a System to Visualize the Twitter Trends in a Particular Region
IB202 30 mins English Begineer
11:20 ~ 11:50 Open Web Technologies
前端開發的再次典範轉移 - 如何走出混亂並讓複雜變的可掌控
IB401 30 mins Mandarin Skilled
11:20 ~ 11:50 Let’s read the source code
探索 Swift 自動微分實作
E2-102 30 mins Mandarin Skilled
11:25 ~ 11:40 Other OSS Topics
Not-that-lightning Talk - 2
IB304 15 mins
11:30 ~ 12:00 Open Source Privacy
Edge AI with privacy-preserving computation to protect data privacy in personal data analysis
IB201 30 mins Mandarin Skilled
11:30 ~ 12:00 Ruby
Ruby 上 Redis 的四種寫法
IB301 30 mins Mandarin Skilled
11:30 ~ 12:10 PostgreSQL
The discussion between Knex.js and PostgreSQL
IB302 40 mins Mandarin Begineer
11:30 ~ 12:10 Open Hardware
OpenQPano開源360度顯示器
IB502 40 mins Mandarin Advanced
11:35 ~ 12:00 OpenStreetMap x Wikidata
Wikidata x OpenStreetMap 新手編輯工具箱
IB503 25 mins Mandarin Begineer
11:40 ~ 12:25 BSDTW x Cat System Workshop
Instruction Scheduling in LLVM
IB306 45 mins Mandarin Skilled
11:45 ~ 12:15 OSC (OSPN) Special Track
Free software and classic Chinese philosophy
IB202 30 mins English Begineer
11:45 ~ 12:00 Other OSS Topics
Not-that-lightning Talk - 3
IB304 15 mins
12:00 ~ 13:00 BoF
BoF Room (Empty)
IB305 60 mins
12:00 ~ 12:35 OpenStreetMap x Wikidata
大河小溪全民齊督工─WIKIDATA應用
IB503 35 mins Mandarin Skilled
12:00 ~ 12:30 Let’s read the source code
你所不知道的 Golang
E2-102 30 mins Mandarin Advanced
12:05 ~ 12:20 Other OSS Topics
Not-that-lightning Talk - 4
IB304 15 mins
12:10 ~ 12:40 Open Source Privacy
Maskbook —— 社交網絡裡的隱私插件
IB201 30 mins Mandarin Begineer
12:15 ~ 12:55 PostgreSQL
A Tour of PostgreSQL Concurrency Control
IB302 40 mins Mandarin Skilled
12:15 ~ 12:55 Open Hardware
PiM25:從空污監測到到資料蒐集平台
IB502 40 mins Mandarin Begineer
12:25 ~ 12:40 Other OSS Topics
Not-that-lightning Talk - 5
IB304 15 mins
12:30 ~ 13:10 BSDTW x Cat System Workshop
FreeBSD BoF & Ports framework workshop
IB306 40 mins Mandarin Begineer
12:35 ~ 13:20 OpenStreetMap x Wikidata
自幹向量圖磚
IB503 45 mins Mandarin Skilled
12:40 ~ 13:10 Let’s read the source code
從 C++11 規格和 Template Meta-Programming 的角度欣賞 Boost 對 atomic 和 memory order 的支援
E2-102 30 mins Mandarin Skilled
12:45 ~ 12:50 Open Source Privacy
Lightning talk 1
IB201 5 mins
12:45 ~ 12:55 Other OSS Topics
Not-that-lightning Talk - 6
IB304 10 mins
12:50 ~ 12:55 Open Source Privacy
Lightning talk 2
IB201 5 mins
12:55 ~ 13:00 Open Source Privacy
Lightning talk 3
IB201 5 mins
13:00 ~ 13:50 Main & Misc.
加密/解密/雜湊看 PHP 版本的演進
IB101 50 mins Mandarin Skilled
13:00 ~ 13:20 Open Source Chatbot Development
給網站開發者用的 Chatbot MVC 框架
IB201 20 mins Mandarin Skilled
13:00 ~ 14:10 Ruby
從 Rack 開始的 Rails 探索
IB301 70 mins Mandarin Skilled
13:00 ~ 13:40 PostgreSQL
開源大數據引擎 - Greenplum
IB302 40 mins Mandarin Skilled
13:00 ~ 14:00 BoF
開源教育 BoF
IB305 60 mins Mandarin Begineer
13:00 ~ 13:30 Open Web Technologies
Armeria: The Only Thrift/gRPC/REST Microservice Framework You'll Need
IB401 30 mins English Begineer
13:00 ~ 13:40 Open Hardware
PSLab.io : Pocket Science Lab, a open hardware device
IB502 40 mins Mandarin Begineer
13:10 ~ 13:40 OSC (OSPN) Special Track
You Can Call Me Hardening: An Automatic Cyber Range System using Open Source Tools
IB202 30 mins English Advanced
13:10 ~ 14:00 Julia language
在21世紀做自動微分？你需要Zygote.jl！
IB501 50 mins Mandarin Skilled
13:15 ~ 13:55 BSDTW x Cat System Workshop
如何在 FreeBSD 家目錄下安裝軟體
IB306 40 mins Mandarin Begineer
13:20 ~ 13:55 OpenStreetMap x Wikidata
Geographic data for beginners: An Introduction to Overpass API/ Turbo
IB503 35 mins Mandarin Skilled
13:20 ~ 13:50 Let’s read the source code
Optimizations in Facebook's Folly
E2-102 30 mins Mandarin Skilled
13:25 ~ 13:45 Open Source Chatbot Development
愛・情緒・機器人
IB201 20 mins Mandarin Skilled
13:45 ~ 14:15 OSC (OSPN) Special Track
State of CJK issues of LibreOffice 2019
IB202 30 mins English Advanced
13:45 ~ 14:25 PostgreSQL
PostgreSQL 地理資料應用
IB302 40 mins Mandarin Advanced
13:45 ~ 14:25 Open Hardware
自己的鍵盤自己做 - Ergodox 教學
IB502 40 mins Mandarin Skilled
13:50 ~ 14:10 Open Source Chatbot Development
如何製作能和 LINE 結合的 IoT 裝置
IB201 20 mins Mandarin Begineer
13:55 ~ 14:20 OpenStreetMap x Wikidata
Making Contour Line from DTM / 登山等高線製作
IB503 25 mins Mandarin Begineer
14:00 ~ 15:00 BoF
BoF Room (Empty)
IB305 60 mins
14:00 ~ 14:40 BSDTW x Cat System Workshop
Monitor your Systems with Telegraf, InfluxDB, and Grafana
IB306 40 mins English Begineer
14:00 ~ 14:30 Let’s read the source code
老司機帶你讀 Redux 原始碼
E2-102 30 mins Mandarin Skilled
14:10 ~ 15:00 Other OSS Topics
系統軟體與作業系統課程的連結
IB304 50 mins Mandarin Begineer
14:10 ~ 15:00 Julia language
Julia 語言設計與 JIT 編譯器
IB501 50 mins Mandarin Advanced
14:15 ~ 14:35 Open Source Chatbot Development
聊天機器人與社群經營
IB201 20 mins Mandarin Skilled
14:20 ~ 14:50 OSC (OSPN) Special Track
FreeNAS vs XigmaNAS vs Another OSS NAS Appliance
IB202 30 mins Japanese Begineer
14:20 ~ 15:00 Ruby
野生的Meta Programming出現了
IB301 40 mins Mandarin Begineer
14:20 ~ 14:50 Open Web Technologies
Build (Web)VR with A-Frame
IB401 30 mins English Begineer
14:20 ~ 14:45 OpenStreetMap x Wikidata
OpenStreetMap 台灣圖資的歷史回顧
IB503 25 mins Mandarin Begineer
14:30 ~ 15:10 PostgreSQL
PostgreSQL View的運用與email的資料探勘
IB302 40 mins Taiwanese Begineer
14:30 ~ 15:10 Open Hardware
打造古早味的輝光管時鐘
IB502 40 mins Mandarin Skilled
14:40 ~ 15:00 Open Source Chatbot Development
serveo 讓你用 Docker 開發 chatbot 也能過的去
IB201 20 mins Mandarin Begineer
14:40 ~ 15:10 Let’s read the source code
從原始碼看 Go 語言的併發與排程實現
E2-102 30 mins Mandarin Skilled
14:45 ~ 15:25 BSDTW x Cat System Workshop
The ZFS filesystem
IB306 40 mins English Skilled
14:45 ~ 15:10 OpenStreetMap x Wikidata
維基醫學翻譯專案
IB503 25 mins Mandarin Begineer
14:55 ~ 15:25 OSC (OSPN) Special Track
Graph-Powered Translation Model
IB202 30 mins English Begineer
15:00 ~ 15:50 Main & Misc.
从 GRANK 到 GITRANK ，我们是这样针对开源项目建模的
IB101 50 mins Mandarin Begineer
15:00 ~ 16:00 BoF
BoF Room (Empty)
IB305 60 mins
15:00 ~ 16:00 Open Web Technologies
State of WebXR: What do you need to know today for building Web Mixed Reality Applications
IB401 60 mins English Begineer
15:05 ~ 15:25 Open Source Chatbot Development
Chatbot UX Design - 微股力&記帳雞產品設計分享
IB201 20 mins Mandarin Skilled
15:10 ~ 16:00 Ruby
網站開發框架的正確學習姿勢
IB301 50 mins Mandarin Begineer
15:10 ~ 16:00 Other OSS Topics
高校开源教育的探索与实践
IB304 50 mins Mandarin
15:10 ~ 16:00 Julia language
High-Level GPU Programming with Julia
IB501 50 mins English Skilled
15:10 ~ 15:35 OpenStreetMap x Wikidata
認識維基導遊
IB503 25 mins Mandarin Begineer
15:15 ~ 16:00 PostgreSQL
你媽知道你在用 PostgreSQL 看 PTT 嗎？
IB302 45 mins Mandarin Advanced
15:15 ~ 15:55 Open Hardware
自幹軟體收音機從硬體到軟體
IB502 40 mins Mandarin Skilled
15:20 ~ 15:50 Let’s read the source code
TFLite GPU Delegate and New NNAPI Delegate
E2-102 30 mins English Skilled
15:30 ~ 16:00 Open Source Chatbot Development
SUSI.ai: a Open Source ai chatbot(text or voice) in multi platform
IB201 30 mins Mandarin Begineer
15:30 ~ 16:00 OSC (OSPN) Special Track
Making world better: 從社群到社會，從台灣到世界
IB202 30 mins Mandarin Begineer
15:30 ~ 16:00 BSDTW x Cat System Workshop
Getting started with FreeBSD development
IB306 30 mins Mandarin Begineer
15:35 ~ 16:00 OpenStreetMap x Wikidata
運用維基共享資源於蝴蝶物種辨識系統之建構
IB503 25 mins Mandarin Begineer
16:05 ~ 16:40 Main & Misc.
Lightning Talks
IB101 35 mins