Tag: php

  • AWS SimpleDB and Auto Incrementing Primary Keys

    I wanted some of my items in simpledb to have unique identifiers. SimpleDB does not provide this function natively because it’s not an RDBMS. Here’s my solution: Before inserting a new item, get the id from the last item in the domain with this select: $query = $sdb->select(“select id from `domain` where id is not…

  • Explicitly Setting an AWS SimpleDb Region in PHP

    I am experimenting with AWS SimpleDB on a new PHP project. When I attempted to query a domain, I got no response. I used firephp (firephp.org) to log the result of the query in firebug. The result was a CFResponse object. By looking inside the object, I saw that it produced a “No such domain”…