Amazon SimpleDB satisfies the hosting model I need for a project. Unfortunately, looks like it only supports PHP, C#, Java, Perl, and VB.NET. Does anyone know of any work to make it work with Ruby on Rails. Thanks, gk
The first question is whether there’s even a valid and sufficiently complete mapping between ActiveRecord and SimpleDB:
GET, PUT or DELETE items in your domain, along with the attribute-value pairs that you associate with each item. Amazon SimpleDB automatically indexes data as it is added to your domain so that it can be quickly retrieved; there is no need to pre-define a schema or change a schema if new data is added later. Each item can have up to 256 attribute values. Each attribute value can range from 1 to 1,024 bytes.
QUERY your data set using this simple set of operators: =, !=, <, > <=, >=, STARTS-WITH, AND, OR, NOT, INTERSECTION AND UNION. Query execution time is currently limited to 5 seconds. Amazon SimpleDB is designed for real-time applications and is optimized for those use cases.
If there is such a mapping, I for one would like to understand the limitations in RoR terminology. And if there is hope for being able to use SimpleDB with my current controllers, I for one would be very interested in contributing to the cause, whether that be coding or testing or docs or possibly even donations.
BTW, I’m working on a related concept: service-oriented memcached for Rails (big memcached in the sky).
There are several projects listed on sourceforge (or was it rubyforge?), but all seem to be in the early stages.
What are your requirements? S3, SimpleDB or both?
Well, it's the combination of pay-what-you-use hosting plan and the structured data storage system. Any such hosting plan offered for Postgres or MySQL, or SQLite3?
I recently completed work an a proxy server, allowing you to use Simple DB as a backend with Rails ActiveResource framework. Find the results here: