Using Amazon SimpleDB with Ruby on Rails

Using Amazon SimpleDB with RailsMartin Rehfeld@ RUG-B 07-Feb-2008Remember?AWS Rails ScenarioEC2S3Web Static ServerContentApplication }CodeServermemcached,backgrounDRb,...SQL HOW TO GET A DatabasePERSISTENT DB?Amazon SimpleDB limitedbeta• Database web service advertised as• Simple, Flexible, Scalable, Fast,Reliable, Inexpensive• No RDBMS: no SQL, no joins, no schema,no referential integrity, no transactions• HTTP-Interface• Pay per use:• $0.14 per Machine Hour consumed• $0.10-0.18 per GB - data transfer• $1.50 per GB-month storageAmazon SimpleDBCommon Terms• Domain:SimpleDBstorage container ~ table• Item:my domain A~ table rows accessed byattributes}}ID ~ primary key• Attribute:items~ table columns; every item (multiple) valuesmay have a different set of up to 256 attributesmy domain B• Value:...each Attribute may have multiple Values, always varchar(1024)[]SimpleDB @ no codeno codeno codeno codeno codeno codeno coderich API*(amazon_sdb)simply working!*) defect release 0.6.5 when evaluated, but newer release available (not re-tested yet)Amazon SimpleDB API• Domain level• CREATE, LIST, DELETE• Item level• GET, PUT, DELETE attributes with values• QUERY* for unordered item IDs by attribute values within one domain*) lexicographical =, !=, <, > <=, >=, STARTS-WITH, AND, OR, NOT, INTERSECTION / UNION• Beware: Eventual Consistency Approach!Almost RESTfulMapping RESTful URLsHTTP/RESTSimpleDBGET/domain?queryQUERYGET/domain/itemIDGET ATTRIBUTESPOST /domain/itemIDPUT ATTRIBUTESPUT/domain/itemIDPUT ATTRIBUTES(replace)DELETE/domain/itemIDDELETE ATTRIBUTESMapping RESTful URLsEmulating multiple resources in one domain via _resource attributeHTTP/RESTSimpleDBGET/domain/resource?queryQUERYGET/domain/resource/itemIDGET ATTRIBUTESPOST /domain/resource/itemIDPUT ATTRIBUTESPUT/domain/resource/itemIDPUT ATTRIBUTES(replace)DELETE/domain/resource/itemIDDELETE ATTRIBUTESA Bridge to RailsActiveResource„Rails XML“HTTP/REST?AWS SDB ProxyServer*„AWS XML“HTTP/SDB APISimpleDB*) http://inside.glnetworks.de/2008/01/20/bridging-rails-to-amazon-simpledb-using-activeresource/