Back to projects
Logistics
BekCargo
BekCargo is a platform for managing cargo transportation from China to Kyrgyzstan. Includes web application for administrators, mobile app for customers, cargo tracking system and automatic cost calculation.
2023-20241.5 годаBekCargo
Challenge
Optimize complex SQL queries that took more than 35 seconds to execute, and create a convenient tracking system for customers.
Solution
Conducted deep analysis and database optimization, added indexes, rewrote critical queries. Execution time reduced from 35+ seconds to less than 1 second.
Results
35x
faster database queries
5,000+
tracked packages
Automatic
cost calculation
XPAY.kg
integration
Tech Stack
Frontend
ReactTypeScriptAnt Design
Backend
PythonFastAPISQLAlchemy
Mobile
React NativeExpo
Database
PostgreSQL
Integrations
XPAY.kgSMS GatewayTelegram Bot
DevOps
DockerNginxGitHub Actions
Features
Cargo trackingCost calculatorOrder historyPush notificationsOnline paymentTelegram bot
Screenshots
Screenshot 1
Screenshot 2
Screenshot 3