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
SITCON 2017 論壇系統開發分享 @ SITCON 2017 Summer
Search
Jeremy Yen
August 17, 2017
Education
0
190
SITCON 2017 論壇系統開發分享 @ SITCON 2017 Summer
SITCON 2017 論壇系統
談開發一套系統所面臨的各式問題
Jeremy Yen @ SITCON Summer Camp 2017 (THU)
Jeremy Yen
August 17, 2017
Tweet
Share
More Decks by Jeremy Yen
See All by Jeremy Yen
dEXonation
jeremy5189
0
100
A day of full stack developer @ NFU
jeremy5189
0
190
Club Mate and Hacker - 34C3 @ SITCON
jeremy5189
2
610
poManeuver: Poland into space
jeremy5189
0
350
How we hacked a forum
jeremy5189
0
330
Bdecisive - Booking.com Taipei Hack 2nd Prize
jeremy5189
0
470
Social Intelligence Smart-device project
jeremy5189
0
58
IoT made easy @ SITCON x HK
jeremy5189
0
97
遺失的學校 - SITCON 2014 Lightning Talk
jeremy5189
0
550
Other Decks in Education
See All in Education
LTをすべき100の理由
eltociear
0
180
第1回全国商業高校Webアプリコンテスト総括
asial_corp
0
350
論文の読み方 / How to survey
kaityo256
PRO
167
110k
4 занятие. Разбор бизнес-моделей и метод красной нити #ideaNN 9.02.2024.
karlov
0
210
UniKL 2024 - Phishing Security Awareness: Malware
x86fatah
0
100
6 занятие. Четыре тактики метода "8 кубиков"бизнес-модели #ideaNN 1.03.2024.
karlov
0
140
20240319AJG
tosseto
0
270
1 занятие. План курса бизнес-моделей и блок "сегментирование" #ideaNN 19.01.2024.
karlov
0
230
全員参加型で会社を強くしていく活動を考えてみる
ikefukurou777
0
160
ISMSってどんなもの?
fbei_ot
0
130
Monaca Educationを活用した課題解決型の探究学習の実践
asial_edu
0
160
Data Representation - Lecture 3 - Information Visualisation (4019538FNR)
signer
PRO
1
1.7k
Featured
See All Featured
Designing for humans not robots
tammielis
247
25k
Git: the NoSQL Database
bkeepers
PRO
421
63k
The World Runs on Bad Software
bkeepers
PRO
60
6.6k
10 Git Anti Patterns You Should be Aware of
lemiorhan
644
57k
The Psychology of Web Performance [Beyond Tellerrand 2023]
tammyeverts
5
1.4k
Easily Structure & Communicate Ideas using Wireframe
afnizarnur
185
15k
Dealing with People You Can't Stand - Big Design 2015
cassininazir
355
22k
Docker and Python
trallard
33
2.6k
Mobile First: as difficult as doing things right
swwweet
215
8.5k
The Brand Is Dead. Long Live the Brand.
mthomps
48
22k
Building Effective Engineering Teams - LeadDev
addyosmani
25
1.8k
Unsuck your backbone
ammeep
661
56k
Transcript
SITCON 2017 锸㠢禺窡 锓♧⦐剢欰ⴀ涮♧㤛禺窡 䨾荆涸ぐ䒭㉏겗 +FSFNZ:FO !4*5$0/4VNNFS$BNQ
+FSFNZ:FO ˙(MPTTJLB笪갤䊨玑䌌植耷 ˙4*5$0/陾玑穉ⶰ穉Ꟁ ˙,1.(须鎝㸞곃㉏灇瑖㆞ ˙〵猰㣐须盘禺
闍겗㣐笧 ˙锸㠢禺窡殹㣔麌⡲矦➝ ˙宠焷钢植㻜 ˙宠焷钢䪮遯 ˙䪮遯鼇乵 ˙庠鑑⿻♳箁彋⪔
None
䲿ⴀ涮鎊歍锞 ˙ そ珖䗳㞅 ˙ &NBJM (SBWBUBS ˙ 涮鎊䶰銴
None
锸㠢须俲窡鎙 191 涮鎊歍锞 83 ⼣そ㜥Ⰹ涮鎊
锸㠢须俲窡鎙 46 䨞铃鎊 9 䨞怵皿岁 26 ⢵✥涸
None
♶銴铞䎍鑨㥪㌨ 鏤鎙㼩涯
闍겗㣐笧 ˙锸㠢禺窡殹㣔麌⡲矦➝ ˙宠焷钢植㻜 ˙宠焷钢䪮遯 ˙䪮遯鼇乵 ˙庠鑑⿻♳箁彋⪔
➊랃僽锸㠢
None
䧮⦛䟝鍑对➊랃㉏겗
4*5$0/ 锸㠢
㣐㹻鿪〳⟃闍鑨剚♶剚 ˙ ⨋ꨆ⚺겗 ˙ 铪⯓铪䖕涮鎊獘䎸 ˙ 剤➃䨞 ˙ 剤➃⢵✥ ˙
尝➃闍鑨
繏⠭暶陾✲鋊
⼀一般議事規則 SITCON 論壇 發⾔言規則 發⾔言⽅方法 舉⼿手待主席認可 (Recognized) 透過系統排入發⾔言 隊列列 (Queue)
發⾔言時限 與會⼈人透過動議 (Motion) 設定 直接設定 90 秒 討論議程設定 預先排定 可透過動議改變順序 即當年年論壇主題 偏離主題 透過動議和投票 將討論轉移或聚焦 系統可即時變更更 顯⽰示主題以導向或聚焦
剤➃䨞 ˙ 剤涮鎊ㄤ䨞铃鎊剤ꡠ ˙ 剤涮鎊 ˙ 鷴麕㞅㻨涸㣐笧⸔椚⚺䭰➃腋㼟莅⚺겗搂ꡠ 涸涮鎊갫䎸꣮⡜雊剤䠑纏涸涮鎊⯓遤䱖Ⰵ 2VFVF
None
剤➃⢵✥尝➃闍鑨 㔔捀♳铭⯈鏪涮㉏ 剚剤➃⢵✥ 䨾⟃〭㷸欰㸞ꬆ聃 铭㽠㥪 鼩僽剤➃涮㉏齡 䭸顑➮♶僽 硱㶩酭Ꟁ㣐 涸둷♶剚굳
None
䙼罌㉏겗涸㛇燊⧺鏤 正⾯面興利利 負⾯面防弊 㣐鿈ⴕ涸➃剚 琎噲椚䚍鎣锸涮鎊 ♧㹁剚剤➃⢵✥ 尝➃闍鑨剚Ⲉ㜥 ⵄ欽黠殹倰岁 ⼿⸔鎣锸♳姻鮨 犝姺䨾剤➃闍鑨
穡呪
闍겗㣐笧 ˙锸㠢禺窡殹㣔麌⡲矦➝ ˙宠焷钢植㻜 ˙宠焷钢䪮遯 ˙䪮遯鼇乵 ˙庠鑑⿻♳箁彋⪔
䪮遯宠ⴕ區 ˙ 莅罏歍锞涮鎊➝ ˙ 窍莅罏㞅㻨そ㶶涮鎊䶰銴&NBJM ˙ 䪮遯ⴕ區 ˙ 笪갤"QQ笪갤嫲鯱矦㋲⚂4*5$0/䎃剚 䊺竤剤"QQ〳⟃湬䱺䅺Ⰵ笪갤
˙ 㞅㻨须俲〫銴♧❉5FYUCPYㄤ♧⦐䭾ꈈ 䪾须俲笪䖕畮鷑㽠㥪
䪮遯宠ⴕ區 ˙ 䖕〵➝ ˙ ⽰儘懳錒湡䨾剤涮鎊歍锞 ˙ ⯈鏪鸒麕ⵅꤑ涮鎊歍锞 ˙ ⯈鏪刿佖⚺겗 ˙
䪮遯ⴕ區 ˙ ⢪欽笪갤⡎衽ꅾ⽰儘㽠䗳갭罌䣂 8FCTPDLFU
䪮遯宠ⴕ區 ˙ 䫏䕧堥➝ ˙ ⽰儘곏爚湡涮鎊➃湡涮鎊䶰銴闍罏 瘞䖊➃侸ⶦ긅儘 ˙ 䪮遯ⴕ區 ˙ 罌ꆀ⽰儘刿倞䗳갭罌ꆀ8FCTPDLFU㢫
⛳䗳갭腋䥰➰瀊冾涸鸮箁♶琽㹁
None
禺窡卺圓矦㕬 ⠿剪㐼须俲䏨 莅剚罏➝ 䖕〵➝ 䫏䕧➝ 申請發⾔言 收到發⾔言 排入隊列列 顯⽰示於隊列列 WebSocket
HTTP
)551WT8FC4PDLFU )5514FSWFS 懳錒㐼 Request Respond
)551WT8FC4PDLFU 8FC4PDLFU 懳錒㐼 Keep-alive
闍겗㣐笧 ˙锸㠢禺窡殹㣔麌⡲矦➝ ˙宠焷钢植㻜 ˙宠焷钢䪮遯 ˙䪮遯鼇乵 ˙庠鑑⿻♳箁彋⪔
䪮遯鼇乵 畮 )5.-$44 7VFKT +4K2VFSZ 3FBDUKT 沒其他選擇了了XD 相比 React 我認為比較好上⼿手的前端框架
設定最簡單最快速的寫法 ⽬目前非常熱⾨門的前端框架
䪮遯鼇乵 䖕畮 /PEFKT&YQSFTT 3VCZPO3BJMT 1ZUIPO%KBOHP 1)1-BSBWFM
ⶾ噠䗳⪔-BSBWFM䖕畮笪畀Ⰵ IBIPXJODSMBSBWFMCBDLFOE 墂呪䒭⠿剪㐼 ˙ 8FCSPPU ⠿剪㐼须俲㣰 ˙ JOEFYQIQ ˙
VTFSQIQ ˙ MPHJOQIQ
ⶾ噠䗳⪔-BSBWFM䖕畮笪畀Ⰵ IBIPXJODSMBSBWFMCBDLFOE 䅺Ⰵ玑䒭焺 IUNM I QIQFDIPUJUMF I
IUNM ⠿剪㐼♳⛓JOEFYQIQ
ⶾ噠䗳⪔-BSBWFM䖕畮笪畀Ⰵ IBIPXJODSMBSBWFMCBDLFOE 䅺Ⰵ玑䒭焺 IUNM I 1)1湬陼㐼贖椚⚥ I IUNM 佐ⵌ銴宠䖕贖椚JOEFYQIQ
ⶾ噠䗳⪔-BSBWFM䖕畮笪畀Ⰵ IBIPXJODSMBSBWFMCBDLFOE 䅺Ⰵ玑䒭焺 IUNM I .Z5JUMF I IUNM 㹐䨩畮ツ植⛓JOEFYQIQ
䪮遯鼇乵
ꡠ鸮䒭须俲䏨
䪮遯鼇乵 须俲䏨 /P42-.POHP%# 42-.Z42- 扁平/欄欄位可能不相同/沒有必要關聯聯 需要關聯聯/正規化的資料
䪮遯鼇乵 䖕畮 畮 须俲䏨 )5.-$44 /PEFKT&YQSFTT /P42-.POHP%# 7VFKT 3VCZPO3BJMT +4K2VFSZ
3FBDUKT 1ZUIPO%KBOHP 42-.Z42-
闍겗㣐笧 ˙锸㠢禺窡殹㣔麌⡲矦➝ ˙宠焷钢植㻜 ˙宠焷钢䪮遯 ˙䪮遯鼇乵 ˙庠鑑⿻♳箁彋⪔
庠鑑䊨Ⱘ ˙ &OEUPFOEOJHIUXBUDIKT ˙ 荈⹛⻋欽懳錒㐼垸亼⢪欽罏乽⡲ ˙ 㠺⸂庠鑑BQBDIFCFODI BC ˙
垸亼㣐ꆀ䖕畮锞宠
岤䠑✲갪 ˙ ♶銴湱⥌⢪欽罏涸鱒Ⰵ ˙ 42-*OKFDUJPO ㋲䒸贫 ˙ 944 TDSJQUBMFSU
TDSJQU ˙ 瑠⧩OVMM ˙ 须俲㘗䢀侸㶶㶶⚮ ˙ 姺扫宐 ˙ SFBQUDIB
2" 論壇系統原始碼 github.com/jeremy5189/PDModerator