Building a Secure and Scalable Web Application using SQLite Database

Desklib provides past papers and solved assignments for students. This project explores building web applications using SQLite.

SQLite in web-based applications
Contents
Introduction...........................................................................................................................................2
The aim of the project...........................................................................................................................3
The objective of the project..................................................................................................................3
Background of study..............................................................................................................................4
Demerits of the website:.......................................................................................................................4
Literature Review..................................................................................................................................4
Proposed Methodology.........................................................................................................................5
Expected outcome:................................................................................................................................5
Proposed the budgets...........................................................................................................................5
Legal, ethical social consideration.........................................................................................................6
Conclusion.............................................................................................................................................7
References:............................................................................................................................................8
Tables of Figures
Figure 1: Gnatt Chart 1..........................................................................................................................5
Figure 2: Gnatt Chart 2..........................................................................................................................6

Introduction
The assessment consists of the make website based on the SQLite which is a relational database
management system. The database in this does not have any type of configuration in the system. It
basically contains the database of the website into the single cross-platform disk file. The data can
be collected with the help of the data analysis using python in which we can collect open website
and can do a scraping of the website. The assessment will help to make the website good enough
and helps to make the best website using the SQLite.

The aim of the project
The main aim to achieve in the project is to make a website based on the SQLite which is a relational
database management system.
The objective of the project
To make the project successful there are some points which keep in mind, that is some plane has to
be there to achieve the web-based application using SQLite :
 Web traffic: How much database can be handled in a website.
 Single VM: Only the use of single passage for the database to store the information on the
website.
o The literature on SQLite:
Basically, the SQLite is the library of the C which has the zero configurations, self-
contained. The database in this does not have any type of configuration in the
system. It basically contains the database of the website into the single cross-
platform disk file. The database consists of the standalone but the SQLite does not
have the standalone process. The SQLite is very light and small therefore it is used in
the website to holds the number of the database of the website. No external
dependence is followed by the SQLite
*gnat chart*
o Expected area of difficulties in the web-based application
 Client/server application
 Very large dataset
 The high volume of website
 High concurrency
These are the basic major from where the difficulties can occur while
designing the website by SQLite.
o Review of the website usage in industry
 The website helps in the industry to build better sales.

 The website gives opportunities to their credibility.
 The website helps the industry sectors to give information of their own
sector to assess the things.
 It provides good links.
 It helps the better relationship with the customers.
 It helps to update the fresh content of the industry that’s what going on the
industries.
 It also provides state employment to the developers and for building the
website the industry may hire the person to provide the best website and
change its frontend look in few months so that the person on website more
attraction.
Background of study
The project is to make a website based on the SQLite which is a relational database management
system. The database in this does not have any type of configuration in the system. It basically
contains the database of the website into the single cross-platform disk file. There is the basic major
from where the difficulties can occur while designing the website by SQLite so to resolve them and
build the best website with the help of SQLite. The website basically helps to build more contacts
with the number of person over the world. This platform is very easy and simple.
Demerits of the website:
 Reliability: The information of the organization may not be updated this will leads to
misunderstanding between the owner and visitors.
 Crashes: If the website is crashed then it would be difficult to fetch the data of the website.
 Fetching people may not be easy: The website provides contact with people but he may
provide fake details and therefore they may do something fraud and may run out.
 SPAM: This provides junk mail.
 Bad Publicity: Risks attracting bad publicity will lead to happy customers.
Literature Review
The SQLite is very light and small therefore it is used in the website to holds the number of the
database of the website. No external dependence is followed by the SQLite. Basically, the SQLite is
the library of the C which has the zero configurations, self-contained. The database consists of the

standalone but the SQLite does not have the standalone process. The database in this does not have
any type of configuration in the system. It basically contains the database of the website into the
single cross-platform disk file.
Proposed Methodology
To build a website there is a need to collect the relevant data and implement it into the program. To
collect the data there is a need to go through the journals. The data can be collected with the help of
the data analysis using python in which we can collect open website and can do a scraping of the
website.
Expected outcome:
The project needs the input and there should be some output expected so in this project the output
comes in the form database that in the website open has to fill the login details and that details have
to be stored in the database of SQLite.
Proposed the budgets
The budgets have to be proposed to make the website in terms of the resources, manpower etc. The
budget of the website should be good enough like in this website there is the need for HTML/CSS
coders, proper internet connection, xmapp, SQLite person who has the knowledge. The budgets
need to build a website is $500 which will the best website.
Figure 1: Gnatt Chart 1

Figure 2: Gnatt Chart 2
Legal, ethical social consideration
To build the website there is the need to follow the rule and regulation of the law to build the
website example the footer should consist of some copyright, terms, and conditions etc.. The data
protection is the issues faced by the industry. The data can assess by the authorized person to
change anything in the database. The hackers should be hired to check the website can be hacked or
not. The security is the main purpose of the website because there are payments method and many
more things which will help the person to pay the payment securely.

Conclusion
The above report consists of the SQLite in the web application that how it can be beneficial for them.
The literature of the SQLite is also shown here. No external dependence is followed by the SQLite.
The database consists of the standalone but the SQLite does not have the standalone process, The
SQLite is very light and small therefore it is used in the website to holds the number of the database
of the website. The above is clearly and easily understands by the person to build the website and
what measure should be kept in mind to build the website.

References:
Patil, D. N., & Meshram, B. B. (2019). Web Browser Analysis for Detecting User Activities.
In Recent Findings in Intelligent Computing Techniques (pp. 279-291). Springer, Singapore.
Fobe, T. L., Kazakov, A., & Riccardi, D. (2019). Cys. sqlite: A structured-information
approach to the comprehensive analysis of cysteine disulfide bonds in the Protein
Databank. Journal of chemical information and modeling.
Zhang, L., Hao, S., & Zhang, Q. (2019). Recovering SQLite data from fragmented flash
pages. Annals of Telecommunications, 1-10.
Bernhardy, K., Fowler, Z., & Goldberg, S. (2019). U.S. Patent Application No. 15/993,538.
Bogomolov, A. (2019). Semantic Marking Method for Non-text Documents of Website
Based on Their Context in Hypertext Clustering. Recent Research in Control Engineering
and Decision Making, 199, 313.
Carroll, J., & Bennett, P. (2019). U.S. Patent Application No. 16/173,812.
Roaf Ahmad Parray, I. M., Kumar, A., & Khura, T. K. (2019). Development of web-based
combine harvester custom-hiring model for rice–wheat cropping system. CURRENT
SCIENCE, 116(1), 108.
Yeomans, C., Kenny, I. C., Cahalan, R., Warrington, G. D., Harrison, A. J., Hayes, K., ... &
Comyns, T. M. (2019). The design, development, implementation and evaluation of
IRISweb; A rugby-specific web-based injury surveillance system. Physical therapy in
sport, 35, 79-88.
Asim, M., Amjad, M. F., Iqbal, W., Afzal, H., Abbas, H., & Zhang, Y. (2019). AndroKit: A
toolkit for forensics analysis of web browsers on android platform. Future Generation
Computer Systems, 94, 781-794.
Patil, D. N., & Meshram, B. B. (2019). Web Browser Analysis for Detecting User Activities.
In Recent Findings in Intelligent Computing Techniques (pp. 279-291). Springer, Singapore.
Basit, N., Hendawi, A., Chen, J., & Sun, A. (2019, February). A Learning Platform for SQL
Injection. In Proceedings of the 50th ACM Technical Symposium on Computer Science
Education (pp. 184-190). ACM.
Papshev, S., Sytnik, A., Melnikova, N., & Bogomolov, A. (2019, February). Semantic
Marking Method for Non-text Documents of Website Based on Their Context in Hypertext
Clustering. In International Conference on Information Technologies (pp. 313-323).
Springer, Cham.

Roaf Ahmad Parray, I. M., Kumar, A., & Khura, T. K. (2019). Development of web-based
combine harvester custom-hiring model for rice–wheat cropping system. CURRENT
SCIENCE, 116(1), 108.