IT Talks 97

ChatGPT ๊ฐ€ ์ถ”์ฒœํ•˜๋Š” ๊ฐœ๋ฐœ์ž ์ปค๋ฆฌ์–ด

Q. Please recommend a career as a software developer. A. A career as a software developer can be a very rewarding and fulfilling choice. Here are some reasons why: 1. High demand: Software development is a rapidly growing field with a high demand for skilled professionals. This means that there are many job opportunities available and the demand for software developers is expected to continue to..

IT Talks/AI 2023.02.13

๋น„๋ฐ€๋ฒˆํ˜ธ ์ž…๋ ฅ ์—†์ด MySQL ์ ‘์†ํ•˜๊ธฐ

MySQL ๋ฒ„์ „์ด ์ ์  ์˜ฌ๋ผ๊ฐ€๋ฉด์„œ ์–ธ์ œ๋ถ€ํ„ฐ์ธ๊ฐ€ mysql ๋ช…๋ น์–ด๋กœ ์ ‘์†์‹œ ๋น„๋ฐ€๋ฒˆํ˜ธ๋ฅผ ๊ฐ™์ด ์ž…๋ ฅํ•˜๋ฉด ์•„๋ž˜์™€ ๊ฐ™์ด ์•ˆ์ „ํ•˜์ง€ ์•Š๋‹ค๋Š” ๊ฒฝ๊ณ ๊ฐ€ ๋‚˜์˜จ๋‹ค. $ mysql -hlocalhost -udb_user -pdb_password mysql: [Warning] Using a password on the command line interface can be insecure. ์‰˜ ์Šคํฌ๋ฆฝํŠธ๋กœ DB ์ ‘์†ํ•˜๋Š” ์ž‘์—…์„ ํ•˜๋Š” ๊ฒฝ์šฐ ์œ„์™€ ๊ฐ™์ด ๋ช…๋ น์–ด์— ๋น„๋ฐ€๋ฒˆํ˜ธ๊นŒ์ง€ ๊ฐ™์ด ์ž…๋ ฅํ•˜๋Š” ๊ฒฝ์šฐ๊ฐ€ ๋งŽ์€๋ฐ ์‹คํ–‰์€ ๋˜์ง€๋งŒ ๊ฒฝ๊ณ ๊ฐ€ ๋‚˜์˜ค๋Š”๊ฒŒ ๋งค์šฐ ๊ฑฐ์Šฌ๋ฆฐ๋‹ค. ์ด๋Ÿฐ ๊ฒฝ์šฐ๋Š” ์•„๋ž˜ 2๊ฐ€์ง€ ๋ฐฉ๋ฒ•์œผ๋กœ ํ•ด๊ฒฐ์ด ๊ฐ€๋Šฅํ•˜๋‹ค. ๋ฐฉ๋ฒ•1) ๊ณ„์ • home path (๋ฆฌ๋ˆ…์Šค ๊ธฐ์ค€ /home/userid ๋“ฑ) ์— .my.cnf ํŒŒ์ผ์„ ์ƒ์„ฑํ•˜๊ณ  ์•„๋ž˜์™€ ๊ฐ™์ด ๋‚ด์šฉ์„ ์ž…๋ ฅํ•œ๋‹ค. ..

IT Talks/Database 2023.02.09

Data Scientist vs Engineer vs Analyst

์˜ˆ์ „์— ์ธํ„ฐ๋„ท์—์„œ ๋ดค๋˜ ์ด๋ฏธ์ง€ ์ธ๋ฐ, ๋ฐ์ดํ„ฐ ๊ด€๋ จ ์ง๋ฌด์— ๋Œ€ํ•ด ์ •๋ฆฌ๊ฐ€ ์ž˜ ์•ˆ๋˜๋Š” ๊ฒฝ์šฐ๊ฐ€ ๋งŽ์•„์„œ ์ฐธ๊ณ ํ•˜๋ฉด ์ข‹์„ ๊ฒƒ ๊ฐ™๋‹ค. (ํ˜„์‹ค์€ ๊ทธ๋ ‡์ง€ ์•Š์ง€๋งŒ) Data Scientist ํ†ต๊ณ„๋‚˜ ๋จธ์‹  ๋Ÿฌ๋‹์„ ์ด์šฉํ•ด ์ฃผ์š” ๋น„์ฆˆ๋‹ˆ์Šค ์งˆ๋ฌธ์— ๋Œ€ํ•œ ์˜ˆ์ธก๊ณผ ๋‹ต๋ณ€์„ ๋งŒ๋“ฆ. Data Engineer ๋ฐ์ดํ„ฐ ๊ณผํ•™์ž์™€ ๋ถ„์„๊ฐ€๊ฐ€ ์ž‘์—…์„ ์ˆ˜ํ–‰ํ•  ์ˆ˜ ์žˆ๋Š” ์‹œ์Šคํ…œ์„ ๊ตฌ์ถ•ํ•˜๊ณ  ์ตœ์ ํ™”. Data Analyst ๋ฐ์ดํ„ฐ๋ฅผ ํ™œ์šฉํ•˜์—ฌ ๋น„์ฆˆ๋‹ˆ์Šค ์˜์‚ฌ ๊ฒฐ์ •์— ๋„์›€์ด ๋˜๋Š” ๊ฒฐ๊ณผ๋ฅผ ์ „๋‹ฌํ•จ์œผ๋กœ์จ ๊ฐ€์น˜๋ฅผ ์ œ๊ณต. (์ฐธ๊ณ ) ๋ฐ์ดํ„ฐ ์ง๋ฌด๋ณ„ ์Šคํ‚ฌ ๋ฐ์ดํ„ฐ ์ง๋ฌด๋ณ„ ์Šคํ‚ฌ - Types of Data Professionals ์ „์— ๋ฐ์ดํ„ฐ ์ง๋ฌด๋ณ„ ํ•˜๋Š”์ผ์— ๋Œ€ํ•œ ํฌ์ŠคํŒ…์„ ์˜ฌ๋ฆฐ ์ ์ด ์žˆ์—ˆ๋Š”๋ฐ (์•„๋ž˜ ๊ธ€ ์ฐธ๊ณ ) ์ด๋ฒˆ์—๋Š” ๊ฐ ๋ฐ์ดํ„ฐ ์ง๋ฌด๋ณ„ ์ฃผ์š” ์—…๋ฌด์— ๋Œ€ํ•ด ์ฐจํŠธ ํ˜•ํƒœ๋กœ ๋œ ๊ทธ๋ฆผ์ด ์žˆ์–ด์„œ..

IT Talks/BigData 2022.10.06

๋„ค์ด๋ฒ„ ๋ธ”๋กœ๊ทธ ์ฃผ์†Œ ๋ณ€๊ฒฝ ๊ธฐ๋Šฅ ์ถœ์‹œ

๋„ค์ด๋ฒ„ ๋ธ”๋กœ๊ทธ๋Š” ์„œ๋น„์Šค ์ถœ์‹œ๋•Œ ๋ถ€ํ„ฐ ๋„ค์ด๋ฒ„ID๋ฅผ ๊ทธ๋Œ€๋กœ ์‚ฌ์šฉํ•ด์•ผ ํ•˜๋Š” ๋ฐฉ์‹์ด์—ฌ์„œ ์ŠคํŒธ ๋ฉ”์ผ์ด๋‚˜ ๊ฐœ์ธ์ •๋ณด ๋…ธ์ถœ ๊ด€๋ จ ์ด์Šˆ๊ฐ€ ๊ณ„์† ์žˆ์—ˆ๋‹ค. ๋น„์Šทํ•œ ์ด์Šˆ๋กœ, ๋„ค์ด๋ฒ„์นดํŽ˜ ํšŒ์› ๋ชฉ๋ก์—์„œ ๋„ค์ด๋ฒ„ID๊ฐ€ ๋…ธ์ถœ๋˜์–ด, ํšŒ์› ๋ชฉ๋ก์„ ์ˆ˜์ง‘ํ•  ์ˆ˜ ์žˆ์—ˆ์œผ๋‚˜ ID ๋ถ€๋ถ„์„ ์•”ํ˜ธํ™” ํ•˜์—ฌ ํšŒํ”ผ(?)ํ•˜๋Š” ๋ฐฉ์‹์„ ์ ์šฉํ–ˆ์—ˆ๋Š”๋ฐ, ์˜ค๋Š˜ ๋„ค์ด๋ฒ„ ๋ธ”๋กœ๊ทธ ๊ณต์ง€ ๋ฉ”์ผ์„ ๋ณด๋‹ˆ ๋ธ”๋กœ๊ทธ์—์„œ ์ฃผ์†Œ๋กœ ์‚ฌ์šฉ๋˜๋Š” ๋„ค์ด๋ฒ„ID ๋ถ€๋ถ„์„ ๋ณ€๊ฒฝํ•˜๋Š” ๊ธฐ๋Šฅ์ด ์ถœ์‹œ๋œ๋‹ค๋Š” ๋‚ด์šฉ์ด์—ˆ๋‹ค. 10์›”12์ผ๋ถ€ํ„ฐ ๋ณ€๊ฒฝ ๊ฐ€๋Šฅํ•˜๋‹ค๋‹ˆ ๊ธฐ์กด์— ๋„ค์ด๋ฒ„ID๊ฐ€ ๋ธ”๋กœ๊ทธ ์ฃผ์†Œ์— ๊ทธ๋Œ€๋กœ ๋…ธ์ถœ๋˜๋Š”๊ฑธ ๊บผ๋ฆฌ์…จ๋˜ ๋ถ„๋“ค์€ ์ด๋ฒˆ์— ๋ฐ”๊ฟ”๋ณด์‹œ๋Š”๊ฒƒ๋„ ์ข‹์„ ๊ฒƒ ๊ฐ™๋‹ค. ๋„ค์ด๋ฒ„๋ฅผ ์‚ฌ์šฉํ•˜๋Š” ํšŒ์›์ด ๋งŽ๋‹ค ๋ณด๋‹ˆ ๊ฐœ์ธ์ •๋ณด ๊ด€๋ จ ์ด์Šˆ๋„ ๋งŽ์•„์„œ ์ด์™€ ๊ด€๋ จ๋œ ๊ฐœ์„  ์ž‘์—…์„ ๊ณ„์† ํ•˜๋Š”๊ฒƒ ๊ฐ™๊ธด ํ•œ๋ฐ ์ข€ ์˜ค๋ž˜ ๊ฑธ๋ฆฌ๋Š”๊ฒƒ ๊ฐ™๊ธฐ๋„ ^^ ๋ธ”๋กœ๊ทธ์—์„œ ์•Œ๋ ค๋“œ..

IT Talks 2022.09.30

Python3 ๊ฐ€์ƒ ํ™˜๊ฒฝ ์ƒ์„ฑ

venv ๋ชจ๋“ˆ์€ ์ž์ฒด ์‚ฌ์ดํŠธ ๋””๋ ‰ํ„ฐ๋ฆฌ๋ฅผ ๊ฐ–๋Š” ๊ฒฝ๋Ÿ‰ โ€œ๊ฐ€์ƒ ํ™˜๊ฒฝโ€์„ ๋งŒ๋“ค๊ณ , ์„ ํƒ์ ์œผ๋กœ ์‹œ์Šคํ…œ ์‚ฌ์ดํŠธ ๋””๋ ‰ํ„ฐ๋ฆฌ์—์„œ ๊ฒฉ๋ฆฌํ•  ์ˆ˜ ์žˆ๋„๋ก ์ง€์›ํ•ฉ๋‹ˆ๋‹ค. ๊ฐ ๊ฐ€์ƒ ํ™˜๊ฒฝ์€ ๊ณ ์œ ํ•œ ํŒŒ์ด์ฌ ๋ฐ”์ด๋„ˆ๋ฆฌ(์ด ํ™˜๊ฒฝ์„ ๋งŒ๋“œ๋Š” ๋ฐ ์‚ฌ์šฉ๋œ ๋ฐ”์ด๋„ˆ๋ฆฌ ๋ฒ„์ „๊ณผ ์ผ์น˜ํ•จ)๋ฅผ ๊ฐ€์ง€๋ฉฐ ์ž์‹ ์˜ ์‚ฌ์ดํŠธ ๋””๋ ‰ํ„ฐ๋ฆฌ์— ๋…๋ฆฝ์ ์œผ๋กœ ์„ค์น˜๋œ ํŒŒ์ด์ฌ ํŒจํ‚ค์ง€ ์ง‘ํ•ฉ์„ ๊ฐ€์งˆ ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค. ๊ฐ€์ƒํ™˜๊ฒฝ ์ƒ์„ฑ $ python3 -m venv /home/myhome/venv * ์ง€์ •ํ•œ ๋””๋ ‰ํ† ๋ฆฌ์— ๊ฐ€์ƒ ํ™˜๊ฒฝ ์ƒ์„ฑ (๋ฆฌ๋ˆ…์Šค ๊ธฐ์ค€) * ์‹คํ–‰ ํ›„ ์ด๋ž˜์™€ ๊ฐ™์€ ์˜ค๋ฅ˜๊ฐ€ ๋ฐœ์ƒํ•œ๋‹ค๋ฉด --without-pip ์˜ต์…˜์œผ๋กœ pip ๋Š” ๋ณ„๋„๋กœ ์„ค์น˜ํ•ด ์ค€๋‹ค. Error: Command '['/home/ojj/venv/bin/python3', '-Im', 'ensurepip', '--upgrade',..

IT Talks 2022.09.22

๋งฅ(Mac)์—์„œ ์นด์นด์˜คํ†ก ์•ฑ 2๊ฐœ ์‚ฌ์šฉํ•˜๊ธฐ

์นด์นด์˜คํ†ก์„ ํ•„์š”์— ๋”ฐ๋ผ 2๊ฐœ๋ฅผ ์‚ฌ์šฉํ•˜๋Š” ๋ถ„๋“ค๋„ ๋งŽ์ด ์žˆ์„ํ…๋ฐ, ์•ˆ๋“œ๋กœ์ด๋“œํฐ์˜ ๊ฒฝ์šฐ์—๋Š” ๋“€์–ผ ๋ฉ”์‹ ์ € ๊ธฐ๋Šฅ์œผ๋กœ ์นด์นด์˜คํ†ก, ๋ผ์ธ, ํŽ˜์ด์Šค๋ถ๋ฉ”์‹ ์ € ๋“ฑ๋“ฑ์„ 2๊ฐœ ์‚ฌ์šฉํ•  ์ˆ˜ ์žˆ๋‹ค. (์•ˆ๋“œ๋กœ์ด๋“œ 7.0 ๋ถ€ํ„ฐ ์ƒ๊ฒผ๋‹ค๊ณ  ํ•จ) ์• ํ”Œ PC (๋งฅ, Mac)์—์„œ๋„ ์นด์นด์˜คํ†ก์•ฑ์„ ์„ค์น˜ํ•ด์„œ ์‚ฌ์šฉํ•˜๊ณ  ์žˆ๋Š”๋ฐ, ๋ชจ๋ฐ”์ผ์— ์žˆ๋Š” 2๊ฐœ์˜ ์นดํ†ก์„ PC์—์„œ๋„ ๋™์‹œ์— ์‹คํ–‰์ด ๊ฐ€๋Šฅํ• ์ง€ ์ฐพ์•„๋ณด๋‹ค๊ฐ€ ์ฐพ์€ ๋ฐฉ๋ฒ•์œผ๋กœ ๊ฐ„๋‹จํžˆ ์Šคํฌ๋ฆฝํŠธ๋ฅผ ๋งŒ๋“ค์—ˆ๋‹ค. App Store ์—์„œ ์นด์นด์˜คํ†ก์„ ์„ค์น˜ํ•œ ํ›„์— ์•„๋ž˜ ์Šคํฌ๋ฆฝํŠธ๋ฅผ ์‹คํ–‰ํ•˜๋ฉด, KakaoTalk2 ๋ผ๋Š” ์•ฑ์œผ๋กœ ๋ณต์‚ฌํ•ด์„œ 2๊ฐœ๋ฅผ ๋”ฐ๋กœ ์‹คํ–‰ํ•  ์ˆ˜ ์žˆ๋„๋ก ํ•œ๋‹ค. * ์†Œ์Šค : https://github.com/okojj/utils/blob/main/kakao-talk/copy-kakaotalk-app-mac.sh #!/bin..

IT Talks 2022.09.06

OpenVPN Server ์„ค์น˜ํ•˜๊ธฐ

์ˆœ์„œ ๊ณต์ธ IP ํ™•์ธ openvpn-install.sh ๋‹ค์šด๋ฐ›๊ธฐ openvpn-install.sh ์‹คํ–‰ํ•ด์„œ OpenVPN ์„œ๋ฒ„ ์„ค์น˜ํ•˜๊ธฐ ๊ฐ OS ๋ณ„ Client ๋ฅผ ์ด์šฉํ•ด OpenVPN ์„œ๋ฒ„์— ์—ฐ๊ฒฐํ•˜๊ธฐ ์—ฐ๊ฒฐ ํ™•์ธ 1. ๊ณต์ธ IP ํ™•์ธ ์„œ๋ฒ„์— ๋”ฐ๋ผ ๊ณต์ธ IP๊ฐ€ ์ง์ ‘ ์—ฐ๊ฒฐ๋œ ๊ฒฝ์šฐ๋„ ์žˆ๊ณ , NAT ์•„๋ž˜์— ์œ„์น˜ํ•˜์—ฌ ์‚ฌ์„ค IP๋งŒ ์žˆ๋Š” ๊ฒฝ์šฐ๋„ ์žˆ์–ด ์•„๋ž˜ ๋ช…๋ น์–ด๋ฅผ ํ†ตํ•ด ๋Œ€๋ถ€๋ถ„์˜ ์ผ€์ด์Šค์— ๋Œ€ํ•ด ๊ณต์ธ IP ํ™•์ธ์ด ๊ฐ€๋Šฅํ•˜๋‹ค. $ curl ip.ojj.kr Your IP is 121.131.xxx.xxx 2. openvpn-install.sh ๋‹ค์šด๋ฐ›๊ธฐ $ wget https://git.io/vpn -O openvpn-install.sh 3. openvpn-install.sh ์‹คํ–‰ํ•ด์„œ OpenVPN ์„œ๋ฒ„ ์„ค์น˜ํ•˜๊ธฐ ์Šคํฌ๋ฆผํŠธ๋ฅผ ..

IT Talks/Linux 2022.08.01

๊ฐœ๋ฐœ์ž ์ปจํผ๋Ÿฐ์Šค ์‹œ์ฆŒ์ด ๋Œ์•„์˜ค๋‹ค

๋งค๋…„ ์ด๋•Œ๊ฐ€ ๋˜๋ฉด ์œ ๋ช… IT ํšŒ์‚ฌ๋“ค์˜ ๊ฐœ๋ฐœ์ž ์ปจํผ๋Ÿฐ์Šค๊ฐ€ ๋งŽ์ด ์—ด๋ฆฐ๋‹ค. ์ฝ”๋กœ๋‚˜๋•๋ถ„(?)์— ์˜จ๋ผ์ธ์œผ๋กœ ์‹œํ–‰๋˜๊ณ  ์žˆ์–ด์„œ ์˜ˆ์ „๊ณผ ๊ฐ™์ด ์„ ์ฐฉ์ˆœ์ด๋‚˜ ์ถ”์ฒจ์˜ ์ŠคํŠธ๋ ˆ์Šค๋Š” ์—†์–ด์กŒ์ง€๋งŒ ํ˜„์žฅ๊ฐ์„ ๋Š๋ผ์ง€ ๋ชปํ•˜๋Š” ์•„์‰ฌ์›€๋„ ์žˆ๋‹ค. (๊ธฐ๋…ํ’ˆ ์ฑ™๊ธฐ๊ธฐ ๋ชปํ•˜๋Š”๊ฒŒ ์•„์‰ฝ ใ…Žใ…Ž) ์˜ฌํ•ด๋Š” ํ˜„๋Œ€์ž๋™์ฐจ๊ทธ๋ฃน๋„ ์ƒˆ๋กœ ์‹œ์ž‘ํ•˜๋Š”๋“ฏ. * IT ์ปจํผ๋Ÿฐ์Šค ์ „์ฒด ํ–‰์‚ฌ๋ช… ์ฃผ๊ด€ ์ผ์ • (2021) URL HMG Developer Conference ํ˜„๋Œ€์ฐจ๊ทธ๋ฃน 11.10~11 URL LINE DEVELOPER DAY 2021 LINE 11.10~11 URL if(kakao) 2021 KAKAO 11.16~18 URL ์šฐ์•„์ฝ˜ 2021 ์šฐ์•„ํ•œํ˜•์ œ๋“ค 11.17~19 URL DEVIEW 2021 NAVER 11.24 ~ 26 URL

IT Talks 2021.11.08
728x90