I am in need of a custom solution to track hundreds of thousands of domain names and bits of information about each domain.
I am open to solutions on how to achieve this. I currently use MS Excel maintain this data but the limitations of Excel (65,000 entries) are making it difficult to track everything.
Below are some of the requirements of what I need:
- Unlimited Domain Entries
- Data About Each Domain
* Overture Score
* Alexa Score
* Google entry count
* Date domain originally entered
* Date domain updated
* Datbase date from Overture and Alexa data
* Plus others as needed
- Sort domains by all above data
- Sort domains and data alphabetically
- Sort by domain country code (.com , .eu , .[login to view URL], etc.)
- Be able to report biggest changes in score from one month to the next (able to select the month and the data - Alexa, Overture, etc.)
- Easy way to enter new data
- Remove any duplicate domains automatically
I will include more complete information as needed. As mentioned above, I am open to suggestions on how to solve this problem. It needs to run on Windows XP. Perhaps an Access or MySQL database with VB or Perl to mamipulate the data?
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
Windows XP
Access or MySQL
VB, Perl, C++, or whatever.
Not particular on what technology is used as long as it works.