Code Snippet Manager Using Flask and SQLite
DOI:
https://doi.org/10.63345/sjaibt.v2.i3.301Keywords:
Code snippet manager, Flask, SQLite, web application, database management, code reuse, search optimizationAbstract
In modern software development, developers often reuse existing code snippets to improve productivity and ensure consistency across projects. However, managing and retrieving these snippets efficiently remains a challenge. A Code Snippet Manager (CSM) offers a structured way to store, organize, search, and retrieve reusable code blocks, thereby reducing development time and enhancing maintainability. This paper presents the design and implementation of a Code Snippet Manager using Flask, a lightweight Python web framework, and SQLite, a self-contained SQL database engine. The system aims to offer a minimal setup process, user-friendly interface, and robust backend logic for persistent storage. The paper explores the architectural design, backend–frontend integration, and database schema optimization for efficient retrieval.
Downloads
References
• https://www.mdpi.com/applsci/applsci-13-10736/article_deploy/html/images/applsci-13-10736-g001.png
• Arul, S., & Kumar, R. (2019). A study on code reuse techniques in software engineering. International Journal of Computer Applications, 182(17), 12–17. https://doi.org/10.5120/ijca2019918710
• Bayer, J., & Muthig, D. (2006). Product line engineering: An overview. Software Engineering Institute Technical Report. Carnegie Mellon University.
• Burnette, E. (2010). Hello, Android: Introducing Google’s Mobile Development Platform (3rd ed.). Pragmatic Bookshelf.
• Chen, X., & Zhang, Y. (2021). Optimizing lightweight web application performance using Flask framework. Journal of Web Engineering, 20(6), 1735–1752.
• Dhanalakshmi, V., & Vasanth, K. (2020). A review on embedded database management systems. International Journal of Advanced Trends in Computer Science and Engineering, 9(3), 3442–3447. https://doi.org/10.30534/ijatcse/2020/152932020
• Flask. (2024). Flask documentation. Pallets Projects. https://flask.palletsprojects.com/
• Frakes, W. B., & Kang, K. (2005). Software reuse research: Status and future. IEEE Transactions on Software Engineering, 31(7), 529–536. https://doi.org/10.1109/TSE.2005.85
• GitHub. (2024). Gists. GitHub, Inc. https://gist.github.com/
• Han, Y., & Kamber, M. (2016). Data mining: Concepts and techniques (3rd ed.). Morgan Kaufmann.
• Hoffman, L. J., & Weiss, J. D. (2015). Portable database solutions for small-scale systems. Software—Practice & Experience, 45(9), 1213–1227. https://doi.org/10.1002/spe.2278
• Jansen, A., & Bosch, J. (2005). Software architecture as a set of architectural design decisions. 5th Working IEEE/IFIP Conference on Software Architecture (WICSA'05), 109–120. https://doi.org/10.1109/WICSA.2005.61
• Jha, A., & Kumar, S. (2018). Performance evaluation of SQLite database for embedded systems. International Journal of Engineering & Technology, 7(3.12), 616–621.
• Kumar, A., & Singh, P. (2017). Enhancing software productivity through reusable components. International Journal of Computer Science and Information Security, 15(2), 65–70.
• Locust.io. (2024). Distributed load testing tool. https://locust.io/
• Mertz, D. (2003). Text processing in Python. IBM DeveloperWorks. https://developer.ibm.com/articles/l-pythonscripts/
• Mohan, A., & Thomas, J. (2020). Search optimization in relational databases using full-text search. International Journal of Computer Applications, 176(16), 27–33. https://doi.org/10.5120/ijca2020920151
• Ousterhout, J. (2018). A philosophy of software design. Yaknyam Press.
• Pahl, C. (2007). Layered architectural styles for software-as-a-service applications. IEEE Software, 24(5), 81–87. https://doi.org/10.1109/MS.2007.139
• SQLite Consortium. (2024). SQLite documentation. https://sqlite.org/
• Williams, L., & Upchurch, R. L. (2001). Extreme programming for software engineering education? Proceedings of the 31st Annual Frontiers in Education Conference, 1, T23–T27. https://doi.org/10.1109/FIE.2001.963782
Downloads
Published
Issue
Section
License
Copyright (c) 2025 Scientific Journal of Artificial Intelligence and Blockchain Technologies
This work is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License.
The license allows re-users to share and adapt the work, as long as credit is given to the author and don't use it for commercial purposes.
