Migrate to a Database

[bhaveshittadwar]

Right now file operations are used for data persistence. Consider using a database to replace all the redundant file read and write operations.

[bhaveshittadwar]

Try to replace all

read/write operations in

1. add.py
2. code.py
3. helper.py
4. All instances in the test directory

with simple CRUD operation after deciding on which type of database to go with.

The issue is relevant because with file handling comes these challenges:

1. Lack of Data Integrity
2. Concurrency and Locking Issues
3. Scalability Challenges
4. Limited Data Structuring
5. No Built-in Security
6. Limited Query Performance
7. Backup and Recovery Challenges
8. Data Redundancy
9. No ACID Transactions
10. Data Sharing and Collaboration
11. Maintenance Complexity

Plan of action:

1. Decide on a type of database
2. Pinpoint the most apt database management system
3. Think if we want to store it locally or set up a remote database server
4. Document and design the database operations needed to replace the file operations