I need to create a Joomla website that will also host a large table with 20 million records.
I would like to have it done in 2-4 days.
I will give you access to the Joomla site, completely built.--including Backend Administrator access and FTP access.
I will also give you all the data to be imported in the same consistent format (CSV files) .
Your job will be:
1. To import the 20 million records into the table. I would do this but I can't seem to make the MySQL "LOAD DATA LOCAL" command work. (I would like you to let me know how you solved this, problem for future reference.)
2. To install a user interface that will allow website visitors to query the above table.
We have purchased and can provide you a copy of Table JX (see: [url removed, login to view])--but you may propose a different extension if you can make a case for it. We need to implement a user interface that is powerful and user friendly, responds quickly, looks state-of-the-art, and can also download data to Excel or CSV (comma separated values) format. (Maybe using Ajax?). You should document the code or provide separate documentation for us so that we are able to add fields to the table later without "breaking" the user query interface.
3. To provide the menu option to access the page where the user can query and download the data from the 20 million records.
4. The ability to specify and limit the amount of records downloaded within a given period (examples: only 100 records per day, or 500 records per week, or 1000 per month) and also limit downloads by by user type (example: registered users can download 100 records per week, but administrators can download 500 records per week). You should create an appropriate interface for the site Administrator to set and modify these values.
Additional information, just for reference:
This does not need to be implemented in this project but just for your information: Later on, we might want to limit to registered users only the ability to query and download data. I might simply add a subscription component that will restrict the access to the download page menu option. This information is given simply so that you can implement the site functionality accordingly. We might also want to be able to access the data download page from different websites and cloak the URL to make the page look as being part of each different website.
Thank you in advance for bidding.