Giant but simple database - how to build
February 5, 2010 5:53 AM Subscribe
What is best method to create a non-techy local interface for a 40M+ record database that I'd like to host on my web server? I'd like to regularly import new data, crunch it, and export specific CSV reports (which will be much smaller than 40M rows).
posted by mtstover to computers & internet (2 answers total)
The data will be essentially a 40M row record of address files. I will receive new data every month. I want to query it and export reports that will be a 70K row DB. Ideally these could be automated and output to a webserver.
I will also want an easy way to just look at and play with the data a bit. I am familiar with MS Access in running basic reports, etc, and would love to be able to use that to play with the data (rather than getting fancy with SQL all the time).
I have a webserver with mySQL setup and running.
I plan on using an Elancer to set this up for me and get it running with sample data. What should I ask them to do?