Open Vibhu-Agarwal opened 4 years ago
hello sir, i am interested in the issue. can you please tell me which database to be used and which data has to be migrated to the database.
Hi, Can you please provide some more details so that we will proceed further?
The application currently stores all its data in excel sheets and pickle files, basically a file system. If the data storage is migrated to databases, it will be easy and efficient to query the data. Moreover, there can be a hosted DB on the cloud which could later serve as a central storage system for the application instead of the files getting stored locally on the user's system.
Though the issue mentions migration of storing the data to a database, the application would still need some functionality to render excel sheets files from the data whenever necessary, because it's easy for people to view the data in excel sheets, which serve as an excellent form of storing soft-copy of attendance registers.
The issue requires a bit of discussion though as to which Database would suit the application. Feel free to elaborate your thoughts on the choice of DB in the thread.