Home
SoThoughtful;
Cancel

실시간 SQL 집계 vs 비정규화 카운터 컬럼 — 언제 뭘 써야 할까

문제 상황 주문 관리 시스템을 만들고 있다고 가정해보자. 주문마다 여러 상품이 있고, 각 상품은 선발송(pre-shipment) 처리를 통해 부분적으로 출고될 수 있다. 이때 각 상품의 남은 발송 가능 수량을 계산해야 한다 — 즉, 총 구매수량에서 이미 접수된 선발송 수량을 빼야 한다. 두 가지 방법이 있다: 방법 A — 실시간 집계: 쿼리할 때...

Base64 Encoder & Decoder (Base64 인코딩 & 디코딩 변환기)

Evergreen Donkatsu Anyang — The Best Korean-Style Pork Cutlet Near Indeogwon (에버그린 수제돈까스 Menu & Review)

Not Your Typical Donkatsu If you think donkatsu is donkatsu — crispy pork, some sauce, done — Evergreen (에버그린) in Indeogwon will change your mind. This isn’t Japanese-style tonkatsu with its delic...

Korean-style donkatsu with rich demi-glace sauce, cream soup, and freshly baked bread at Evergreen in Indeogwon, Anyang

Unix Timestamp Converter & World Clock (타임스탬프 변환기 & 세계 시계)

Sundae Silrok Seoul — Best Sundaeguk (Korean Blood Sausage Soup) Review

The Real Korean Soul Food I’ve been writing about fine dining and Japanese noodles, but it just hit me — I haven’t introduced any truly Korean food yet. And when I say truly Korean, I mean the kin...

Steaming bowl of sundaeguk topped with fresh chives at Sundae Silrok Seoul — best Korean blood sausage soup

Cron Expression Generator (크론 표현식 생성기)

Diff Checker (텍스트 & 코드 비교 도구)

JSON Formatter & Validator (JSON 포맷 변환 및 유효성 검사)

Kanda Soba Seoul — Best Mazesoba in Hyehwa (Menu, Price & Review)

A 10-Minute Walk That’s 100% Worth It I’ll be honest — there are plenty of decent lunch spots within a 2-minute radius of my office. But once you’ve had the mazesoba at Kanda Soba (칸다소바), you’ll h...

Mazesoba at Kanda Soba Seoul topped with raw egg yolk, green onions, seaweed, and rich meat sauce — best mazesoba in Hyehwa

STAY by Yannick Alléno Seoul — SIGNIEL Fine Dining (시그니엘 STAY)

Why STAY? If someone asks me to name one restaurant in Seoul where the food, the view, and the moment all come together — I’d say STAY without hesitation. STAY (Simple Table Alléno Yannick) sits ...

Sunset view of Han River from STAY restaurant by Yannick Alléno, 81st floor SIGNIEL Seoul Lotte World Tower