DATABASE ARCHITECTURE AND PAYMENT INTEGRATION IN AN AUTOMATED PARKING MANAGEMENT SYSTEM
Keywords:
automated parking, SQLite, WAL mode, electronic payment, Payme, Click, REST API, WebSocket, Telegram bot, JWT authentication.Abstract
This paper examines the data management and payment subsystems of an automated parking facility built around license plate recognition. The system employs a lightweight SQLite database operating in Write-Ahead Logging (WAL) mode to record real-time spot occupancy, full entry–exit histories, advance bookings and electronic payment transactions. A position-based tariff engine calculates fees at the moment of vehicle departure, and payment links for two widely used Uzbek e-wallet services — Payme and Click — are generated automatically. Advance reservations are handled through a REST API and a Telegram bot; a background scheduler cancels no-show bookings after a configurable grace period and logs a penalty charge. A JWT-secured role model governs write access to all sensitive endpoints. Evaluation over a two-week trial at a 24-space outdoor lot showed that the database layer sustained sub-200 ms API response times under 200 simultaneous WebSocket connections and recovered without data loss from three simulated power-failure interruptions, confirming the suitability of WAL-mode SQLite for small-to-medium parking deployments.
References
[1] R. E. Barone et al., “Architecture for parking management in smart cities,” IET Intell. Transp. Syst., vol. 8, no. 5, pp. 445–452, 2014.
[2] Raspberry Pi Foundation, Raspberry Pi 4 Model B — Product Brief, 2023. [Online]. Available: https://www.raspberrypi.com/products/raspberry-pi-4-model-b/
[3] Y. Geng and C. G. Cassandras, “New smart parking system based on resource allocation and reservations,” IEEE Trans. Intell. Transp. Syst., vol. 14, no. 3, pp. 1129–1139, 2013.
[4] R. E. Barone et al., “Smart parking: Using a Vanet-based system to make decisions for reducing CO2 emissions,” in Proc. IEEE ITSC, 2011, pp. 1236–1241.
[5] D. R. Hipp, “SQLite, a self-contained, serverless, zero-configuration, transactional SQL database engine,” SQLite Consortium, 2022. [Online]. Available: https://www.sqlite.org/wal.html
[6] A. Thakur et al., “Smart parking system for smart cities using IoT and mobile application,” in ICT Analysis and Applications, Springer, 2020, pp. 319–327.
[7] M. Jones, J. Bradley, and N. Sakimura, “JSON Web Token (JWT),” IETF RFC 7519, May 2015.
[8] Republic of Uzbekistan, “Law on Personal Data Protection,” 2019.
