๐Ÿ‘จโ€๐Ÿ’ป ํ•ธ์ฆˆ์˜จ๋žฉ ์‹œ๊ฐ„. ์‹ค์Šตํ™˜๊ฒฝ ํ™•์ธยถ

๋ณธ ํŠœํ† ๋ฆฌ์–ผ์—์„œ ๊ฐ€์žฅ ์˜ค๋žœ ์‹œ๊ฐ„์ด ๊ฑธ๋ฆด ์ˆ˜ ์žˆ๋Š” ๋ถ€๋ถ„์ด ์‹ค์Šตํ™˜๊ฒฝ ๊ตฌ์„ฑ๊ณผ ๋ผ์ด๋ธŒ๋Ÿฌ๋ฆฌ ๋‹ค์šด๋กœ๋“œ์ž…๋‹ˆ๋‹ค.

ํŠœํ† ๋ฆฌ์–ผ์„ ์‹œ์ž‘ํ•˜๊ธฐ ์ „์— ๐Ÿฅณ ํ•ธ์ฆˆ์˜จ๋žฉ์— ์˜ค์‹œ๊ธฐ ์ „์— ๋ฏธ๋ฆฌ ํ™•์ธํ•ด์ฃผ์„ธ์š”. ๋ฌธ์„œ์—์„œ ํ™•์ธํ–ˆ์—ˆ๋˜ ์‹ค์Šตํ™˜๊ฒฝ์„ ์žฌ์ฐจ ํ™•์ธํ•ด์ฃผ์‹œ๊ณ , ํ”„๋กœ์ ํŠธ ํด๋” ์ƒ์„ฑ ํ›„์— ๊ฐ€์ƒํ™˜๊ฒฝ ์ƒ์„ฑ ๋ฐ ๋ผ์ด๋ธŒ๋Ÿฌ๋ฆฌ ์„ค์น˜๊นŒ์ง€ ์™„๋ฃŒ ๋ถ€ํƒ๋“œ๋ฆฝ๋‹ˆ๋‹ค. ๐Ÿ™‡

sqlite-vec ๋ผ์ด๋ธŒ๋Ÿฌ๋ฆฌ๋ฅผ ํ™œ์šฉํ•˜์‹ค ๊ฒฝ์šฐยถ

์‹ค์Šตํ™˜๊ฒฝ ์žฌํ™•์ธยถ

์‹œ์Šคํ…œ ํ™•์ธ ์ฝ”๋“œ๋ฅผ ํ†ตํ•ด ์‹ค์Šตํ™˜๊ฒฝ์„ ํ™•์ธํ•ฉ๋‹ˆ๋‹ค. ์šด์˜์ฒด์ œ/์‰˜์— ๋งž๊ฒŒ ๋ช…๋ น์„ ๋ณต์‚ฌํ•ด์„œ ์‹คํ–‰ํ•ด์ฃผ์„ธ์š”.

powershell -Command "(iwr https://gist.githubusercontent.com/allieus/aa62bffa2aaf26085eb11b3b4e98d9e6/raw/sqlite3-check-system.py).Content" | python
curl https://gist.githubusercontent.com/allieus/aa62bffa2aaf26085eb11b3b4e98d9e6/raw/sqlite3-check-system.py | python

์‹ค์Šตํ™˜๊ฒฝ ์ค€๋น„ ์™„๋ฃŒยถ

This Python supports sqlite3 extension. See you at the venue. ;-) ๋ฌธ์žฅ์ด ์ถœ๋ ฅ๋˜๋ฉด ์‹ค์Šตํ™˜๊ฒฝ ์ค€๋น„๊ฐ€ ์™„๋ฃŒ๋œ ๊ฒƒ์ž…๋‹ˆ๋‹ค.

../../_images/win-check-system.png

pgvector ๋ผ์ด๋ธŒ๋Ÿฌ๋ฆฌ๋ฅผ ํ™œ์šฉํ•˜์‹ค ๊ฒฝ์šฐยถ

https://supabase.com ์„œ๋น„์Šค๋ฅผ ์ด์šฉํ•˜์‹œ๊ฑฐ๋‚˜, ๋กœ์ปฌ์— pgvector ํ™•์žฅ์ด ์„ค์น˜๋œ PostgreSQL ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค๋ฅผ ์ƒ์„ฑํ•˜์‹  ํ›„์—, DATABASE_URL ํ™˜๊ฒฝ๋ณ€์ˆ˜๋กœ์„œ ์‚ฌ์šฉํ•  ์—ฐ๊ฒฐ ๋ฌธ์ž์—ด์„ ์ค€๋น„ํ•ด์ฃผ์„ธ์š”.

DATABASE_URL ํ™˜๊ฒฝ๋ณ€์ˆ˜ ์˜ˆ์‹œยถ
postgresql://postgres.euvmdqdkpiseywirljvs:์•”ํ˜ธ@aws-0-ap-northeast-2.pooler.supabase.com:5432/postgres

ํ”„๋กœ์ ํŠธ ํด๋” ์ƒ์„ฑ, ๊ฐ€์ƒํ™˜๊ฒฝ ํ™œ์„ฑํ™” ๋ฐ ๋ผ์ด๋ธŒ๋Ÿฌ๋ฆฌ ์„ค์น˜ยถ

์›ํ•˜์‹œ๋Š” ๊ฒฝ๋กœ์— django-webchat-rag ํ”„๋กœ์ ํŠธ ํด๋”๋ฅผ ์ƒ์„ฑํ•ด์ฃผ์‹œ๊ณ , ํ”„๋กœ์ ํŠธ ํด๋”์—์„œ ๊ฐ€์ƒํ™˜๊ฒฝ์„ ์ƒ์„ฑ/ํ™œ์„ฑํ™”ํ•ด์ฃผ์„ธ์š”.

python -m venv venv
venv\Scripts\activate
python -m venv venv
source ./venv/bin/activate

์•„๋ž˜ ๋ช…๋ น์„ ๋ณต์‚ฌํ•ด์„œ, ํ•„์š”ํ•œ ๋ผ์ด๋ธŒ๋Ÿฌ๋ฆฌ๋“ค์„ ํ•œ ๋ฒˆ์— ์„ค์น˜ํ•ด์ฃผ์„ธ์š”.

python -m pip install --upgrade sqlite-vec numpy pyhub-git-commit-apply django-pyhub-rag django-environ django-debug-toolbar django-extensions django-lifecycle openai anthropic google-genai ipython
python -m pip install --upgrade psycopg2-binary pgvector pyhub-git-commit-apply django-pyhub-rag django-environ django-debug-toolbar django-extensions django-lifecycle openai anthropic google-genai ipython

python -m pip list ๋ช…๋ น์œผ๋กœ ์„ค์น˜๋œ ๋ผ์ด๋ธŒ๋Ÿฌ๋ฆฌ ๋ชฉ๋ก์„ ํ™•์ธํ•˜์‹ค ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค.

ํŒ

๊ฐ€์ƒํ™˜๊ฒฝ ์ƒ์„ฑ ๋ฐ ํ™œ์„ฑํ™”, ๋ผ์ด๋ธŒ๋Ÿฌ๋ฆฌ ์„ค์น˜์— ์–ด๋ ค์›€์ด ์žˆ์œผ์‹  ๋ถ„์€ ์ฃผ์ €์—†์ด ๋ง์”€ํ•ด์ฃผ์„ธ์š”. :-)

๋ช…๋ น ํ…Œ์ŠคํŠธยถ

๋ฐฉ๊ธˆ pyhub-git-commit-apply ๋ผ์ด๋ธŒ๋Ÿฌ๋ฆฌ๋„ ์„ค์น˜ํ–ˆ์—ˆ๊ตฌ์š”. ์˜คํƒ€์—†๋Š” ๋น ๋ฅธ ํŠœํ† ๋ฆฌ์–ผ ์‹ค์Šต์„ ๋„์™€์ฃผ๋Š” ๋ผ์ด๋ธŒ๋Ÿฌ๋ฆฌ์ž…๋‹ˆ๋‹ค. ๊ณง ์‚ฌ์šฉํ•  ๊ฒƒ์ด๊ตฌ์š”.

python -m pyhub_git_commit_apply ๋ช…๋ น์ด ์ง€์›๋˜๋Š”๋ฐ์š”. ํ„ฐ๋ฏธ๋„์—์„œ ์‹คํ–‰ํ•˜์‹œ๋ฉด ์•„๋ž˜์™€ ๊ฐ™์ด ๋ช…๋ น์ด ๋™์ž‘ํ•˜๋Š” ์ง€๋ฅผ ํ™•์ธํ•ด์ฃผ์„ธ์š”.

$ python -m pyhub_git_commit_apply
usage: __main__.py [-h] [--all] commit_url
__main__.py: error: the following arguments are required: commit_url

๋ช…๋ น์—์„œ ํ•„์ˆ˜ ์ธ์ž commit_url์„ ์ง€์ •ํ•˜์ง€ ์•Š์•˜๊ธฐ ๋•Œ๋ฌธ์— ์˜ค๋ฅ˜๊ฐ€ ๋ฐœ์ƒํ•˜๋Š” ๊ฒƒ์ด ๋งž์Šต๋‹ˆ๋‹ค.

Letโ€™s Go!ยถ

๊ทธ๋Ÿผ ๋ชจ๋“  ์ค€๋น„๋ฅผ ๋งˆ์น˜์…จ์Šต๋‹ˆ๋‹ค. ์‹œ์ž‘ํ•  ๋•Œ๊นŒ์ง€ ์ž ์‹œ๋งŒ ๊ธฐ๋‹ค๋ ค์ฃผ์„ธ์š”.

์ž˜ ๋ถ€ํƒ๋“œ๋ฆฝ๋‹ˆ๋‹ค. ๐Ÿ˜‰