๐Ÿš€ Languege 39

[MySQL 8.0] CentOS7์— MySQL 8.0์„ค์น˜ํ•˜๊ธฐ

์•ˆ๋…•ํ•˜์„ธ์š” ๐Ÿ™‹‍โ™€๏ธ ๐Ÿ™‹‍โ™‚๏ธ !!! ์ด๋ฒˆ ํฌ์ŠคํŒ…์—์„œ๋Š” mysql 8.0 ๋ฒ„์ „์„ ์„ค์น˜ํ•ด๋ณด๋ ค๊ณ  ํ•ฉ๋‹ˆ๋‹ค ;) ์ €๋Š” AmazonEC2 CentOS7์„ ์‚ฌ์šฉํ–ˆ์Šต๋‹ˆ๋‹ค!!! 1. MySQL ์„ค์น˜ ๋‹ค์šด๋กœ๋“œ ๋งํฌ ํ™•์ธ MySQL Commucity ๋ฒ„์ „์œผ๋กœ ๋‹ค์šด๋ฐ›๊ธฐ ์œ„ํ•ด์„œ ์•„๋ž˜ ๋งํฌ๋กœ ์ ‘์†ํ•˜์„ธ์š”! ์„ค์น˜ ์‹œ์ ์— ๋”ฐ๋ผ ์ตœ์‹  ๋ฒ„์ „์ด ๋‹ค๋ฅด๋ฏ€๋กœ ์„ค์น˜ํ•˜์‹ค๋•Œ ์•„๋ž˜ ์ˆœ์„œ์— ๋”ฐ๋ผ ์„ค์น˜ ๋งํฌ๋ฅผ ๋ฐ›์•„์ฃผ์‹œ๋Š”๊ฒŒ ์ข‹์•„์š” :) www.mysql.com/products/community/ MySQL :: MySQL Community Edition MySQL Community Edition MySQL Community Edition is the freely downloadable version of the world's most popular open..

[Django #5] ๊ด€๋ฆฌ ํŽ˜์ด์ง€ ์ ‘์†ํ•˜๊ธฐ!

์ด๋ฒˆ ๋‹จ๊ณ„์—์„œ๋Š” ๊ด€๋ฆฌํŽ˜์ด์ง€์— ์ ‘์†ํ•ด์„œ ์ด๊ฒƒ์ €๊ฒƒ ๋ˆŒ๋Ÿฌ๋ณด๊ณ  ํ…Œ์ŠคํŠธ ํ•ด๋ณด๊ฒ ์Šต๋‹ˆ๋‹ค :) ์ด ์•ž์˜ ํฌ์ŠคํŒ…๋ณด๋‹ค๋Š” ์กฐ๊ธˆ ์‰ฌ์šธ๊ฑฐ์—์š”! ์ž! ์‹œ์ž‘ํ•ด๋ด…์‹œ๋‹ค.!! 1. admin.py์— first_app ๋“ฑ๋กํ•˜๊ธฐ ๊ด€๋ฆฌํŽ˜์ด์ง€๋Š” ์ด๋ฒˆ ๋‹จ๊ณ„์—†์ด ๋ฐ”๋กœ ๋‹ค์Œ๋‹จ๊ณ„๋กœ ๋„˜์–ด๊ฐ€๋„ ์‚ฌ์šฉ ๊ฐ€๋Šฅํ•ฉ๋‹ˆ๋‹ค. ํ•˜์ง€๋งŒ first_app ์ด ๋ณด์ด์ง€ ์•Š์„๊ฑฐ์—์š” ๐Ÿ˜ญ ์ด๋ฒˆ ๋‹จ๊ณ„์—์„œ first_app์„ ๊ด€๋ฆฌ ์›นํŽ˜์ด์ง€์—์„œ๋„ ์ˆ˜์ •ํ•  ์ˆ˜ ์žˆ๋„๋ก first_app/admin.pyํŒŒ์ผ์„ ์ˆ˜์ •ํ•ฉ๋‹ˆ๋‹ค :) first_app/admin.py๋ฅผ ์ˆ˜์ •ํ•˜์—ฌ ์•„๋ž˜ ์ฝ”๋“œ๋ฅผ ๋ณต์‚ฌ ๋ถ™์—ฌ๋„ฃ๊ธฐ ํ•ฉ๋‹ˆ๋‹ค. from django.contrib import admin from .models import Question from .models import Choice admin.site.registe..

[Django #4] Database ๊ตฌ์„ฑํ•˜๊ธฐ

์ด๋ฒˆ ๋‹จ๊ณ„์—์„œ๋Š” ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค๋ฅผ ์„ค์น˜ํ•˜๊ณ  ๋ชจ๋ธ์„ ์ •์˜/์ƒ์„ฑํ•ฉ๋‹ˆ๋‹ค. ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ์„ค์ • ํŒŒ์ผ์ธ mysite/settings.py๋ฅผ ํ™•์ธํ•ด๋ด…๋‹ˆ๋‹ค :) Django์—์„œ ๊ธฐ๋ณธ์ ์œผ๋กœ ์ œ๊ณตํ•˜๋Š” SQLite๋ฅผ ์‚ฌ์šฉํ•˜์—ฌ ์‹ค์Šต์„ ์ง„ํ–‰ํ•˜์ง€๋งŒ, ์‹ค ์šด์˜ ํ™˜๊ฒฝ์—์„œ๋Š” postgresql๊ณผ ๊ฐ™์€ ์•ˆ์ •์ ์ธ ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค๋ฅผ ์ฒ˜์Œ๋ถ€ํ„ฐ ์‚ฌ์šฉํ•˜๋Š”๊ฒƒ์„ ๊ถŒ์žฅํ•ฉ๋‹ˆ๋‹ค. ์ด์ œ ์ง„ํ–‰ํ•ด๋ด…์‹œ๋‹ค ๊ณ ๊ณ !!๐Ÿง‘‍๐Ÿ’ป๐Ÿ‘ฉ‍๐Ÿ’ป 1. ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ๋งŒ๋“ค๊ธฐ ๋จผ์ €, mysite/settings.py ํŒŒ์ผ์„ ์‚ดํŽด๋ด…์‹œ๋‹ค! ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ์—ฐ๊ฒฐ ์ •๋ณด๊ฐ€ ๋“ค์–ด์žˆ์Šต๋‹ˆ๋‹ค. ๋‹ค๋ฅธ ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค๋ฅผ ์‚ฌ์šฉํ•˜์‹ ๋‹ค๋ฉด ์—ฌ๊ธฐ๋ฅผ ์ฐธ์กฐํ•˜์„ธ์š”. ์ง€๊ธˆ์€ ๊ธฐ๋ณธ์ ์ธ ๋™์ž‘ ๋ฉ”์ปค๋‹ˆ์ฆ˜๋งŒ ์‚ดํŽด๋ณผ ์˜ˆ์ •์ด๋ฏ€๋กœ ๊ธฐ๋ณธ์œผ๋กœ ์ œ๊ณต๋˜๋Š” SQLite๋ฅผ ์‚ฌ์šฉํ•ฉ๋‹ˆ๋‹ค :) Language_code์™€ Time_zone์„ ์•Œ๋งž๊ฒŒ ๋ฐ”๊ฟ”์ค์‹œ๋‹ค. ;) L..

[Django #3] WebApp ์„ค์น˜ & ๊ตฌ์„ฑํ•˜๊ธฐ

์ด๋ฒˆ ํฌ์ŠคํŒ…์—์„œ๋Š” WebApp์„ ๊ตฌ์„ฑํ•ด๋ณด๋„๋ก ํ•˜๊ฒ ์Šต๋‹ˆ๋‹ค :) ์—ฌ๊ธฐ ๋‚˜์˜ค๋Š” ๋ชจ๋“  ๋‹จ๊ณ„๋Š” Django ๊ณต์‹ํ™ˆํŽ˜์ด์ง€์— ๋‚˜์™€์žˆ์Šต๋‹ˆ๋‹ค. ์ด ํฌ์ŠคํŒ…์—์„œ๋Š” ๊ฐ ๋‹จ๊ณ„๋ฅผ ์กฐ๊ธˆ ๋” ์ž์„ธํžˆ ์„ค๋ช…ํ•  ์˜ˆ์ •์ž…๋‹ˆ๋‹ค. ์ž ์•ž ํฌ์ŠคํŒ…๊นŒ์ง€ ์ง„ํ–‰ ํ•˜์…จ๋‹ค๋ฉด, ํ˜„์žฌ ๋””๋ ‰ํ† ๋ฆฌ ๊ตฌ์กฐ๋Š” ์ด๋ ‡๊ฒŒ ๋ณด์ผ๊ฒ๋‹ˆ๋‹ค. ๊ฐ ๋””๋ ‰ํ† ๋ฆฌ์™€ ํŒŒ์ผ๋“ค์€ ๊ฐ์ž ์—ญํ• ์ด ์ •ํ•ด์ ธ ์žˆ์Šต๋‹ˆ๋‹ค. ๋งˆ์ง€๋ง‰ ๋ถ€๋ถ„์—์„œ ๋‹ค์‹œํ•œ๋ฒˆ ์ž์„ธํžˆ ์„ค๋ช… ํ•  ์˜ˆ์ •์ด๋‹ˆ ์ผ๋‹จ ์‹ค์Šต๋ถ€ํ„ฐ ์ง„ํ–‰ํ•ด๋ด…์‹œ๋‹ค! ์›น์•ฑ์„ ์„ค์น˜ํ•ด๋ณด๋„๋ก ํ•˜๊ฒ ์Šต๋‹ˆ๋‹ค!! 1. Web App ๋งŒ๋“ค์ž! ์•„๋ž˜ ๋ช…๋ น์–ด๋กœ app์„ ๋งŒ๋“ค์–ด์ค๋‹ˆ๋‹ค. python manage.py startapp first_app ๋ช…๋ น์–ด๋ฅผ ์‹คํ–‰ ํ–ˆ๋‹ค๋ฉด, ์•„๋ž˜ ์บก์ณ ์‚ฌ์ง„์ฒ˜๋Ÿผ, first_app ๋””๋ ‰ํ„ฐ๋ฆฌ๊ฐ€ ์ƒ๊ธฐ๊ณ , ๊ทธ ์•ˆ์— ์—ฌ๋Ÿฌ ํŒŒ์ด์ฌ ํŒŒ์ผ์ด ์กด์žฌํ•˜๊ฒŒ ๋ฉ๋‹ˆ๋‹ค. 2. index ํŽ˜์ด์ง€..

[Django #2] Django ์„ค์น˜ํ•˜๊ธฐ - MAC

์•ˆ๋…•ํ•˜์„ธ์š” ๐Ÿ™‹‍โ™€๏ธ ๐Ÿ™‹‍โ™‚๏ธ ์ด๋ฒˆ ํฌ์ŠคํŒ…์—์„œ๋Š” MAC OS์— Django๋ฅผ ์„ค์น˜ํ•˜๊ณ  ๊ธฐ๋ณธ ํŽ˜์ด์ง€๋ฅผ ๋„์›Œ ๋ณผ ์˜ˆ์ •์ž…๋‹ˆ๋‹ค. ์ œ๊ฐ€ ํ…Œ์ŠคํŠธ ํ•˜๋Š” MAC OS ๋ฒ„์ „์€ BigSur (ver 11.1)์ž…๋‹ˆ๋‹ค :) 1. Xcode ์„ค์น˜ํ•˜๊ธฐ ๋”๋ณด๊ธฐ Xcode๋Š” ์• ํ”Œ ๊ณต์‹์• ๋””ํ„ฐ๋กœ C์ปดํŒŒ์ผ๋Ÿฌ๋ฅผ ํฌํ•จํ•ฉ๋‹ˆ๋‹ค. Mac AppStore ์—์„œ Xcode๋ฅผ ์„ค์น˜ํ•ฉ๋‹ˆ๋‹ค :) 2. Homebrew ์„ค์น˜ํ•˜๊ธฐ ๋”๋ณด๊ธฐ Homebrew ์„ค์น˜๋Š” ๊ณต์‹ ํ™ˆํŽ˜์ด์ง€๋ฅผ ์ฐธ๊ณ ํ•˜์‹œ๋Š”๊ฒŒ ์ œ์ผ ์ •ํ™•ํ•ฉ๋‹ˆ๋‹ค :) ํ„ฐ๋„์„ ์ผœ๊ณ  ๋ช…๋ ์–ด๋ฅผ ๋ถ™์—ฌ ๋„ฃ์œผ์„ธ์š”! /bin/bash -c "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/HEAD/install.sh)" ์„ค์น˜๊ฐ€ ์™„๋ฃŒ ๋˜์—ˆ๋‹ค๋ฉด, ์„ค์น˜๊ฐ€ ์ž˜ ๋˜์—ˆ๋Š”์ง€ ํ™•์ธ..

[Django #2] Django ์„ค์น˜ํ•˜๊ธฐ -EC2 - Amazon Linux2

์•ˆ๋…•ํ•˜์„ธ์š” ๐Ÿ™‹‍โ™€๏ธ ๐Ÿ™‹‍โ™‚๏ธ ์ด๋ฒˆ ํฌ์ŠคํŒ…์—์„œ๋Š” Amazon EC2 (Amazon Linux2)๋ฅผ ์ด์šฉํ•ด์„œ Django๋ฅผ ์„ค์น˜ํ•˜๊ณ  ๊ธฐ๋ณธ ํŽ˜์ด์ง€๋ฅผ ๋„์›Œ ๋ณผ ์˜ˆ์ •์ž…๋‹ˆ๋‹ค. Amazon EC2 ํ”„๋ฆฌํ‹ฐ์–ด๋กœ๋„ ์‚ฌ์šฉ์ด ๊ฐ€๋Šฅํ•ฉ๋‹ˆ๋‹ค. ํ•˜์ง€๋งŒ, ์ด๋ฒˆ ํฌ์ŠคํŒ…์—์„œ๋Š” Amazon EC2๋ฅผ ์ƒ์„ฑํ•˜๋Š” ๋ฐฉ๋ฒ•์— ๋Œ€ํ•ด ๋ณ„๋„๋กœ ๋‹ค๋ฃจ์ง€ ์•Š์Šต๋‹ˆ๋‹ค! ์•„๋ž˜ ์บก์ณ ์‚ฌ์ง„๊ณผ ๊ฐ™์ด, ์ด๋ฏธ ํ…Œ์ŠคํŠธ ์šฉ๋„์˜ EC2๋ฅผ ์ƒ์„ฑํ–ˆ์œผ๋ฉฐ, SSH ์ ‘์†์ด ๊ฐ€๋Šฅํ•˜๋„๋ก ๊ตฌ์„ฑ์ด ๋˜์–ด์žˆ๋‹ค!๊ณ  ๊ฐ€์ •ํ•˜๊ณ  ์‹œ์ž‘ํ•ฉ๋‹ˆ๋‹ค. โ— Django ํ”„๋ ˆ์ž„์›Œํฌ ์„ค์น˜ ๋”๋ณด๊ธฐ Django๋Š” Python ์›น ํ”„๋ ˆ์ž„์›Œํฌ ์ž…๋‹ˆ๋‹ค. Django๋ฅผ ์‚ฌ์šฉํ•˜๋ ค๋ฉด ๊ธฐ๋ณธ์ ์œผ๋กœ Python์ด ์„ค์น˜๋˜์–ด์žˆ์–ด์•ผ ํ•ฉ๋‹ˆ๋‹ค :) 2021-01-12(ํ™”) ์˜ค๋Š˜ ๊ธฐ์ค€์œผ๋กœ Djaogo 3.1์„ ์‚ฌ์šฉํ•˜๊ธฐ ์œ„ํ•ด์„œ๋Š” Python 3.6, 3..

[Django #1] Django๋ž€ ๋ฌด์—‡์ธ๊ฐ€, ๊ธฐ๋ณธ ๊ฐœ๋… ์ตํžˆ๊ธฐ

์•ˆ๋…•ํ•˜์„ธ์š”!๐Ÿ™‹๐Ÿ™‹‍โ™€๏ธ ์ดˆ๋ณด๋ฅผ ์œ„ํ•œ (์ฆ‰, ๋‚˜ ์Šค์Šค๋กœ๋ฅผ ์œ„ํ•œ..ใ… ใ… ) Django!! ์‹œ๋ฆฌ์ฆˆ๋ฅผ ํฌ์ŠคํŒ… ํ•˜๋ ค๊ณ  ํ•ฉ๋‹ˆ๋‹ค! ๋จผ์ € ์ด ์‹œ๋ฆฌ์ฆˆ๋ฅผ ์‹œ์ž‘ํ•˜๊ธฐ ์ „์—, ๊ฐœ๋…๋ถ€ํ„ฐ ํ•˜๋‚˜์”ฉ ์ดํ•ดํ•ด ๋ณด๋ ค๊ณ  ํ•ฉ๋‹ˆ๋‹ค. Django๋ž€? Django ๊ณต์‹ํ™ˆํŽ˜์ด์ง€์—์„œ๋„ ์•„๋ž˜์™€ ๊ฐ™์€ ๋‚ด์šฉ์„ ํ™•์ธํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค. ํ•œ๋งˆ๋””๋กœ, Python ์›น ์–ดํ”Œ๋ฆฌ์ผ€์ด์…˜ ํ”„๋ ˆ์ž„ ์›Œํฌ ์ž…๋‹ˆ๋‹ค. ๋‹ค๋ฅธ ํ”„๋ ˆ์ž„์›Œํฌ์— ๋น„ํ•ด ์‚ฌ์šฉํ•˜๊ธฐ ์‰ฝ๊ธฐ ๋•Œ๋ฌธ์— ์ธ๊ธฐ๊ฐ€ ๋งŽ๊ณ  Python ์„ ๊ธฐ๋ฐ˜์œผ๋กœ ํ•˜๊ธฐ๋•Œ๋ฌธ์— Python์„ ์ž˜ ์•Œ๊ณ ์žˆ๋Š” ์‚ฌ๋žŒ์—๊ฒŒ๋Š” ์‰ฝ๊ฒŒ ์‹œ์ž‘ํ•  ์ˆ˜ ์žˆ๊ฒ ์ฃ ! (Python ์–ธ์–ด ์ž์ฒด๋„ ์ดˆ๋ณด์ž๊ฐ€ ๋ฐฐ์šฐ๊ธฐ๋Š” ์‰ฝ์Šต๋‹ˆ๋‹ค.) Django๋Š” ๋™์  ์›น์‚ฌ์ดํŠธ๋ฅผ ์œ„ํ•œ ํ”„๋ ˆ์ž„์›Œํฌ์ž…๋‹ˆ๋‹ค. ๋™์  ์›น์‚ฌ์ดํŠธ๋ž€, ์‚ฌ์šฉ์ž์™€์˜ ์ธํ„ฐ๋ ‰์…˜์ด ๋ฒ ์ด์Šค์ด๊ธฐ ๋•Œ๋ฌธ์— ์‚ฌ์šฉ์žUI, ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ๊ตฌ์„ฑ์ด ํ•„์ˆ˜์ ์ž…๋‹ˆ๋‹ค. ํŠนํžˆ..

HTTP Request Parameters ํƒ€์ž… / HTTP ์š”์ฒญ ํŒŒ๋ผ๋ฉ”ํ„ฐ ์ข…๋ฅ˜!

HTTP Request ํŒŒ๋ผ๋ฉ”ํ„ฐ์˜ ์ข…๋ฅ˜ ๐Ÿ˜ 1. Path ํŒŒ๋ผ๋ฉ”ํ„ฐ URL path ๊ฒฝ๋กœ์˜ ์ผ๋ถ€๋กœ ํŒŒ๋ผ๋ฉ”ํ„ฐ๋ฅผ ์‚ฌ์šฉํ•ฉ๋‹ˆ๋‹ค. www.example.info/user/{user-name}/score 2. ≈ URL ? ๋’ค์— ๋“ฑ์žฅํ•ฉ๋‹ˆ๋‹ค. ์ด๋ ‡๊ฒŒ ์ •์˜๋˜๋Š” ๊ฒฝ์šฐ AWS CloudFront+Lambda ์—ฃ์ง€ ์‚ฌ์šฉ ๊ฐ€๋Šฅํ•ฉ๋‹ˆ๋‹ค. www.example.info/user?user-name=A 3. Request Body ํŒŒ๋ผ๋ฉ”ํ„ฐ Post ๋ฐฉ์‹์˜ Request Parameter์ด๋ฉฐ, ์š”์ฒญ ๋‚ด์šฉ์„ ๋ฐ”๋””์— ๋„ฃ์–ด ๋ณด๋‚ด๊ธฐ๋•Œ๋ฌธ์— URL์—์„œ๋Š” ์•„๋ฌด๋Ÿฐ ๋ณ€ํ™”๊ฐ€ ์—†์Šต๋‹ˆ๋‹ค. 4. Header ํŒŒ๋ผ๋ฉ”ํ„ฐ ์ธ์ฆ๊ณผ ๊ถŒํ•œ๋ถ€์—ฌ ๋ชฉ์ ์œผ๋กœ ์‚ฌ์šฉํ•ฉ๋‹ˆ๋‹ค. ์ธ์ฆ๊ณผ ๊ด€๋ จ๋œ ์„œ๋น„์Šค์—์„œ ํ—ค๋” ํŒŒ๋ผ๋ฉ”ํ„ฐ์— ๋Œ€ํ•œ ๋‚ด์šฉ์„ ๋ณผ ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค :D

python - numpy(13) ํ†ต๊ณ„

import numpy as np print('*'*100) print('1์ฐจ์› ๋ฐฐ์—ด') print('-'*20) x = np.array([1, 2, 3, 4]) print(x) print('-'*20) #ํ•ฉ๊ณ„ print('ํ•ฉ๊ณ„:', np.sum(x)) print('ํ•ฉ๊ณ„:', x.sum()) #์ตœ์†Œ๊ฐ’, ์ตœ๋Œ€๊ฐ’ print('์ตœ์†Œ๊ฐ’:', x.min(), '์ตœ๋Œ€๊ฐ’:', x.max()) # ์ตœ์†Œ๊ฐ’, ์ตœ๋Œ€๊ฐ’ print('์ตœ์†Œ๊ฐ’์˜ ์œ„์น˜:', x.argmin(),'์ตœ๋Œ€๊ฐ’์˜ ์œ„์น˜:', x.argmax()) # ์ตœ์†Œ๊ฐ’์˜ ์œ„์น˜, ์ตœ๋Œ€๊ฐ’์˜ ์œ„์น˜ #๋ฐฑํ„ฐ๊ฐ’์˜ ํ‰๊ท  print('๋ฐฑํ„ฐ๊ฐ’์˜ ํ‰๊ท :', x.mean()) #๋ฐฑํ„ฐ์˜ ์ค‘์•™๊ฐ’ print('๋ฐฑํ„ฐ์˜ ์ค‘์•™๊ฐ’:', np.median(x)) # ๊ฐ€์˜จ๋ฐ ๋‘๊ฐœ๊ฐ’ ๋”ํ•ด์„œ ํ‰๊ท  print(..

python - numpy(12) ๋ฐฑํ„ฐํ™” ์—ฐ์‚ฐ

๋ฐฑํ„ฐํ™” ์—ฐ์‚ฐ ์†๋„ ์ธก์ •! import numpy as np x = np.arange(1, 10001) y = np.arange(10001,20001) z = np.zeros_like(x) for i in range(10000): z[i] = x[1]+y[i] print(z) z=x+y print(z) # ================================== # ์†๋„ ์ธก์ • def runTime1(): import timeit start = timeit.default_timer() for i in range(10000): z[i] = x[1] + y[i] end = timeit.default_timer() print('sum vector:', (end-start)) def runTime2(): im..

728x90