35
مساراً في الواجهة البرمجية
منصّة · 2025 · دون ذكر اسم العميل
بحث عن العقارات يعتمد على الموقع الجغرافي الحقيقي: حين يصفّي المستخدم النتائج حسب المكان، تجيب قاعدة البيانات مباشرةً بدل أن يتولّى كود التطبيق ذلك.
35
مساراً في الواجهة البرمجية
جغرافي
نوع البحث
spatial index, database-side
المشكلة
Property search is a location query first and a filter query second. A platform that stores coordinates as plain numbers and computes distance in application code works in testing and degrades continuously as listings grow.
الحلّ المعتمد
Modelled locations as proper geospatial points with a spatial index from the start, so radius and bounding queries execute in the database. Listings carry media through object storage rather than the application, keeping upload traffic off the API path.
بنية النظام
Spatial indexing on listing coordinates, with media offloaded to object storage. The geospatial decision is made once at the schema level rather than retrofitted after the first slow query.
ومع كل قرار ثمنه
القرار الذي لا يُذكر ثمنه مجرّد تفضيل شخصي.
01
السبب
Retrofitting geospatial querying means rewriting every location filter and backfilling every record. Deciding it up front costs nothing.
الثمن
Slightly more care required on write, in exchange for the query pattern the product is built on.
النتيجة
Location-based property search that stays responsive as the catalogue grows, with media served from storage rather than through the application.