PostgreSQL 地理資料應用 by 張友謙 | COSCUP 2019 | Conference for Open Source Coders, Users, and Promoters

Room TR313
Room TR309
Room TR312
Room TR510
Room 310-1
Room 409-1
Room TR411
Room 412-1
Room 412-2
Room 409-2
Room TR511 & TR512
Room 413-1
Room 413-2
Room TR509
Room IB101
Room IB302

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:05
13:10
13:15
13:20
13:25
13:40
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:30
15:35
16:05
17:05
09:00 ~ 09:20 Main & Misc.
Day 2 - Opening & Highlights

COSCUP Staff
TR313 20 mins
09:20 ~ 09:50 Main & Misc.
自己玩量子電腦程式

Ping Yeh
TR313 30 mins Mandarin Beginner
10:00 ~ 10:50 Main & Misc.
懶惰鬼的函數式爬蟲ー以 Tezos 應用需求為例

Yun-Yan Chi
Chia-Chi Tsai
TR313 50 mins Mandarin Beginner
10:00 ~ 10:10 Open Source Privacy
開源隱私社群軌介紹

Pellaeon
TR309 10 mins
10:00 ~ 10:30 OSC (OSPN) Special Track
Like small call center system by AWS connect and lambda

Kaz.Inaba
TR312 30 mins English Beginner
10:00 ~ 10:30 Ruby
當 Rails 遇上 Docker，環境部署原來是這樣！？

詹昇
310-1 30 mins Mandarin Beginner
10:00 ~ 10:40 PostgreSQL
PostgreSQL Foreign Data Wrapper Introduction

枋志深
409-1 40 mins Mandarin Skilled
10:00 ~ 10:50 Other OSS Topics
高校开源教育的探索与实践

王伟
TR411 50 mins Mandarin
10:00 ~ 11:00 BoF
網域名稱、DNS 技術解析 BoF
412-1 60 mins
10:00 ~ 10:45 BSDTW x Cat System Workshop
Software Update for Embedded Systems

SZ Lin
412-2 45 mins Mandarin Beginner
10:00 ~ 10:30 Open Web Technologies
點對點通訊加密的實踐

YuTin
409-2 30 mins Mandarin Skilled
10:00 ~ 16:00 HackRoom
HACKROOM
TR511 & TR512 360 mins
10:00 ~ 10:50 Julia language
Julia pattern matching and data structure

杜岳華
413-1 50 mins Mandarin Skilled
10:00 ~ 10:40 Open Hardware
Raspberry Pi histories, tips and use cases

Masafumi Ohta
413-2 40 mins English Beginner
10:00 ~ 10:50 OpenStreetMap x Wikidata
從零開始的Wikidata編輯工作坊

王文岳
TR509 50 mins Mandarin Beginner
10:00 ~ 10:30 Let’s read the source code
Where is the source code?

何泰祥
TR510 30 mins Mandarin Beginner
10:10 ~ 10:40 Open Source Privacy
Data Privacy for all

Ankit Gadgil
TR309 30 mins English Beginner
10:35 ~ 11:05 OSC (OSPN) Special Track
Hacking the third SmartPhoneOS, Linux and *BSD on Mobile devices in 2019

Kenji Shimono
TR312 30 mins English Advanced
10:40 ~ 11:20 Ruby
Building Rails with Trailblazer, The Good, Bad and Ugly.

林文泉
310-1 40 mins Mandarin Beginner
10:40 ~ 11:10 Open Web Technologies
用 WebRTC 建立半分散式網路

邱冠喻
409-2 30 mins Mandarin Skilled
10:40 ~ 11:10 Let’s read the source code
How to Debug Using GDB

AIdrifter
TR510 30 mins Mandarin Skilled
10:45 ~ 11:25 PostgreSQL
Do You Select PostgreSQL or MySQL?

Sone Taketomo
409-1 40 mins English Skilled
10:45 ~ 11:25 Open Hardware
CutiePi 開放樹莓派平板

penk
413-2 40 mins Mandarin Beginner
10:50 ~ 11:20 Open Source Privacy
加強 Android 隱私的工具和技巧

Pellaeon
TR309 30 mins Mandarin Beginner
10:50 ~ 11:35 BSDTW x Cat System Workshop
The ZFS filesystem

Philip Paeps
412-2 45 mins English Skilled
10:50 ~ 11:35 OpenStreetMap x Wikidata
Wikidata 資料輕鬆取用

涂家銘
TR509 45 mins Mandarin Beginner
11:00 ~ 11:50 Main & Misc.
國際開放原始碼專案經營 - 從失敗中學習

PCMan
TR313 50 mins Mandarin
11:00 ~ 12:00 BoF
開源社 BoF - 企業在開源x商業x社群的實踐
412-1 60 mins Mandarin
11:00 ~ 12:10 Julia language
Julia 技術發展論壇：從 Julia 看資料科學與 AI

杜岳華
鄭景文
413-1 70 mins Mandarin Beginner
11:05 ~ 11:20 Other OSS Topics
Maskbook: Enforce the Natural Law of Privacy

Yisi Liu
TR411 15 mins Mandarin Skilled
11:10 ~ 11:40 OSC (OSPN) Special Track
TWtrends: a System to Visualize the Twitter Trends in a Particular Region

Jun Iio
TR312 30 mins English Beginner
11:20 ~ 11:50 Open Web Technologies
前端開發的再次典範轉移 - 如何走出混亂並讓複雜變的可掌控

呂維德
吳昱甫
409-2 30 mins Mandarin Skilled
11:20 ~ 11:50 Let’s read the source code
探索 Swift 自動微分實作

John Lin
TR510 30 mins Mandarin Skilled
11:25 ~ 11:40 Other OSS Topics
FreeBSD 原始碼導讀 -- 讓GOOGLE PageRank 教你讀懂FreeBSD

余宗達
TR411 15 mins Mandarin Skilled
11:30 ~ 12:00 Open Source Privacy
Edge AI with privacy-preserving computation to protect data privacy in personal data analysis

Bofu Chen
TR309 30 mins Mandarin Skilled
11:30 ~ 12:00 Ruby
Ruby 上 Redis 的四種寫法

丁盛豪
310-1 30 mins Mandarin Skilled
11:30 ~ 12:10 PostgreSQL
The discussion between Knex.js and PostgreSQL

張懷倫
409-1 40 mins Mandarin Beginner
11:30 ~ 12:10 Open Hardware
OpenQPano開源360度顯示器

Jack Hsu
413-2 40 mins Mandarin Advanced
11:35 ~ 12:00 OpenStreetMap x Wikidata
Wikidata x OpenStreetMap 新手編輯工具箱

Hong-I Hsu
TR509 25 mins Mandarin Beginner
11:40 ~ 12:25 BSDTW x Cat System Workshop
Instruction Scheduling in LLVM

Hsiangkai Wang
412-2 45 mins Mandarin Skilled
11:45 ~ 12:15 OSC (OSPN) Special Track
Free software and classic Chinese philosophy

Akira Urushibata
TR312 30 mins English Beginner
11:45 ~ 12:00 Other OSS Topics
Microservices In Golang

Lilith Peng
TR411 15 mins Mandarin Beginner
12:00 ~ 12:30 Main & Misc.
Naver, monitoring services with trillions of event with open source APM, Pinpoint

Sung Wook Kim
HyunGil Jeong
TR313 30 mins English Beginner
12:00 ~ 13:00 BoF
區鏈塊如何幫助打擊虛假訊息（假新聞） BoF
412-1 60 mins
12:00 ~ 12:35 OpenStreetMap x Wikidata
大河小溪全民齊督工─WIKIDATA應用

高任翔
TR509 35 mins Mandarin Skilled
12:00 ~ 12:30 Let’s read the source code
你所不知道的 Golang

李洵
TR510 30 mins Mandarin Advanced
12:05 ~ 12:20 Other OSS Topics
Journey to Virtual Display Driver in Kernel

Mamta Shukla
TR411 15 mins English Beginner
12:10 ~ 12:40 Open Source Privacy
Maskbook —— 社交網絡裡的隱私插件

MinakoKojima
TR309 30 mins Mandarin Beginner
12:15 ~ 12:55 PostgreSQL
A Tour of PostgreSQL Concurrency Control

黃鈞彥
409-1 40 mins Mandarin Skilled
12:15 ~ 12:55 Open Hardware
PiM25:從空污監測到到資料蒐集平台

sosorry
413-2 40 mins Mandarin Beginner
12:25 ~ 12:40 Other OSS Topics
Something you don't know about Golang context

郭學聰
TR411 15 mins Mandarin Skilled
12:30 ~ 13:10 BSDTW x Cat System Workshop
FreeBSD BoF & Ports framework workshop

Iblis Lin
412-2 40 mins Mandarin Beginner
12:35 ~ 13:20 OpenStreetMap x Wikidata
自幹向量圖磚

謝晉凡
TR509 45 mins Mandarin Skilled
12:40 ~ 13:10 Let’s read the source code
從 C++11 規格和 Template Meta-Programming 的角度欣賞 Boost 對 atomic 和 memory order 的支援

翁敏維
TR510 30 mins Mandarin Skilled
12:45 ~ 12:50 Open Source Privacy
Lightning talk 1
TR309 5 mins
12:45 ~ 13:00 Other OSS Topics
一个 PornHub 周边项目的诞生和成长

HUAN CHENG BAI
TR411 15 mins Mandarin Beginner
12:50 ~ 12:55 Open Source Privacy
Lightning talk 2
TR309 5 mins
12:55 ~ 13:00 Open Source Privacy
Lightning talk 3
TR309 5 mins
13:00 ~ 13:50 Main & Misc.
加密/解密/雜湊看 PHP 版本的演進

Peter
TR313 50 mins Mandarin Skilled
13:00 ~ 13:20 Open Source Chatbot Development
給網站開發者用的 Chatbot MVC 框架

Kamibot
TR309 20 mins Mandarin Skilled
13:00 ~ 14:10 Ruby
復活一個 Browser Game - Unlight 開源事件

蒼時弦也
310-1 70 mins Mandarin Skilled
13:00 ~ 13:40 PostgreSQL
開源大數據引擎 - Greenplum

陳進賢
409-1 40 mins Mandarin Skilled
13:00 ~ 14:00 BoF
開源教育 BoF
412-1 60 mins Mandarin Beginner
13:00 ~ 13:30 Open Web Technologies
Armeria: The Only Thrift/gRPC/REST Microservice Framework You'll Need

Trustin Heuiseung Lee
409-2 30 mins English Beginner
13:00 ~ 13:40 Open Hardware
PSLab.io : Pocket Science Lab, a open hardware device

Noah Chen
413-2 40 mins Mandarin Beginner
13:05 ~ 14:05 Other OSS Topics
Tutorial: 线下公益社区的开源化改造

石垚（水歌）
TR411 60 mins Mandarin Beginner
13:10 ~ 13:40 OSC (OSPN) Special Track
You Can Call Me Hardening: An Automatic Cyber Range System using Open Source Tools

Yoshinori Matsumoto
TR312 30 mins English Advanced
13:10 ~ 14:00 Julia language
在21世紀做自動微分？你需要Zygote.jl！

鄭景文
413-1 50 mins Mandarin Skilled
13:15 ~ 13:55 BSDTW x Cat System Workshop
如何在 FreeBSD 家目錄下安裝軟體

藍挺瑋
412-2 40 mins Mandarin Beginner
13:20 ~ 13:55 OpenStreetMap x Wikidata
Geographic data for beginners: An Introduction to Overpass API/ Turbo

Sean Young
TR509 35 mins Mandarin Skilled
13:20 ~ 13:50 Let’s read the source code
Optimizations in Facebook's Folly

Yun-Wei Lee
TR510 30 mins Mandarin Skilled
13:25 ~ 13:45 Open Source Chatbot Development
愛・情緒・機器人

Toby Liu
TR309 20 mins Mandarin Skilled
13:40 ~ 14:10 Open Web Technologies
實戰GraphQL

吳宜儒
409-2 30 mins Mandarin Skilled
13:45 ~ 14:15 OSC (OSPN) Special Track
State of CJK issues of LibreOffice 2019

Shinji Enoki
TR312 30 mins English Advanced
13:45 ~ 14:25 PostgreSQL
PostgreSQL 地理資料應用

張友謙
409-1 40 mins Mandarin Advanced
13:45 ~ 14:25 Open Hardware
自己的鍵盤自己做 - Ergodox 教學

HaWay
413-2 40 mins Mandarin Skilled
13:50 ~ 14:10 Open Source Chatbot Development
如何製作能和 LINE 結合的 IoT 裝置

沈涵羚
TR309 20 mins Mandarin Beginner
13:55 ~ 14:20 OpenStreetMap x Wikidata
Making Contour Line from DTM / 登山等高線製作

鍾木騰
TR509 25 mins Mandarin Beginner
14:00 ~ 14:50 Main & Misc.
TF-A, TBBR, open source bootloader for Raspberry Pi 3.

PaulLiu
TR313 50 mins Mandarin Advanced
14:00 ~ 15:00 BoF
開源 / DIY ad hoc / mesh network / 離線通訊技術討論 BoF
412-1 60 mins
14:00 ~ 14:40 BSDTW x Cat System Workshop
Monitor your Systems with Telegraf, InfluxDB, and Grafana

Benedict Reuschling
412-2 40 mins English Beginner
14:00 ~ 14:30 Let’s read the source code
老司機帶你讀 Redux 原始碼

林子暘
TR510 30 mins Mandarin Skilled
14:10 ~ 15:00 Other OSS Topics
系統軟體與作業系統課程的連結

羅習五
TR411 50 mins Mandarin Beginner
14:10 ~ 15:00 Julia language
Julia 語言設計與 JIT 編譯器

杜岳華
413-1 50 mins Mandarin Advanced
14:15 ~ 14:35 Open Source Chatbot Development
聊天機器人與社群經營

撒景賢
TR309 20 mins Mandarin Skilled
14:20 ~ 14:50 OSC (OSPN) Special Track
FreeNAS vs XigmaNAS vs Another OSS NAS Appliance

HARAOKA,Yoshiyuki
TR312 30 mins Japanese Beginner
14:20 ~ 15:00 Ruby
野生的Meta Programming出現了

John Lin
310-1 40 mins Mandarin Beginner
14:20 ~ 14:50 Open Web Technologies
Build (Web)VR with A-Frame

Robert "Bob" Reyes
409-2 30 mins English Beginner
14:20 ~ 14:45 OpenStreetMap x Wikidata
OpenStreetMap 台灣圖資的歷史回顧

尤孝庭
TR509 25 mins Mandarin Beginner
14:30 ~ 15:10 PostgreSQL
PostgreSQL View的運用與email的資料探勘

孫菖鴻
409-1 40 mins Mandarin Beginner
14:30 ~ 15:10 Open Hardware
打造古早味的輝光管時鐘

李祐棠
413-2 40 mins Mandarin Skilled
14:40 ~ 15:00 Open Source Chatbot Development
serveo 讓你用 Docker 開發 chatbot 也能過的去

戴均民
TR309 20 mins Mandarin Beginner
14:40 ~ 15:10 Let’s read the source code
TFLite GPU Delegate and New NNAPI Delegate

Koan-Sin Tan
TR510 30 mins English Skilled
14:45 ~ 15:25 BSDTW x Cat System Workshop
When ONNC meets NVDLA - 當開源專案交會時互放的光亮

蔡德育
412-2 40 mins Mandarin Advanced
14:45 ~ 15:10 OpenStreetMap x Wikidata
維基醫學翻譯專案

黃瑞霖
TR509 25 mins Mandarin Beginner
14:55 ~ 15:25 OSC (OSPN) Special Track
Graph-Powered Translation Model

Koji Annoura
TR312 30 mins English Beginner
15:00 ~ 15:50 Main & Misc.
从 GRANK 到 GITRANK ，我们是这样针对开源项目建模的

HUAN CHENG BAI
TR313 50 mins Mandarin Beginner
15:00 ~ 16:00 BoF
大監控時代 BoF
412-1 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

Rabimba Karanjai
409-2 60 mins English Beginner
15:05 ~ 15:25 Open Source Chatbot Development
Chatbot UX Design - 微股力&記帳雞產品設計分享

溫明輝
TR309 20 mins Mandarin Skilled
15:10 ~ 16:00 Ruby
網站開發框架的正確學習姿勢

高見龍
范聖佑
310-1 50 mins Mandarin Beginner
15:10 ~ 16:00 Julia language
High-Level GPU Programming with Julia

鄭景文
413-1 50 mins Mandarin Skilled
15:10 ~ 15:35 OpenStreetMap x Wikidata
認識維基導遊

許守一
TR509 25 mins Mandarin Beginner
15:15 ~ 16:00 PostgreSQL
你媽知道你在用 PostgreSQL 看 PTT 嗎？

古永忠
IB302 45 mins Mandarin Advanced
15:15 ~ 15:55 Open Hardware
自幹軟體收音機從硬體到軟體

彭大海
413-2 40 mins Mandarin Skilled
15:30 ~ 16:00 Open Source Chatbot Development
SUSI.ai: a Open Source ai chatbot(text or voice) in multi platform

Noah Chen
TR309 30 mins Mandarin Beginner
15:30 ~ 16:00 OSC (OSPN) Special Track
Making world better: 從社群到社會，從台灣到世界

Hisahiro Ohmura
TR312 30 mins Mandarin Beginner
15:30 ~ 16:00 BSDTW x Cat System Workshop
Getting started with FreeBSD development

許立文
412-2 30 mins Mandarin Beginner
15:35 ~ 16:00 OpenStreetMap x Wikidata
運用維基共享資源於蝴蝶物種辨識系統之建構

Eric Lan
TR509 25 mins Mandarin Beginner
16:05 ~ 17:05 Main & Misc.
Lightning Talks
TR313 60 mins
17:05 ~ 17:30 Main & Misc.
Closing

COSCUP Staff
IB101 25 mins Mandarin