Amazon SimpleDB ang Ruby

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).

Cheers,

m

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?

-- Long

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:

http://inside.glnetworks.de/2008/01/20/bridging-rails-to-amazon-simpledb-using-activeresource/

Cheers, Martin