I am looking for a developer to write a small application that will allow me to query 2 large databases (I have CSV files) quickly via a RESTFUL API interface. This application MUST be written in Ruby and can be written in Sinatra or Rails.
In addition, you should also implement a small, search-based front end that allows a person to enter a search to search the database.
The REST interface should return a JSON result (simply what is in the table, labeled correctly).
You will be responsible for installation of these two databases on our VPS server ([url removed, login to view] or Dreamhost), and configuration to make operational.
All of your source code will be stored on Github.
For a rails programmer or sinatra programmer, this should be a quick project. The biggest time factor will be uploading the data and figuring out a good, effective way to store it.
The two databases are 1) 16 million records, and 2) 245 million records. And, these will grow over time.
If you have any questions, please ask.
Please ensure that your software looks acceptable (simple and functional). This will need to run in a modern environment (Rails 3 or current version of Sinatra).
* * *This broadcast message was sent to all bidders on Sunday Jan 2, 2011 8:48:01 AM:
All, I've been asked what the columns are: The two databases we are implementing are the 245 million record US keyword database (and its related Cloud (related keywords) database, and the 16 million Domains database listed on [url removed, login to view] I'd like a simple, one line (like google) front end place where I can search for a keyword and get the closest matching results in a table. Both of these should be behind a user/pass login system. There can be a single login (it can be simple). An API style interface, where we can generate APIs and track keys is nice, but not required. If you do it, it's a bonus. Right now, this is needed for an internal system. Hope that helps.