{"id":21,"date":"2025-08-20T17:37:42","date_gmt":"2025-08-20T09:37:42","guid":{"rendered":"https:\/\/www.ycxhl.top\/?p=21"},"modified":"2026-08-27T17:22:59","modified_gmt":"2026-08-27T09:22:59","slug":"17","status":"publish","type":"post","link":"https:\/\/www.ycxhl.top\/en\/archives\/17\/","title":{"rendered":"[\u9879\u76ee] \u4e00\u5957\u5b8c\u6574\u7684\u667a\u80fd\u5171\u4eab\u5355\u8f66\u7cfb\u7edf"},"content":{"rendered":"
\n

A complete shared bike solution covering the user APP, smart bike lock, and management backend, with a comprehensive tech stack and a measured stress resistance of 89.7 requests\/second<\/strong><\/p>\n<\/blockquote>\n\n\n\n

Project Origin<\/h2>\n\n\n\n

To participate in the finals of the 2025 National Youth Information Literacy Competition, we completed the basic lock\/unlock function according to the given problem requirements, but to make it closer to real life and turn it into a complete and mature product, we developed more branches and innovative features, including but not limited to:GPS positioning, accident detection and alarm, vehicle fault reporting, vehicle data cluster management, backend management dashboard, user-based data management, trip data recording and display<\/strong>CoveringUser-side APP, embedded smart lock, backend management system, and API service<\/strong>\u3002
This article will provide an in-depth analysis of the technical architecture and implementation highlights of this system.<\/p>\n\n\n\n

Team Division of Labor<\/h2>\n\n\n\n
Me (XHL)<\/td>Server operations and maintenance, frontend and backend development, APP, all software parts, etc.<\/td>Personal website<\/a><\/td><\/tr>
The Sandy<\/td>3D structural design and printing of the bike lock, hardware structure construction, assisting with ESP32 program development, etc.<\/td>Personal website<\/a><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

Overall Architecture: Layered Design<\/h2>\n\n\n\n

The project's three-layer architecture:<\/p>\n\n\n\n

Layer<\/th>Tech Stack<\/th>Function<\/th><\/tr><\/thead>
Client<\/td>Vue + Android + Amap SDK<\/td>Map display, scan-to-unlock, trip records, user center<\/td><\/tr>
Bike-side<\/td>MicroPython + ESP32 + GPS\/MPU6050<\/td>Positioning reporting, posture detection, unlock execution<\/td><\/tr>
API Service<\/td>Python Flask<\/td>Business logic processing, data interfaces<\/td><\/tr>
Data Layer<\/td>MySQL + connection pool<\/td>Data storage<\/td><\/tr>
Infrastructure<\/td>Docker + Nginx + Debian<\/td>Containerized deployment, load balancing<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n

Server Highlights: High Performance and High Availability<\/h2>\n\n\n\n

1 Connection Pool Design<\/h3>\n\n\n\n

The server side is developed based on Python Flask. For the database, I encapsulated it myself SQL<\/code> \u7c7b<\/p>\n\n\n\n

from dbutils.pooled_db import PooledDB<\/code><\/pre>\n\n\n\n
Measured data<\/strong>: The system can withstand approximately 89 requests\/second<\/strong> of data requests, and the server never crashed during network attack tests.<\/p>\n\n\n\n
2 Logging System<\/h3>\n\n\n\n
All API requests are recorded to the database through the server_log()<\/code> function, and log types are divided into:<\/p>\n\n\n\n