Tinkerbell Glitter
[250305] Soft Delete๋ž€?
Back End ๐Ÿ“ฒ/Django โ›“๏ธ
Soft Delete๋ž€? ๐Ÿ”™1. Soft Delete ์ •์˜Soft Delete(์†Œํ”„ํŠธ ๋”œ๋ฆฌํŠธ)๋Š” ๋ฐ์ดํ„ฐ๋ฅผ ์‹ค์ œ๋กœ ์‚ญ์ œํ•˜๋Š” ๋Œ€์‹ , ํŠน์ • ์ปฌ๋Ÿผ(์˜ˆ: `deleted_at` ๋˜๋Š”`is_deleted`)์„ ์—…๋ฐ์ดํŠธํ•˜์—ฌ ๋…ผ๋ฆฌ์ ์œผ๋กœ ์‚ญ์ œ๋œ ๊ฒƒ์ฒ˜๋Ÿผ ์ฒ˜๋ฆฌํ•˜๋Š” ๋ฐฉ๋ฒ•์ด๋‹ค.๐Ÿ” Hard Delete vs. Soft Delete๊ตฌ๋ถ„Hard DeleteSoft Delete๋ฐ์ดํ„ฐ ์‚ญ์ œ ์—ฌ๋ถ€์‹ค์ œ ์‚ญ์ œDB์— ๋‚จ์•„์žˆ์Œ๋ณต๊ตฌ ๊ฐ€๋Šฅ ์—ฌ๋ถ€๋ถˆ๊ฐ€๋Šฅ๊ฐ€๋Šฅ์„ฑ๋Šฅ ์˜ํ–ฅ๋น ๋ฆ„์ผ๋ถ€ ์„ฑ๋Šฅ ๋ถ€๋‹ด๋ฐ์ดํ„ฐ ๋ฌด๊ฒฐ์„ฑ์˜์กด์„ฑ ๋ฐ์ดํ„ฐ ์‚ญ์ œ ํ•„์š”์œ ์ง€ ๊ฐ€๋Šฅ์‚ฌ์šฉ ์‚ฌ๋ก€๋ณด์•ˆ์ด ์ค‘์š”ํ•œ ๋ฐ์ดํ„ฐ๊ธฐ๋ก ๋ณด์กด์ด ์ค‘์š”ํ•œ ๊ฒฝ์šฐ2. Soft Delete ๊ตฌํ˜„ ๋ฐฉ์‹1๏ธโƒฃ `is_deleted` ํ”Œ๋ž˜๊ทธ ํ™œ์šฉ์‚ญ์ œ ์—ฌ๋ถ€๋ฅผ ๋‚˜ํƒ€๋‚ด๋Š” Boolean ์ปฌ๋Ÿผ์„ ์ถ”๊ฐ€ํ•˜๋Š” ๋ฐฉ์‹.ALTER TABLE users ADD ..