Database Security Application
Database Security Application
The purpose of this project was to demonstrate how to secure an application that is connected to a SQL database. Regular expressions were used to filter any harmful input from users to prevent database exploitation. C++ and SQLite were used here to write the application, and set up the SQL database. Then the application was ran in a Linux environment for thorough testing.
The purpose of this project was to demonstrate how to secure an application that is connected to a SQL database. Regular expressions were used to filter any harmful input from users to prevent database exploitation. C++ and SQLite were used here to write the application, and set up the SQL database. Then the application was ran in a Linux environment for thorough testing.
The purpose of the project was utilize regular expressions with a preferred language and write a phone listing application that interfaced with a database of choice. In my case, I chose to work with SQLite. A regular expressions table was created that only allowed certain input to be provided by a user. This ensured that no malicious commands could be sent to the database to cause any damage. A logs file was also generated to allow viewing of what changes were made to the database.
The purpose of the project was utilize regular expressions with a preferred language and write a phone listing application that interfaced with a database of choice. In my case, I chose to work with SQLite. A regular expressions table was created that only allowed certain input to be provided by a user. This ensured that no malicious commands could be sent to the database to cause any damage. A logs file was also generated to allow viewing of what changes were made to the database.
This turned out to be quite a powerful tool and will most definitely be used in any future applications that require user input.
This turned out to be quite a powerful tool and will most definitely be used in any future applications that require user input.
