16
نموذجاً للبيانات بعد الترحيل
down from 18
منصّة · 2025 · دون ذكر اسم العميل
استلمتُ نظاماً مكتوباً بـ TypeScript وSQL، ونقلته إلى مجموعة تقنيات أخرى، فخرج بنماذج بيانات أقلّ وقدرات أكثر.
16
نموذجاً للبيانات بعد الترحيل
down from 18
4
لغات للمحتوى
4
Asset pipelines
image, GLB, USDZ, video
48
Route declarations
المشكلة
An existing platform needed to keep working while changing underneath. The original was TypeScript over SQL with eighteen models, and the brief was to take it over, migrate the stack, and extend it with multi-language content and 3D or AR vehicle assets.
الحلّ المعتمد
Took ownership of the inherited codebase, understood what the eighteen models were actually doing, and rewrote it against a new stack with sixteen. Fewer models with more capability is the direction that matters in a migration; more models usually means the original structure was copied rather than understood. Added four-language content on every text field and four separate upload paths for images, GLB, USDZ and video, since 3D and AR assets have different handling requirements from photos.
بنية النظام
Complete rewrite rather than incremental port, model count reduced from eighteen to sixteen. Four distinct upload middlewares, because a GLB, a USDZ, an image and a video are not interchangeable.
ومع كل قرار ثمنه
القرار الذي لا يُذكر ثمنه مجرّد تفضيل شخصي.
01
السبب
An incremental port of a schema you did not design tends to preserve its mistakes. Rewriting forced a decision about every model, and two turned out to be unnecessary.
الثمن
Higher upfront effort and a real cutover, against inheriting structure nobody could justify.
02
السبب
Content is read constantly and written rarely, and every read wants one language. Variant fields mean no join on the hot path.
الثمن
The primary entity carries around fifty fields, half of them language variants, verbose in exchange for fast reads.
النتيجة
A migrated platform with a smaller schema, four-language content throughout, and 3D and AR asset delivery. Documented with full endpoint tables rather than left as tribal knowledge.