Database Appliction
Posted: Tue Jan 05, 2010 8:58 am
OK I have an idea. I have a database of UPC codes, all of them, millions of rows. No problem but why can't I stuff it into the MySQL and search based on UPC and then add columns of data that is of interest.
So I see the need for a loader to get the CSV into MySQL, and a form for editing the row and inserting any information users might contribute.
There is an update for the UPC list, so iserting the difference is needed to keep it up to date.
The UPC datasbase should be separate from the other tables and a relation used. This way other projects can use the UPC database for an entirely different application.
How much work is this? And is there any code examples around this concept that could act as a reference/starting point?
So I see the need for a loader to get the CSV into MySQL, and a form for editing the row and inserting any information users might contribute.
There is an update for the UPC list, so iserting the difference is needed to keep it up to date.
The UPC datasbase should be separate from the other tables and a relation used. This way other projects can use the UPC database for an entirely different application.
How much work is this? And is there any code examples around this concept that could act as a reference/starting point?