Design and Implementation of a RESTful API-Based Point of Sale System
DOI:
https://doi.org/10.25134/ilkom.v19i1.343Keywords:
Point of Sale (POS), RESTful API, Supabase, Express.jsAbstract
Point of Sale (POS) systems are essential for modern businesses, streamlining transactions, inventory management, and customer interactions. However, traditional POS systems face challenges such as limited real-time data processing, scalability issues, and restricted integration capabilities. This study proposes a RESTful API-based POS system using Supabase and Express.js to overcome these limitations.The system is developed using a hybrid waterfall methodology, combining structured phases with iterative refinement, and employs a relational database normalized to the third normal form (3NF) for data integrity and scalability. Supabase, as a backend-as-a-service platform, simplifies backend operations with its robust features for database management, authentication, and real-time APIs. Meanwhile, Express.js provides a lightweight and efficient framework for developing RESTful APIs, ensuring seamless integration and efficient data handling. Comprehensive testing, including black box testing, confirms the system’s reliability, ensuring its readiness for real-world implementation. The results highlight the system’s ability to enhance operational efficiency and adapt to dynamic business requirements. This study demonstrates how integrating RESTful APIs, Supabase, and Express.js can modernize POS systems, providing scalable, secure, and efficient solutions tailored to the demands of a data-driven marketplace.
Downloads
References
D. Milenković, J. Petković, and S. Marinković, “Globalization and Its Impact on Technological Development,” 41 st International Conference on Organizational Science Development, 2022, [Online]. Available: https://api.semanticscholar.org/CorpusID:249974620
S. Burlacu, M. D. O. Negescu, S. R. Pătărlăgeanu, and R. Vasilescu, “Digital globalization and its impact on economic and social life,” SHS Web of Conferences, p., 2021, doi: 10.1051/shsconf/202112906003.
A. Ambore, “Design and Development of a Smart POS App with Cloud,” Int J Res Appl Sci Eng Technol, p., 2023, doi: 10.22214/ijraset.2023.51484.
H. Asrani, S. Vishwakarma, D. Asrani, and D. Asrani, “Point of Sale Systems,” International Journal of Innovative Research in Computer Science and Technology (IJIRCST), p., 2024, doi: 10.55524/csistw.2024.12.1.63.
Y. Ramos and Á. Castro, “Point of Sales Systems in Food and Beverage Industry: Efficient Technology and Its User Acceptance,” vol. 6, pp. 582–591, 2017, [Online]. Available: https://consensus.app/papers/pointofsales-systems-in-food-and-beverage-industry-ramos-castro/73c65697abcd5c89a982a09bfce50bd9/
D. Rode and C. Stammen-Hegener, “Digital Technologies Within the DIY Store: A Systematic Literature Review,” Business Ethics and Leadership, p., 2022, doi: 10.21272/bel.6(2).116-126.2022.
Y. Bar-Zeev et al., “IQOS marketing strategies at point-of-sales: a cross-sectional survey with retailers,” Tob Control, vol. 32, p., 2022, doi: 10.1136/tobaccocontrol-2021-057083.
N. F. Waruwu and H. T. Amijaya, “Web-Based Sales Information System in One of The Cash Shops Using the Business to Customer Method,” Jurnal Computech & Bisnis, p., 2024, doi: 10.56447/jcb.v17i2.244.
S. F. Pane, A. Yanuar, A. F. Kurniawan, and M. Az, “Implementasi Middleware Pada Evomo Dengan Metode Web Service Restfull Dan Pengujian CI/CD, Coverage Serta Simulasi Protokol Grafana,” Jurnal Tekno Insentif, vol. 15, no. 2, pp. 110–121, 2021.
A. Golmohammadi, M. Zhang, and A. Arcuri, “Testing RESTful APIs: A Survey,” ACM Transactions on Software Engineering and Methodology, vol. 33, pp. 1–41, 2022, doi: 10.1145/3617175.
A. Ehsan, M. Abuhaliqa, C. Catal, and D. Mishra, “RESTful API Testing Methodologies: Rationale, Challenges, and Solution Directions,” Applied Sciences, p., 2022, doi: 10.3390/app12094369.
I. Engelbrecht and H. Steyn, “Does TDWG Need an API Design Guideline?,” Biodiversity Information Science and Standards, p., 2021, doi: 10.3897/biss.5.75372.
S. Hyrynsalmi, “The State-of-the-Art of the Integration Platforms as a Service research,” 2022 IEEE/ACM International Workshop on Software-Intensive Business (IWSiB), pp. 17–22, 2022, doi: 10.1145/3524614.3528634.
H. Bhardwaj, “Challenges with Implementation of Node.Js,” Int J Res Appl Sci Eng Technol, p., 2021, doi: 10.22214/ijraset.2021.37464.
H. Srivastava, S. Gupta, K. Anand, and A. Sharma, “PDF-Chat SaaS Platform Using MERN Stack,” International Journal of Innovative Research in Engineering, p., 2024, doi: 10.59256/ijire.20240501007.
C. Lee, H. F. Kim, and B. G. Lee, “A Systematic Literature Review on the Strategic Shift to Cloud ERP: Leveraging Microservice Architecture and MSPs for Resilience and Agility,” Electronics (Basel), p., 2024, doi: 10.3390/electronics13142885.
O. C. Oyeniran, O. T. Modupe, A. A. Otitoola, O. O. Abiona, A. O. Adewusi, and O. J. Oladapo, “A comprehensive review of leveraging cloud-native technologies for scalability and resilience in software development,” International Journal of Science and Research Archive, p., 2024, doi: 10.30574/ijsra.2024.11.2.0432.
S. F. Pane, R. M. Awangga, and B. R. Azhari, “Qualitative evaluation of RFID implementation on warehouse management system,” TELKOMNIKA (Telecommunication Computing Electronics and Control), vol. 16, no. 3, pp. 1303–1308, 2018.
S. Gawande and S. Jiwani, “Constructive Effect of Hybrid Project Management Methodologies on Success Rates of Projects,” International Journal of Science and Research (IJSR), p., 2024, doi: 10.21275/sr24929184750.
O. Hillaire, “Best Practices for Implementing a Hybrid Project Management Methodology,” p., 2018, [Online]. Available: https://consensus.app/papers/best-practices-for-implementing-a-hybrid-project-hillaire/a050dcb6c62b50fa93742c1ed335b57a/
N. Prenner, C. Unger-Windeler, and K. Schneider, “How are Hybrid Development Approaches Organized? - A Systematic Literature Review,” 2020 IEEE/ACM International Conference on Software and System Processes (ICSSP), pp. 145–154, 2020, doi: 10.1145/3379177.3388907.
T. Chen, K. J. Leong, M. Yee, O. Baitsegi, L. Palanisamy, and R. Ramasamy, “Hybrid Project Management between Traditional Software Development Lifecycle and Agile Based Product Development for Future Sustainability,” Sustainability, p., 2023, doi: 10.3390/su15021121.
P. Vijaya and V. Reddy, “New Hybrid Model with Fine Blend of Agile and Waterfall,” Indian Journal of Computer Science and Engineering, p., 2024, doi: 10.21817/indjcse/2024/v15i1/241501028.
A. Rahman, “IT Project Management Frameworks: Evaluating Best Practices and Methodologies for Successful IT Project Management,” ACADEMIC JOURNAL ON SCIENCE, TECHNOLOGY, ENGINEERING & MATHEMATICS EDUCATION, p., 2024, doi: 10.69593/ajaimldsmis.v1i01.128.
P. Sharma, “Impact of Agile Methodologies in Project Success,” Int J Res Appl Sci Eng Technol, p., 2022, doi: 10.22214/ijraset.2022.43204.
P. Amajuoyi, L. B. Benjamin, and K. B. Adeusi, “Optimizing agile project management methodologies in high-tech software development,” GSC Advanced Research and Reviews, p., 2024, doi: 10.30574/gscarr.2024.19.2.0182.
S. Chathuranga, S. Jayasinghe, J. Antuchevičienė, R. Wickramarachchi, N. Udayanga, and W. Weerakkody, “Practices Driving the Adoption of Agile Project Management Methodologies in the Design Stage of Building Construction Projects,” Buildings, p., 2023, doi: 10.3390/buildings13041079.
Downloads
Published
How to Cite
Issue
Section
License
Copyright (c) 2025 Nuansa Informatika
This work is licensed under a Creative Commons Attribution 4.0 International License.
