Giter Club home page Giter Club logo

scienceproject's Introduction

ScienceProject

๊ณผํ•™ํ”„๋กœ์ ํŠธ, ๋‚ ์”จ์— ํ•™๊ต๋ฅผ ๋”ํ•˜๋‹ค

ํ™”๋ฉด

2019๋…„ 2ํ•™๊ธฐ๋ง์— ์‹œ์ž‘ํ•œ ํ”„๋กœ์ ํŠธ ์˜€๋Š”๋ฐ, ์ด๋ฅผ ํ†ตํ•ด์„œ DB์™€ Django๋ฅผ ์ž…๋ฌธํ•ด ๋ณด์•˜๊ณ , (์ œ ์žฅ๊ณ ๋กœ์˜ ์ฒซ ์ž‘ํ’ˆ์ž…๋‹ˆ๋‹ค.)
2020๋…„ ํ˜„์žฌ๊นŒ์ง€๋„ ๊ฐœ์ธ์ ์œผ๋กœ ์กฐ๊ธˆ์”ฉ ์ฝ”๋“œ๋ฅผ ๋ฆฌํŽ™ํ† ๋งํ•˜๊ฑฐ๋‚˜, ๊ดœ์ฐฎ์€ ๊ธฐ๋Šฅ์„ ์ถ”๊ฐ€ํ•˜๋Š” ๋“ฑ ์‹œ๋„๋ฅผ ํ•ด๋ณด๊ณ  ์žˆ์Šต๋‹ˆ๋‹ค.

๋ฒ„์ „

ver1(2020-2-15) ๊ฐœ๋ฐœ๋ชฉํ‘œ์—(์ œ์•ˆ์„œ, ๊ณ„ํš์„œ) ๋งž๋Š” ์›น์„ ๊ฐœ๋ฐœํ•˜์˜€์Šต๋‹ˆ๋‹ค.

๋‚ ์”จ์ •๋ณด์ค‘ ๋“ฑํ•˜๊ต ๋‚ ์”จ, ์•„์นจ์šด๋™ ์‹œ๊ฐ„์˜ ๋‚ ์”จ๋ฅผ ๊ฐ€์ ธ์™€, ๊ทธ์™ธ์˜ ๋‚ ์”จ์ •๋ณด(์˜จ๋„, ๊ธฐ์ƒ์ƒํ™ฉ, ๋ฏธ์„ธ๋จผ์ง€๋“ฑ๋“ฑ)๊ณผ ํ•จ๊ป˜
๊ทธ์—๋งž๋Š” ํ”ผ๋“œ๋ฐฑ์„ ์ œ๊ณตํ•ด์ฃผ๋Š”(์•„์นจ์šด๋™ ํ™•๋ฅ ์„ ์˜ˆ์ธกํ•ด์ฃผ๋Š”) ์›น์„ ๊ฐœ๋ฐœ, ๋ฐฐํฌํ•˜์˜€์Šต๋‹ˆ๋‹ค.

์กฐ๋ณ„ ํ”„๋กœ์ ํŠธ๋กœ ์ง„ํ–‰ํ–ˆ๊ณ , ๋ธŒ๋ ˆ์ธ์Šคํ† ๋ฐ๋ถ€ํ„ฐ ๊ฐœ๋ฐœ ๊ณผ์ •๊นŒ์ง€ ๋…ธ์…˜์„ ํ™œ์šฉํ•˜๋ฉด์„œ ๊ณผ์ •๋“ค์„ ๊ธฐ์žฌํ•˜๊ณ  ๊ณต์œ ํ–ˆ์Šต๋‹ˆ๋‹ค. https://www.notion.so/Science_Project-9c3b5deffd7446eda3b27296d446757e

๊ฐœ๋ฐœ๋ชฉํ‘œ์™€ ์ œ์•ˆ์„œ๋ฅผ ๊ฐœ์ธ์ ์œผ๋กœ ์ •๋ฆฌํ•˜๋ฉด ์•„๋ž˜์™€ ๊ฐ™์Šต๋‹ˆ๋‹ค.

๊ฐœ๋ฐœ๋ชฉํ‘œ - 
์šฐ๋ฆฌํ•™๊ต์˜ ๋“ฑํ•˜๊ต์‹œ๊ฐ„, ์•„์นจ์šด๋™์‹œ๊ฐ„์˜ ๋‚ ์”จ์ •๋ณด์™€ ๋‚ ์”จ์ •๋ณด๋กœ ์•„์นจ์šด๋™ํ™•๋ฅ ๋„ ์˜ˆ์ธกํ•˜๋Š” ์›น์‚ฌ์ดํŠธ

๊ฐœ๋ฐœ๊ธฐ๊ฐ„ - 
2019๋…„ 12์›” 20์ผ ~ 2์›” 15์ผ
๊ฐœ๋ฐœ๋‹จ๊ณ„ - 
1. ๋ฐ์ดํ„ฐ ํฌ๋กค๋ง ํ”„๋กœ๊ทธ๋žจ ๊ตฌํ˜„, mysql๋กœ DB ๊ตฌ์ถ• (๋™ํ˜„, ์ˆ˜ํ•„, ๋‘ํ‰, 19.12.20. ~ 20.1.4.) 
2. DB ์„œ๋ฒ„ ์—ฐ๋™, ๋ฐฑ์—”๋“œ ํ”„๋ก ํŠธ์—”๋“œ ๋‚˜๋‰˜์–ด ๊ตฌํ˜„ (๋‘ํ‰, ํ˜„ํ˜ธ, ์ข…๊ทผ, 20.12.20. ~ 20.1.16.)
3. ํ”„๋ก ํŠธ ๋ฐฑ ์—ฐ๊ฒฐ ๋ฌธ์ œ๋กœ ๋ฌด์‚ฐ (20.1.16 ~ 20.2.1.)
4. ์žฅ๊ณ ๋กœ ์›น ๊ตฌํ˜„, ๋กœ์ปฌ์„œ๋ฒ„๋กœ ํ”„๋ก ํŠธ์— DB๊ฐ’ ์ถœ๋ ฅ ์„ฑ๊ณต (20.2.2. ~ 20.2.7.)
5. ์›น ๋””์ž์ธ, ํผ๋ธ”๋ฆฌ์‹ฑ ์™„๋ฃŒ, ์›๊ฒฉ์„œ๋ฒ„๋กœ ๋ฐฐํฌ ์™„๋ฃŒ, ํ”„๋กœ์ ํŠธ ๋! (20.2.8. ~ 20.2.15.)

(๋ฐฑ ํ”„๋ก ํŠธ์ƒ ์—ฐ๊ฒฐ์ด ๋„๋ฌด์ง€ ์•ˆ๋˜๊ณ , ๊ฐˆ๋“ฑ์œผ๋กœ ํ”„๋ก ํŠธ๊ฐ€ ์ž ์ˆ˜ํƒ€๋ฒ„๋ฆฌ๋Š” ๋ฐ”๋žŒ์— ๋ฐ์ดํ„ฐ ํฌ๋กค๋งํŒŒํŠธ์ธ ์ €ํ˜ผ์ž ์žฅ๊ณ ๋กœ ์›น๊ตฌํ˜„ ํ•˜๊ฒŒ ๋ฌ๋‹ค๋Š” ์Šฌํ”ˆ ์ „์„ค..)

ver2(2020-4-1) ํฌ๋กค๋ง๊ณผ DB ์—…๋ฐ์ดํŠธ ์ž๋™ํ™”๋กœ, ์›น์˜ ์ฝ˜ํ…์ธ ๊ฐ€ ๋งค์ผ ๊ฐฑ์‹ ๋ฉ๋‹ˆ๋‹ค.

3์ผ๊ฐ„์˜ ์‚ฝ์งˆ ๋์— ํฌ๋กค๋ง๊ณผ DB ์ž๋™ ์—…๋ฐ์ดํŠธ๋ฅผ ๊ตฌํ˜„ํ–ˆ์Šต๋‹ˆ๋‹ค.
์•ž์œผ๋กœ ์„œ๋ฒ„ ๊ฐฑ์‹ ๋งŒ ํ•œ๋‹ฌ์— ํ•œ๋ฒˆ์”ฉ ํ™•์ธํ•ด์ค€๋‹ค๋ฉด(๋ฌด๋ฃŒ๊ณ„์ •์˜ ๋น„์• ),
๋งค์ผ๋งค์ผ ๊ทธ๋‚ ์˜ ๋‚ ์”จ์— ๋งž๋Š” ์ •๋ณด๋ฅผ ์ œ๊ณตํ•ฉ๋‹ˆ๋‹ค.

ver3(2020-4-30, ์„๊ฐ€ํƒ„์‹ ์ผ) ์ฝ”๋“œ๋ฅผ ๋ฆฌํŽ™ํ† ๋งํ•ด์„œ index.html ๋‚ด์šฉ์„ ๋ฐ˜์˜ ๋ฐ˜์œผ๋กœ ์ตœ์ ํ™” ํ–ˆ์Šต๋‹ˆ๋‹ค. get ์š”์ฒญ์œผ๋กœ ์›น ํŽ˜์ด์ง€๊ฐ€ ๋ณ€ํ™”ํ•ฉ๋‹ˆ๋‹ค.

Django ์™€ ์›น์— ๋Œ€ํ•ด์„œ ํ•™์Šตํ•œ ์ดํ›„์—, ๋ฐฑ์—”๋“œ์—์„œ ํผ์˜ get ์š”์ฒญ์„ ๋ฐ›์•„์„œ
์•Œ๋งž์€ ํŽ˜์ด์ง€์™€ DB๋ฅผ ์ „์†กํ•  ์ˆ˜ ์žˆ๊ฒŒ ํ–ˆ์Šต๋‹ˆ๋‹ค.
2์ผ๋งŒ์— ์‰ฝ๊ฒŒ ๋๋ƒˆ์œผ๋ฉฐ, ์„๊ฐ€ํƒ„์‹ ์ผ(4-30)์— ๋ฌธ์„œ๋กœ ๋‚ด์šฉ์„ ์ •๋ฆฌํ•˜์˜€์Šต๋‹ˆ๋‹ค.

2803 ์ค„ => 562 ์ค„

ver3.1(2020-5-5, ์–ด๋ฆฐ์ด๋‚ ) ์ฝ”๋“œ๋ฅผ ์ถ”๊ฐ€๋กœ ๋ฆฌํŽ™ํ† ๋ง ํ•ด์„œ, index.html ์˜ ๋‚ด์šฉ์„ ๊ฑฐ์˜ ์ ˆ๋ฐ˜์œผ๋กœ ๋‹ค์‹œ ์ตœ์ ํ™” ํ–ˆ์Šต๋‹ˆ๋‹ค.

๋ฐ˜๋ณต๋˜๋Š” ์š”์†Œ๋ฅผ ๋ฌถ์–ด์„œ ์žฅ๊ณ ์˜ ํ…œํ”Œ๋ฆฟ ์–ธ์–ด {% for ~ in ~ %} ๋ฌธ์œผ๋กœ ์ฒ˜๋ฆฌํ•ด ์ฃผ์—ˆ์Šต๋‹ˆ๋‹ค.

562 ์ค„ => 355 ์ค„

ver3.9(2020-5-7) ๋ฐ˜์‘ํ˜• ์›น์œผ๋กœ, ์ปดํ“จํ„ฐ ~ ํƒ€๋ธ”๋ › ์Šคํฌ๋ฆฐ์— ๋งž๋Š” ํ™”๋ฉด์„ ์ง€์›ํ•ฉ๋‹ˆ๋‹ค.

๊ธฐ๋ณธ ์ปดํ“จํ„ฐ ํ™”๋ฉด๋ถ€ํ„ฐ ~ 600px ๋„ˆ๋น„์˜ ํ™”๋ฉด๊นŒ์ง€ ํ™”๋ฉด์— ๋งž๋Š” ๋ ˆ์ด์•„์›ƒ์œผ๋กœ ์ง€์›ํ•˜๊ฒŒ ํ•˜์˜€์Šต๋‹ˆ๋‹ค.
๋ฏธ๋””์–ด ์ฟผ๋ฆฌ๋ฅผ ์‚ฌ์šฉํ•ด์„œ ๊ธฐ์กด css ์™€ ํƒ€๋ธ”๋ › ์Šคํฌ๋ฆฐ css ๋ฅผ ๋ถ„๋ฆฌํ–ˆ์Šต๋‹ˆ๋‹ค. ์ž์„ธํ•œ ๋‚ด์šฉ์€ ๊ฒฐ๊ณผ ์ด๋ฏธ์ง€๋ฅผ ์ฐธ๊ณ 

ver4(2020-5-7) ๋ฐ˜์‘ํ˜• ์›น์œผ๋กœ, ์ด์ œ ํœด๋Œ€ํฐ ~ ํƒ€๋ธ”๋ › ~ ์ปดํ“จํ„ฐ ๋ชจ๋‘์˜ ํ™”๋ฉด์„ ์ง€์›ํ•ฉ๋‹ˆ๋‹ค.

ํ™”๋ฉด์˜ ๋„ˆ๋น„๊ฐ€ 430px ์ดํ•˜์ธ ํœด๋Œ€ํฐ ํ™”๋ฉด์—์„œ๋„ ์ด์ œ ์›น์‚ฌ์ดํŠธ์˜ ์ฝ˜ํ…์ธ ๋ฅผ ํ™•์ธํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค. ์ž์„ธํ•œ ๋‚ด์šฉ์€ ๊ฒฐ๊ณผ ์ด๋ฏธ์ง€๋ฅผ ์ฐธ๊ณ 


๊ฒฐ๊ณผ

๋งํฌ : http://bosal.pythonanywhere.com/

PC ํ™”๋ฉด

ํ”„๋กœ์ ํŠธ์›น์‚ฌ์ดํŠธ์บก์ฒ˜

๊ทธ์™ธ...

ํ”„๋กœ์ ํŠธ์›น์‚ฌ์ดํŠธ์บก์ฒ˜
ํ”„๋กœ์ ํŠธ์›น์‚ฌ์ดํŠธ์บก์ฒ˜
ํ”„๋กœ์ ํŠธ์›น์‚ฌ์ดํŠธ์บก์ฒ˜

ํƒ€๋ธ”๋ › ํ™”๋ฉด

ํ”„๋กœ์ ํŠธ์›น์‚ฌ์ดํŠธ์บก์ฒ˜

๊ทธ์™ธ...

ํ”„๋กœ์ ํŠธ์›น์‚ฌ์ดํŠธ์บก์ฒ˜
ํ”„๋กœ์ ํŠธ์›น์‚ฌ์ดํŠธ์บก์ฒ˜
ํ”„๋กœ์ ํŠธ์›น์‚ฌ์ดํŠธ์บก์ฒ˜
ํ”„๋กœ์ ํŠธ์›น์‚ฌ์ดํŠธ์บก์ฒ˜
ํ”„๋กœ์ ํŠธ์›น์‚ฌ์ดํŠธ์บก์ฒ˜

ํœด๋Œ€ํฐ ํ™”๋ฉด

ํ”„๋กœ์ ํŠธ์›น์‚ฌ์ดํŠธ์บก์ฒ˜

๊ทธ์™ธ...

ํ”„๋กœ์ ํŠธ์›น์‚ฌ์ดํŠธ์บก์ฒ˜
ํ”„๋กœ์ ํŠธ์›น์‚ฌ์ดํŠธ์บก์ฒ˜


๊ฐœ๋ฐœ ๋…ธํŠธ

ver 2 ๊ฐœ๋ฐœ ๋…ธํŠธ

ver 2, ํฌ๋กค๋ง, DB ์—…๋กœ๋“œ ์ž๋™ํ™”

(2020.3.31.~4.2.) pythonanywhere์˜ database๋ฅผ python script๋กœ ์ ‘๊ทผ, db๋ฅผ ์ž๋™์œผ๋กœ ์—…๋ฐ์ดํŠธ ํ•˜๋Š” ์ฝ”๋“œ + ํฌ๋กค๋ง ์ž๋™ํ™”๊นŒ์ง€ ๊ฐœ๋ฐœ์— ์ข…์ง€๋ถ€๋ฅผ ์ฐ์—ˆ์Šต๋‹ˆ๋‹ค.

์นœ์ ˆํ•˜๊ฒŒ๋„ pythonanywhere์—์„œ ์Šคํฌ๋ฆฝํŠธ ๊ธฐ๋Šฅ์„ ์ œ๊ณตํ•˜๋Š”๋ฐ,
๋ถˆ์นœ์ ˆํ•˜๊ฒŒ๋„ db ์ ‘๊ทผ์‹œ ์ƒ๊ธฐ๋Š” ์˜ค๋ฅ˜์— ๋Œ€ํ•ด์„œ ๋Œ€์ถฉ ๋ช…์‹œํ•ด์„œ, ์‚ฝ์งˆ์ข€ ํ–ˆ์Šต๋‹ˆ๋‹ค.

๋ฌธ์ œ ํ•ด๊ฒฐ๊ณผ์ •(์‚ฝ์งˆ)์— ๋Œ€ํ•ด์„œ ์ž์„ธํ•œ ๋‚ด์šฉ์€, pythonanywhere_access/ ํด๋”๋ฅผ ์ฐธ๊ณ ํ•˜์‹œ๋ฉด ๋˜๊ฒ ์Šต๋‹ˆ๋‹ค.

๊ฒฐ๊ณผ

ํ”„๋กœ์ ํŠธ์›น์‚ฌ์ดํŠธ์บก์ฒ˜

4์›” 6์ผ์ž ๋…ธํŠธ

backup?

(2020-4-6)
์ •๋ง ์šธ๋ป”ํ–ˆ์Šต๋‹ˆ๋‹ค. git bash๋กœ ํด๋”๋“ค์˜ ์ด๋ฆ„์„ ๋ณ€๊ฒฝํ•˜๋ ค๊ณ  ํ–ˆ๋Š”๋ฐ, ๋ญ๊ฐ€ ์ž˜๋ชป๋ฌ๋Š”์ง€, git mv ์›๋ž˜์ด๋ฆ„ ์ƒˆ์ด๋ฆ„์ด ์•ˆ๋ฌ์Šต๋‹ˆ๋‹ค.
๊ทธ๋ž˜์„œ ๊ตฌ๊ธ€๋ง์œผ๋กœ ์ฐพ์€ ๋ฐฉ๋ฒ•๋“ค์„ ์‹คํ–‰ํ•˜๋‹ค๊ฐ€, ๋ธŒ๋Ÿฐ์น˜๋ฅผ ์‚ญ์ œํ•˜๋Š” ๋ช…๋ น์–ด์˜€๋‚˜.? ์™œ๊ทธ๋žฌ๋Š”์ง€๋Š” ๋ชจ๋ฅด๊ฒ ์ง€๋งŒ,
๋กœ์ปฌ์— ์žˆ๋Š” ๋ธŒ๋Ÿฐ์น˜๋ฅผ ์‚ญ์ œํ•˜๊ณ  ์›๊ฒฉ์œผ๋กœ ๋‹ค์‹œ ๋ฐ›์•„์˜ฌ๋ ค๋Š” ์ƒ๊ฐ์ด์˜€๋Š” ๊ฐ€๋ณธ๋ฐ,

git status

ํ•˜๊ณ  ์ƒํƒœ๋ฅผ ๋ณด๋‹ˆ๊นŒ ์ด์ƒํ•˜๊ฒŒ ํด๋”์˜ ๋ชจ๋“  ํŒŒ์ผ์ด ์‚ญ์ œ๋ฌ๋‹ค ํ•˜๋Š” ๊ฒ๋‹ˆ๋‹ค.
๊ทธ๋ฆฌ๊ณ  git push ๋ฅผ ํ•˜๋ ค๋‹ˆ๊นŒ ์•„์ด๋””๋ž‘ ๋น„๋ฐ€๋ฒˆํ˜ธ๋ฅผ ์ž…๋ ฅํ•˜๋ผ ํ•˜๋”๋ผ๊ตฌ์š”...

๊ทธ๋ฆฌ๊ณ  ๋‚˜์„œ ๋ชจ๋“  ํŒŒ์ผ์ด ์‚ญ์ œ๋˜์—ˆ์Šต๋‹ˆ๋‹ค (์ด ์›๊ฒฉ ์ €์žฅ์†Œ์•ˆ์˜ ๋ชจ๋“  ํด๋”, ํŒŒ์ผ)

๋จธ๋ฆฌ์†๋„ ๊ฐ™์ด ํ•˜์–˜์กŒ๊ณ , git reset ์œผ๋กœ ๋ณต๊ตฌ๋Š” ์•ˆ๋ฌ์Šต๋‹ˆ๋‹ค.
(๋‹น์—ฐํ•˜๊ฒŒ๋„ ๋กœ์ปฌ์ €์žฅ์†Œ๋กœ ๋ณต๊ตฌํ•ด๋ดค์ž ์›๊ฒฉ์ €์žฅ์†Œ๋Š” ๋ณต๊ตฌ ํ•  ์ˆ˜ ์—†๋Š”๋ฐ,)
๊ทธ๋• ๋จธ๋ฆฌ๊ฐ€ ๊ตณ์–ด์„œ git reset ์„ ํ–ˆ๋Š”๋ฐ ์›๊ฒฉ์ €์žฅ์†Œ๊ฐ€ ์™œ ๊ทธ๋Œ€๋ก ๊ฐ€ ์ŠฌํŽ์Šต๋‹ˆ๋‹ค.

์ •๋ง 1์‹œ๊ฐ„๋™์•ˆ ์ •๋ง ์šธ๋ป”ํ–ˆ์ง€๋งŒ, ์–ด๋–ป๊ฒŒ๋“  ๋งจํƒˆ์„ ์žก๊ณ , ์ €์žฅ์†Œ ๋ณต๊ตฌ์— ์„ฑ๊ณตํ–ˆ์Šต๋‹ˆ๋‹ค.

https://jupiny.com/2019/03/19/revert-commits-in-remote-repository/
์ •๋ง ๊ฐ์‚ฌํ•ฉ๋‹ˆ๋‹ค

๋•๋ถ„์— ๊นƒํ—ˆ๋ธŒ์˜ ๊ณตํฌ์˜ ์“ด๋ง›์„ ์˜ค๋žœ๋งŒ์— ๋งŒ๋‚ฌ๊ณ , ๋”์šฑ์ด ์ง€์‹์ด ๋Š˜์—ˆ์Šต๋‹ˆ๋‹ค.
๊ทธ๋ฆฌ๊ณ  ๋‹ค์Œ๋ถ€ํ„ฐ ๋ชจ๋ฅด๋Š” ๊ฑด, ํŠนํžˆ ์•„์ด๋””์™€ ๋น„๋ฒˆ์„ ์ž…๋ ฅํ•ด์•ผ ๋˜๋Š” ๊ฒƒ์€ ํ•จ๋ถ€๋กœ ์•ˆํ•  ๊ฒƒ ๊ฐ™์Šต๋‹ˆ๋‹ค. ^^;;

ver 4 ๊ฐœ๋ฐœ ๋…ธํŠธ

ver 4. ๋ฐ˜์‘ํ˜• ์›น ๊ตฌํ˜„

(2020-5-6 ~ 2020-5-7)

ํ”„๋กœ์ ํŠธ์›น์‚ฌ์ดํŠธ์บก์ฒ˜
์†”์งํžˆ ์ฒ˜์Œ ์›น์„ ๋งŒ๋“ค์—ˆ์„๋•Œ, ์นœ๊ตฌ๋‚˜ ๊ฐ€์กฑ์—๊ฒŒ ์ž๋ž‘ํ• ๋ ค๊ณ  ๋งํฌ๋ฅผ SNS๋กœ ๋ณด๋‚ด๋Š”๋ฐ, ํ•˜๋‚˜๊ฐ™์ด ๊นจ์ง„๋‹ค๊ณ  ํ•˜๋”๋ผ๊ตฌ์š”.
์ƒ๊ฐํ•ด๋ณด๋‹ˆ๊นŒ ๋งจ์ฒ˜์Œ ๋งŒ๋“ค๋•Œ ๋ฐ˜์‘ํ˜•์œผ๋กœ ์›น์„ ์•ˆ๋งŒ๋“ค์—ˆ๋˜ ๊ฒƒ์ด์˜€์Šต๋‹ˆ๋‹ค..

๊ทผ๋ฐ ๋ญ css ์—์„œ ๋ฏธ๋””์–ด ์ฟผ๋ฆฌ ์ด์šฉํ•ด์„œ ์Šคํƒ€์ผ๋งŒ ์ ์šฉํ•ด์ฃผ๋ฉด ๋˜๋‹ˆ๊นŒ ์ฒ˜์Œ์—๋Š” ๋ณ„ ์ƒ๊ฐ์—†์ด,
css ์ฝ”๋“œ๋ฅผ ์ˆ˜์ •ํ•˜๋Ÿฌ ๊ฐ”๋Š”๋ฐ...

๊ฐ€๊ด€์ด์˜€์Šต๋‹ˆ๋‹ค. ์‹ฌ์ง€์–ด html ์—์„œ style ์†์„ฑ๋„ ์žˆ๊ณ  ์„ ํƒ์ž๊ฐ€ ์ค‘๋ณต๋˜๋Š” css๋„ ์žˆ๊ณ ... ์ผ๋‹จ ๊ฐ„๋žตํ•˜๊ฒŒ ๋ฐ˜์‘ํ˜• ์›น ๊ตฌํ˜„์„ ๋งˆ์น˜๊ณ , ๋‹ค์Œ๋ฒˆ์—๋Š” html ์—์„œ style ์†์„ฑ๊ฐ’์„ ๋ชจ๋‘ css๋กœ ์˜ฎ๊ธฐ๊ณ  ์ฝ”๋“œ๋ฅผ ์ •๋ฆฌํ•˜๋Š”,
๋ฆฌํŽ™ํ† ๋ง์„ ๋‹ค์‹œํ•œ๋ฒˆ ํ•ด๋ด์•ผ ๊ฒ ์Šต๋‹ˆ๋‹ค.


์ฐธ๊ณ (Reference)

์‚ฌ์‹ค์ƒ ์ด๋ถ„(์ด์ง„์„์ฝ”์น˜) ์˜์ƒ์œผ๋กœ, ์žฅ๊ณ ํ•ด๋ณผ๊นŒ ๊ณ ๋ฏผํ•˜๊ฒŒ ๋ฌ๊ณ , ์ž…๋ฌธํ•˜๊ฒŒ ๋˜์—ˆ์Šต๋‹ˆ๋‹ค. ์‚ฌ์‹ค์ƒ ์ด ์˜์ƒ์ด ํฌ๋กค๋ง๋งŒ ํ•˜๋˜ ์ œ๊ฐ€ ์žฅ๊ณ ์™€ ์›น๊ฐœ๋ฐœ๊นŒ์ง€ ์ž…๋ฌธํ•˜๊ฒŒ ๋œ ๊ณ„๊ธฐ๊ฐ€ ๋˜์—ˆ์Šต๋‹ˆ๋‹ค.

์žฅ๊ณ ๋กœ DB ์—ฐ๋™๋ถ€ํ„ฐ ์›น ํŽ˜์ด์ง€ ์—ฐ๊ฒฐ๊นŒ์ง€, ์†”์งํžˆ 2003 ์—๋Ÿฌ๋„ ์ฃฝ์–ด๋ผ ๋งŒ๋‚ฌ์—ˆ๋Š”๋ฐ, ๊ฒฐ๊ตญ ์žฅ๊ณ ๋กœ ์›น์„ ๊ตฌํ˜„ํ•  ๋•Œ ๊นŒ์ง€ ์ด ๋ธ”๋กœ๊ทธ์˜ ์žฅ๊ณ  ์„ค๋ช…๊ธ€์„ ์ค‘์‹ฌ์œผ๋กœ ๊ณต๋ถ€ํ–ˆ์Šต๋‹ˆ๋‹ค.

์‚ฌ์‹ค์ƒ ๊ฐœ๋ฐœํ•  ๋•Œ ๊ฑฐ์˜ ์ ˆ๋ฐ˜ ์ด์ƒ์€ ์Šคํ… ์˜ค๋ฒ„ํ”Œ๋กœ์šฐ์—์„œ ์˜ค๋ฅ˜๋ฅผ ์ˆ˜์ •ํ•˜๋Š”๋ฐ๋งŒ ํž˜์ผ์Šต๋‹ˆ๋‹ค. ๋ช‡์‹ญ๊ฐœ์˜ ํŽ˜์ด์ง€๋ฅผ ๋“ค๋ฝ๋‚ ๋ฝ ํ•˜๊ณ , ์ธ๋‚ด์‹ฌ์˜ ํ•œ๊ณ„์—๋„ ๊ฒฌ๋””๋Š” ๊ฒŒ ๊ฒฐ๊ตญ ํ”„๋กœ์ ํŠธ์—์„œ ๊ฐ€์žฅ ํ•„์š”ํ•œ ๋Šฅ๋ ฅ์ด์˜€๋˜ ๊ฒƒ ๊ฐ™์Šต๋‹ˆ๋‹ค.

scienceproject's People

Contributors

kimdonghyeon7645 avatar

Stargazers

 avatar  avatar  avatar  avatar  avatar  avatar

Watchers

 avatar  avatar

Forkers

lifeainteasy

scienceproject's Issues

์›น ์ฝ˜ํ…์ธ  ์•ˆ๋œจ๋Š” ์ด์Šˆ

image
์—ญ์‹œ ๋ฒ„๊ทธ๋Š” ๊ณ ์ณ๋„ ๊ณ ์ณ๋„ ๋‚˜์˜จ๋‹ค. ์›น ํฌ๋กค๋ง, DB์—…๋กœ๋“œ ์ž๋™ํ™”๋Š” ์„ฑ๊ณตํ•œ ๊ฒƒ์€ ๋งž๋Š”๋ฐ, DB table ์—์„œ ๊ฐ’์„ ๋ถˆ๋Ÿฌ์˜ค๊ณ , ์ฝ˜ํ…์ธ ๋กœ ๋„์šฐ๋Š”๋ฐ ๋ฌด์Šจ ๋ฌธ์ œ๊ฐ€ ์žˆ๋Š” ๋“ฏ ํ•˜๋‹ค.

์›นํŽ˜์ด์ง€ ์…€๋ ‰ํŠธ๋ฐ•์Šค ๊ด€๋ จ ์ด์Šˆ

๊นŒ๋จน๊ณ  ์žŠ๊ธฐ ์‰ฌ์šด๋ฐ,

์›นํŽ˜์ด์ง€๋ฅผ ์ ‘์†ํ•ด์„œ ์…€๋ ‰ํŠธ๋ฐ•์Šค๋กœ ์›ํ•˜๋Š” ๊ตฌ๋ฅผ ํด๋ฆญํ•˜๋‹ค๋ณด๋ฉด,

์„œ๊ตฌ(๊ธฐ๋ณธ๊ฐ’)์—์„œ ๋‹ค๋ฅธ ๊ตฌ๋ฅผ ์„ ํƒํ•œ๋’ค, ๋‹ค์‹œ ์„œ๊ตฌ๋ฅผ ์„ ํƒํ•˜๋ฉด ์„œ๊ตฌ์— ๋Œ€ํ•œ ์ปจํ…์ธ ๊ฐ€ ์•ˆ๋ณด์ด๋Š” ๋ฌธ์ œ๊ฐ€ ์žˆ๋‹ค.

์†”์งํžˆ js๋Š” ํ•ด๋ณธ์ ์ด ์—†์–ด์„œ ๋ฌธ์ œ์ง€๋งŒ, ์Šฌ์ฉ ๊ณต๋ถ€ํ•ด์„œ ์ปจํ…์ธ ๊ฐ€ ์•ˆ๋ณด์ด๋Š” ๋ฒ„๊ทธ๋„ ์ˆ˜์ •ํ–ˆ์œผ๋ฉด ํ•œ๋‹ค.
  • js ์ชผ๊ธˆ ๊ณต๋ถ€
  • js์—์„œ ๋ฌธ์ œ์ƒ๊ธฐ๋Š” ์ด์œ  ์ดํ•ด
  • ํ•ด๊ฒฐ & ์ตœ์ ํ™”

๋ฌดํ•œ์˜ ๋ฆฌํŽ™ํ† ๋ง

์ผ๋‹จ ๋ฐ˜๋‚˜์ ˆ ๋งŒ์— ๋ชจ๋ฐ”์ผ ๋ฐ˜์‘ํ˜• ์›น์„ ์ถ”๊ฐ€ํ•ด์„œ ๊ทธ๋Ÿฐ์ง€, ๋งค์šฐ ๋ถ€์‹คํ•˜๊ณ  ๋‹ค๋ฅธ ์นœ๊ตฌ์˜ ํ”ผ๋“œ๋ฐฑ์œผ๋กœ ์ด๊ฑด ์ˆ˜์ •์ด ํ•„์š”ํ•˜๊ฒ ๋‹ค๋Š” ํ™•์‹ ์ด ๋“ค์—ˆ๋‹ค.

index.html ์— sytle ์†์„ฑ๊ฐ’์„ ์ง€์ •ํ•œ ๋ฌธ์ œ

์ด ๋ถ€๋ถ„ ๋•Œ๋ฌธ์— ๋ฐ˜์‘ํ˜• ์›น ๊ตฌํ˜„์—์„œ ํ”ผ๋ˆˆ๋ฌผ์„ ํ˜๋ ธ๋‹ค. ์ฒ˜์Œ์—๋Š” ๋ณ„ ์‹ ๊ฒฝ ์•ˆ ์ผ์—ˆ๋Š”๋ฐ, ํƒ€๋ธ”๋ ›, ๋ชจ๋ฐ”์ผ์—์„œ์˜ css๋ฅผ ์ถ”๊ฐ€ํ•˜๋ฉด์„œ, ๋ฌธ์ œ๊ฐ€ ๋‚œ๊ฒƒ์ด๋‹ค. ์ผ์ผ์ด style ์†์„ฑ๊ฐ’์ด html์ฝ”๋“œ์— ์žˆ์„ ๋•Œ๋งˆ๋‹ค ๊ทธ๋ถ€๋ถ„์„ ์ง€์šฐ๊ณ  css ํŒŒ์ผ๋“ค์—๋‹ค ์ง€์› ๋˜ ์Šคํƒ€์ผ์„ ํ•˜๋‚˜ํ•˜๋‚˜์”ฉ ์ถ”๊ฐ€ํ•ด์ฃผ๊ณ  ๋‹ค์‹œ ์Šคํƒ€์ผ์„ ์ง€์ •ํ•ด์ฃผ๋Š”๊ฒŒ ํ•œ๋‘˜์ด ์•„๋‹ˆ๋‹ค ๋ณด๋‹ˆ๊นŒ ๋งŽ์ด... ๋‹ต๋‹ตํ–ˆ๋‹ค.

๊ฒฐ๋ก ์€ html ์ƒ์—์„œ ์Šคํƒ€์ผ ๋ถ€๋ถ„์„ ์™„์ „ํžˆ ๋ถ„๋ฆฌํ•ด์•ผ ํ•  ๊ป๊ฐ™๋‹ค.

css ๋ณ‘ํ•ฉ, ๊ฐ„๋žตํ™”(๋ฆฌํŽ™ํ† ๋ง)

css ๊ฐ€ ํ˜„์žฌ 18๊ฐœ์˜ ํŒŒ์ผ์„ ๋ถˆ๋Ÿฌ์˜ค๋Š” ๋ฐฉ์‹์œผ๋กœ ๊ตฌํ˜„ํ–ˆ๋Š”๋ฐ, css ํŒŒ์ผ์ด ๋งŽ๋‹ค๋ณด๋‹ˆ๊นŒ ๋ถˆ๋Ÿฌ์˜ค๋Š”๋ฐ๋„ ๋น„ํšจ์œจ์ ์ด๊ณ , css ์ฝ”๋“œ๋„ ๋ถˆํ•„์š”ํ•œ ๋ถ€๋ถ„์ด ๋„ˆ๋ฌด ๋งŽ์•„์„œ(๋‹ค๋ฅธ์‚ฌ๋žŒ์ด ํผํ”Œ๋ฆฌ์‹ฑํ•œ ์ฝ”๋“œ๋ฅผ ๋ฐ›์•„์„œ ์ˆ˜์ •ํ•˜๋‹ค ๋ณด๋‹ˆ๊นŒ ๊ทธ๋Ÿฐ ๋ฌธ์ œ๊ฐ€ ๋งŽ์•˜๋‹ค) ์˜ˆ์œ ์ฝ”๋“œ๋ผ๊ณ  ์žฅ๋‹ดํ•  ์ˆ˜ ์—†์—ˆ๋‹ค..
์ด๋ฒˆ์— ์‹น๋‹ค ๊ฐˆ์•„์—†๊ณ  ์ƒˆ๋กœ css ์ฝ”๋“œ๋ฅผ ์งœ๋ณผ ์ƒ๊ฐ์ด๋‹ค.

Originally posted by @Kimdonghyeon7645 in #7 (comment)

index.html ๋ฆฌํŽ™ํ† ๋ง(Refactoring)

๊ณผํ•™ํ”„๋กœ์ ํŠธ๊ฐ€ ์‹œ๊ฐ„์— ์ซ’๊ฒจ์„œ ๊ฐœ๋ฐœํ•ด์„œ ์˜€๊ธด ํ•ด๋„, index.html ์ฝ”๋“œ๊ฐ€...
๋”์ฐํ•œ ํšจ์œจ๊ณผ ๊ธธ์ด(2000์ด์˜€๋‚˜ 3000์ค„)์„ ๊ฐ€์ง€๊ณ  ์žˆ๋‹ค.

๊ณผํ•™ํ”„๋กœ์ ํŠธ๋ฅผ ๊ฐœ์„ ํ•˜์ž๋ฉด ์ œ์ผ๋จผ์ € ์ˆ˜์ •ํ•˜์ž

  • html/css ๊ธฐ์ดˆ๋ถ€ํ„ฐ ๋ฐฐ์šฐ๊ณ ์˜ค๊ธฐ
  • js ๊ธฐ์ดˆ์ •๋„๋Š” ๋ฐฐ์šฐ๊ณ ์˜ค๊ธฐ
  • ์ฝ”๋“œ ์ƒˆ๋กœ์งœ๊ธฐ

Django ๋ฐฑ์—”๋“œ ์ฝ”๋“œ์—์„œ ๋ฆฌํŽ™ํ† ๋ง

๊ทธ๋™์•ˆ ๋ฐฑ์—”๋“œ์—์„œ ๋ชจ๋“  DB ๊ฐ’์„ ๋„˜๊ฒจ์ฃผ๊ณ ,
ํ”„๋ก ํŠธ์—์„œ ์กฐ๊ฑด์„ ๊ฑธ์–ด์„œ ์›ํ•˜๋Š” ๊ตฌ์— ๋”ฐ๋ฅธ ์ปจํ…์ธ ๋ฅผ ๋ณด์—ฌ์ฃผ๋ ค๊ณ  ์–˜๋ฅผ ์ผ์Šต๋‹ˆ๋‹ค;;

๊ทธ๋Ÿฌ๋‚˜, ๋ฐฑ์—”๋“œ์™€ ํ”„๋ก ํŠธ์—”๋“œ์˜ ๊ธฐ์ดˆ๋„ ๋ชฐ๋ž๋˜ ๊ฒƒ ๊ฐ™์Šต๋‹ˆ๋‹ค.
๋ฐฑ์—”๋“œ์—์„œ ํผ์—์„œ ์š”์ฒญํ•œ ๊ฐ’์— ๋”ฐ๋ผ์„œ ์•Œ๋งž์€ DB ๊ฐ’์„ ๊ณจ๋ผ์„œ ์ „์†กํ•ด์ฃผ๋ฉด ๋˜๋Š” ๊ฑธ์š”.

๋‹ต์„ html ์ฝ”๋“œ ์•ˆ์—์„œ ์žฅ๊ณ  ํ…œํ”Œ๋ฆฟ์œผ๋กœ ํ•ด๋ณผ๋ ค๊ณ  ํ–ˆ๋˜ ์ ‘๊ทผ์˜ ๋ฌธ์ œ ์˜€์Šต๋‹ˆ๋‹ค.
์ตœ์ข…์ ์œผ๋กœ ๊ณผํ•™ํ”„๋กœ์ ํŠธ๋Š” ๋๋‚ฌ์ง€๋งŒ, ์—‰์„ฑํ•œ ์›นํŽ˜์ด์ง€๋กœ ๋๋‚˜์ง€ ์•Š๊ฒŒ ์ง€์†์ ์œผ๋กœ ์ˆ˜์ •ํ•ด๋ณด๊ฒ ์Šต๋‹ˆ๋‹ค!

Originally posted by @Kimdonghyeon7645 in #1 (comment)

pythonanywhere DB access issues (pythonanywhere DB ์ ‘๊ทผ ์ด์Šˆ)

image
์„œ๋ฒ„์˜ ๋ฉ”์ธ ์ฝ˜ํ…์ธ ๋Š”, ์ฃผ๊ธฐ์ ์œผ๋กœ ๋‚ ์”จ ๋ฐ์ดํ„ฐ๋ฅผ ๋ถˆ๋Ÿฌ์™€์„œ ๋‚ ์”จ์— ๋Œ€ํ•œ ์„œ๋น„์Šค๋ฅผ ์ œ๊ณตํ•˜๋Š” ๊ฒƒ์ธ๋ฐ,
๋ฌธ์ œ๋Š” pythonanywhere db ์ ‘๊ทผ์— ์—๋Ÿฌ๊ฐ€ ๋‚˜์„œ ์ˆ˜๋™์œผ๋กœ db๋ฅผ ์—…๋ฐ์ดํŠธ ํ•  ์ˆ˜ ๋ฐ–์— ์—†๋Š” ์ƒํ™ฉ.

์Šคํฌ๋ฆฝํŠธ ํŒŒ์ผ์„ ์˜ฌ๋ ค๋„, pythonanywhere db๋ฅผ ์ ‘๊ทผ๋ชปํ•˜๋ฉด ์ž๋™์œผ๋กœ db ๋ฐ์ดํ„ฐ๋ฅผ ์—…๋ฐ์ดํŠธ ํ•  ์ˆ˜ ์—†๋‹ค.

ํ˜„์žฌ ๊ทธ๋ถ€๋ถ„์˜ ์ด์Šˆํ•ด๊ฒฐ์ด ํ•„์š”ํ•œ ์ƒํ™ฉ.

  • paramiko ๋ชจ๋“ˆ๋กœ SSH ์—ฐ๊ฒฐ ํ…Œ์ŠคํŠธ
  • sshtunnel.open_tunnel() ์˜ค๋ฅ˜ ํ•ด๊ฒฐ
  • connect() ๋ถ€๋ถ„ ์˜ค๋ฅ˜ ํ•ด๊ฒฐ
  • python ์ฝ”๋“œ๋กœ pythonanywhere DB ์—…๋กœ๋“œ
  • ์™„์„ฑ ์ฝ”๋“œ ์ž‘์„ฑ๋ฐ ์Šคํฌ๋ฆฝํŠธ๋กœ ์ ์šฉ

๋ฐ˜์‘ํ˜• ์›น ๋””์ž์ธ ๊ฐœ์„ 

์†”์งํžˆ ๋ฏธ๋ฆฌ ์ฒ˜์Œ์— ํ•œ ๋””์ž์ธ์„ ํ•˜๋‚˜๋„ ์“ฐ์ง€ ๋ชปํ–ˆ๋‹ค.

๊ทธ ์ด์œ ๊ฐ€ index.html ์ฝ”๋“œ์˜ ๊ตฌ์กฐ๋ฅผ ๊ณ ๋ คํ•˜์ง€ ์•Š์•˜๊ธฐ์—, ๋””์ž์ธ์„ ์›ํ•˜๋Š” ๋Œ€๋กœ ์ˆ˜์ •ํ•  ์ˆ˜ ์—†๋˜ ๊ฒƒ์ด๋‹ค..!

๊ทธ๋ฆฌ๊ณ  ์—ฌ๋Ÿฌ ์นœ๊ตฌ๋“ค์˜ ํ”ผ๋“œ๋ฐฑ๋„ ์ฐธ๊ณ ํ–ˆ์„ ๋•Œ, ์›น์•ฑ์˜ ๋ทฐ ๋””์ž์ธ์„ ์ˆ˜์ •ํ•  ํ•„์š”๊ฐ€ ์žˆ์—ˆ๋‹ค.
๋ฌผ๋ก  css๋ฅผ ๋ฏธ๋ฆฌ ์ •๋ฆฌํ•œ ๋‹ค์Œ์— ์ง„ํ–‰ํ•ด์•ผ ํ•  ์ผ์ด๊ธฐ์— ๋ฌด๊ธฐํ•œ ๋ณด๋ฅ˜ํ•ด์•ผ ๋ ๊ฒƒ ๊ฐ™๋‹ค.. ใ…Žใ…Ž;;

Originally posted by @Kimdonghyeon7645 in #7 (comment)

๋ฐ˜์‘ํ˜• ์›น ๊ตฌํ˜„

๋ชจ๋ฐ”์ผ, ํƒ€๋ธ”๋žซ๋“ฑ, n-์Šคํฌ๋ฆฐ ํ™˜๊ฒฝ์— ๋Œ€ํ•œ ์ง€์› ๋ถ€์กฑ

์›น์˜ ์ฃผ ์ฝ˜ํ…์ธ ๊ฐ€, ์•„์นจ์šด๋™ ๋‚ ์”จ ์˜ˆ์ธก๊ณผ ๋‚ ์”จ์— ๋”ฐ๋ฅธ ํ”ผ๋“œ๋ฐฑ์„ ์ฃผ๋Š” ๊ฒƒ์ธ๋ฐ,
๊ฐ„ํŽธํ•˜๊ฒŒ ์ฝ˜ํ…์ธ ๋ฅผ ํ™•์ธํ• ๋ ค๋ฉด ํœด๋Œ€ํฐ์œผ๋กœ๋„ ๋ณผ์ˆ˜ ์žˆ์–ด์•ผ๋˜๋Š”๋ฐ,

ํœด๋Œ€ํฐ์œผ๋กœ ๋ณด์ž๋ฉด ๊นจ์ง„๋‹ค;; ํŒ€์›์ด ํผ๋ธ”๋ฆฌ์‹ฑํ•  ๋•Œ ๋ฐ˜์‘ํ˜• ์›น์„ ๊ตฌํ˜„ํ•˜์ง€ ์•Š์€ ๊ฒƒ์ธ๋ฐ,
์ด์™• ๋ฐฐ์šด๊ฒŒ ์žˆ์œผ๋‹ˆ, ํ•œ๋ฒˆ ์‹œ๋„ํ•ด๋ณด๋ฉด ์žฌ๋ฐŒ์„ ๋“ฏ ํ•˜๋‹ค.

๋‚ ์งœ ํ‘œ์‹œ ์ด์Šˆ

image
์˜ค๋Š˜๋‚ ์งœ๊ฐ€ ํ‘œ์‹œ๋˜์ง€์•Š๊ณ  ์–ด์ œ ๋‚ ์งœ๊ฐ€ ํ‘œ์‹œ๋˜์„œ ๋งˆ์น˜ ๋ฐ์ดํ„ฐ๊ฐ€ ํ•˜๋ฃจ ๋ˆ„๋ฝ๋œ๋“ฏํ•œ ํšจ๊ณผ๋ฅผ ์ฃผ๋Š”...

(DB ์—…๋ฐ์ดํŠธ๋Š” ๋ฌธ์ œ ์—†์Œ, ๋””์ž์ธ์  ์ด์Šˆ)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.