Sanjeev 46 Posted January 22, 2014 Report Share Posted January 22, 2014 Fellas?I am building a bot which scrapes 'item name','item price' & 'no.of items sold' daily from a websiteIf I create a database with a table called 'item_info' - how would I go about updating it daily?The Thing is - I need to keep track of daily increments/changes to both - 'item price' & 'no.of items sold'. I.E - I need to maintain a history of daily changes to both - 'item price' & 'no.of items sold'.would be needed for graphing and analysis. Do I need to create a new table for each day?If yes - then could some one tell me how many tables can a single database file handle inside sqlite?I'm confused about how to best approach this..Please helpThanks. Quote Link to post Share on other sites
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.