TIL icon indicating copy to clipboard operation
TIL copied to clipboard

Today I Learned (Python / Django / FastAPI)

๐Ÿ’พ๋งค์ผ ๋ฐฐ์šด ๋‚ด์šฉ ์ •๋ฆฌ

img

2022.07.04 ~ 2022.12.16 ๋ฉ€ํ‹ฐ์บ ํผ์Šค/ํ•˜์ดํผ๊ทธ๋กœ์Šค ์ฃผ๊ด€ [ํ’€์Šคํƒ ๊ฐœ๋ฐœ์ž ์ทจ์—…์บ ํ”„(Python)] ๊ฐ•์˜๋ฅผ ๋“ฃ๊ณ  ์ •๋ฆฌํ–ˆ์Šต๋‹ˆ๋‹ค.

1. CMD / Shortcuts / Markdown

  • [CMD] Linux / pytest / pyenv / Poetry / Docker
  • [Shortcuts] VSCODE / Eclipse / Browser / Notepad++ / Windows
  • [Markdown] ๋ฌธ๋ฒ•

2. Git / GitHub

  • [Git] ๊ธฐ์ดˆ ๋ช…๋ น์–ด
  • [Git] ํ•™์Šต์ž๋ฃŒ (ProGit / e-book)
  • [Git/GitHub] Remote repository
  • [Git/Github] Upstream, Origin, Local repository
  • [Git/GitHub] ํ˜‘์—…์˜ ํ๋ฆ„
  • [Git/Github] Django ํ”„๋กœ์ ํŠธ ์ ์šฉ ์‹ค์Šต

3. ํ”„๋กœ๊ทธ๋ž˜๋ฐ ์–ธ์–ด ํ™œ์šฉ

  • [Python] ๊ธฐ์ดˆ
  • [Python] ์ œ์–ด๋ฌธ
  • [Python] ํ•จ์ˆ˜
  • [Python] ๋ฐ์ดํ„ฐ๊ตฌ์กฐ
  • [Python] ์—๋Ÿฌ/์˜ˆ์™ธ ์ฒ˜๋ฆฌ
  • [Python] ๊ฐ์ฒด ์ง€ํ–ฅ ํ”„๋กœ๊ทธ๋ž˜๋ฐ(OOP) ๊ธฐ๋ณธ (0719์ผ์ž / ๋ณด์™„์ค‘)
  • [Python] ๊ฐ์ฒด ์ง€ํ–ฅ ํ”„๋กœ๊ทธ๋ž˜๋ฐ(OOP) ์‹ฌํ™” (0720์ผ์ž / ๋ณด์™„์ค‘)
  • [Python] ํŒจํ‚ค์ง€ ํ™œ์šฉ (0721์ผ์ž / ๋ณด์™„์˜ˆ์ •)

4. ์•Œ๊ณ ๋ฆฌ์ฆ˜์„ ํ†ตํ•œ SW ๋ฌธ์ œํ•ด๊ฒฐ

5. ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค

  • [Database] RDB, RDBMS (0816์ผ์ž / ๋ณด์™„์ค‘)
  • [Database] SQLite I - WHERE, Aggregate Functions, LIKE, ORDER BY (0817์ผ์ž / ๋ณด์™„์ค‘)
  • [Database] SQLite II - ๊ธฐ๋ณธ ํ•จ์ˆ˜์™€ ์—ฐ์‚ฐ, GROUP BY, ALTER TABLE (0818์ผ์ž / ๋ณด์™„์ค‘)
  • [Database] SQLite III - CASE, SubQuery (0819์ผ์ž / ๋ณด์™„์ค‘)
  • [Database] SQLite IV - Join (0822์ผ์ž / ๋ณด์™„์ค‘)
  • [Database] ๋ชจ๋ธ๋ง (0823์ผ์ž / ๋ณด์™„์ค‘)
  • [Database] ORM (0824์ผ์ž / ๋ณด์™„์ค‘)
  • [Database] QuerySet API, ORM ํ™•์žฅ(1:N) (0825์ผ์ž / ๋ณด์™„์ค‘)
  • [Database] Programmers School - SQL ๊ณ ๋“์  Kit

6. ํ”„๋ก ํŠธ์—”๋“œ SW๊ฐœ๋ฐœ(ํ™”๋ฉด๊ตฌํ˜„)

  • [HTML/CSS] Web (0829์ผ์ž / ๋ณด์™„์ค‘)
  • [HTML/CSS] CSS ๊ธฐ๋ณธ ์Šคํƒ€์ผ, Selectors, Box model, Display (0830์ผ์ž / ๋ณด์™„์ค‘)
  • [HTML/CSS] CSS Position, Layout, Float, Flexbox (0831์ผ์ž / ๋ณด์™„์ค‘)
  • [HTML/CSS] CSS Navbar (0901์ผ์ž / ๋ณด์™„์ค‘)
  • [HTML/CSS] HTML - ์‹œ๋งจํ‹ฑ ํƒœ๊ทธ, ๋ฌธ์„œ ๊ตฌ์กฐํ™” / Bootstrap (0905์ผ์ž / ๋ณด์™„์˜ˆ์ •)
  • [HTML/CSS] Bootstrap Components (0906์ผ์ž / ๋ณด์™„์ค‘)
  • [HTML/CSS] Bootstrap Grid System (0907์ผ์ž / ๋ณด์™„์ค‘)
  • [HTML/CSS] Bootstrap ์‹ค์Šต I
  • [HTML/CSS] Bootstrap ์‹ค์Šต II - Pair Programming
  • [HTML/CSS] Bootstrap ์‹ค์Šต III - Pair Programming

7. ํ”„๋ก ํŠธ์—”๋“œ ์–ดํ”Œ๋ฆฌ์ผ€์ด์…˜ ๊ตฌํ˜„

  • [JavaScript] INTRO
  • [JavaScript] ECMA Script
  • [JavaScript] ECMA Script ์‹ฌํ™” (0916์ผ์ž / ๋ณด์™„์ค‘)
  • [JavaScript] Event (0919์ผ์ž / ๋ณด์™„์˜ˆ์ •)
  • [JavaScript] JavaScript Library ํ™œ์šฉ (0920์ผ์ž / ๋ณด์™„์˜ˆ์ •)

8. Django ๋ฐฑ์—”๋“œ SW๊ฐœ๋ฐœ

  • [Django] ์‹œ์ž‘ํ•˜๊ธฐ
  • [Django] ์š”์ฒญ๊ณผ ์‘๋‹ต (0922 ~ 0923์ผ์ž / ๋ณด์™„์ค‘)
  • [Django] Variable routing (0926์ผ์ž / ๋ณด์™„์˜ˆ์ •)
  • [Django] URLs (0927์ผ์ž / ๋ณด์™„์ค‘)
  • [Django] CRUD ๊ธฐ์ดˆ (0928์ผ์ž / ๋ณด์™„์ค‘)
  • [Django] CRUD ์‹ฌํ™” (detail page) (0929์ผ์ž / ๋ณด์™„์ค‘)
  • [Django] ModelForm I (1004์ผ์ž / ๋ณด์™„์ค‘)
  • [Django] ModelForm II (1005์ผ์ž / ๋ณด์™„์ค‘)
  • [Django] Q&A
  • [Django] Auth (1011์ผ์ž / ๋ณด์™„์ค‘)
  • [Django] ํšŒ์›๊ด€๋ฆฌ ์„œ๋น„์Šค ์ดํ•ด (1012 ~ 1013์ผ์ž / ๋ณด์™„์ค‘)
  • [Django] ํšŒ์›๊ด€๋ฆฌ ์„œ๋น„์Šค ๋งŒ๋“ค๊ธฐ
  • [Django] ์ด๋ฏธ์ง€ ๊ด€๋ฆฌ (1017์ผ์ž / ๋ณด์™„์ค‘)

9. ๋ฐ์ดํ„ฐ ๋ชจ๋ธ๋ง์„ ํ™œ์šฉํ•œ ํ’€์Šคํƒ ๊ฐœ๋ฐœ

  • [Django] 1:N (Article - Comment) (1018์ผ์ž / ๋ณด์™„์ค‘)
  • [Django] 1:N (User - Article/Comment) (1019์ผ์ž / ๋ณด์™„์ค‘)
  • [Django] M:N (Article - User) (1024์ผ์ž / ๋ณด์™„์ค‘)
  • [Django] M:N (User - User) (1025์ผ์ž / ๋ณด์™„์ค‘)
  • [Django/advanced] Asynchronous Programming (1026์ผ์ž / ๋ณด์™„์ค‘)
  • [Django/advanced - MTV] Model ORM & QuerySet (1027์ผ์ž / ๋ณด์™„์˜ˆ์ •)
  • [Django/advanced - MTV] Template tags & filters (1027์ผ์ž / ๋ณด์™„์˜ˆ์ •)
  • [Django/advanced - MTV] View functions & decorators

10. FastAPI ๋ฐฑ์—”๋“œ SW๊ฐœ๋ฐœ

  • [FastAPI] ์‹œ์ž‘ํ•˜๊ธฐ
  • [FastAPI] ๊ด€์  ์ง€ํ–ฅ ํ”„๋กœ๊ทธ๋ž˜๋ฐ(AOP) ๊ธฐ๋ณธ
  • [FastAPI] ๊ด€์  ์ง€ํ–ฅ ํ”„๋กœ๊ทธ๋ž˜๋ฐ(AOP) ์‹ฌํ™” | Middleware ์ปค์Šคํ…€

11. ์ถ”๊ฐ€ ํ•™์Šต

  • CS ๊ธฐ์ดˆ
  • JavaScript
  • Node.js
  • Swift
  • Kotlin
  • [Deploy] AWS + PostgreSQL + Github Actions
  • [TDD] pytest + python-dotenv
  • [Algorithm] ๋„ˆ๋น„์šฐ์„ ํƒ์ƒ‰(BFS)
  • [Algorithm] ์ •๋ ฌ
  • [Algorithm] ๊ทธ๋ฆฌ๋””(Greedy)
  • [Algorithm] ์ตœ๋‹จ๊ฒฝ๋กœ
  • [Algorithm] ๋‹ค์ด๋‚˜๋ฏน ํ”„๋กœ๊ทธ๋ž˜๋ฐ(DP)

12. ์ฐธ๊ณ ์ž๋ฃŒ