Establish a connection to Amazon Simple DB. Uses the awesome php-sdb2 SDB library.

Zach Tirrell

methnen

Gigaom Slog

A way to log occurances to an Amazon Simple DB (requires Gigaom Simple DB).

<p>Establish a connection to Amazon Simple DB. Uses the awesome <a href="https://github.com/g-g/php-sdb2" rel="nofollow ugc">php-sdb2</a> SDB library.</p>
<h3>Usage</h3>
<ol>
<li>Load simple db class
<ul>
<li><code>$go_simple_db = go_simple_db(<br />
YOUR_SDB_DOMAIN,<br />
YOUR_KEY,<br />
YOUR_SECRET<br />
);</code></li>
<li>The SDB Domain value is analagous to an SQL Table. If the SDB Domain doesn’t exist yet Gigaom Simple DB will create it for you.</li>
<li>See: <a href="http://docs.aws.amazon.com/AmazonSimpleDB/latest/GettingStartedGuide/Welcome.html" rel="nofollow ugc">Amazon Simple DB Getting Started Guide</a> for more information on getting your Key and Secret values.</li>
<li>Also see: <a href="http://docs.aws.amazon.com/AmazonSimpleDB/latest/DeveloperGuide/SDBLimits.html" rel="nofollow ugc">SDB Limits</a> to get an idea of what Amazon Simple DB allows as it’s not going to be the same as other databases you’ve worked with before.</li>
</ul>
</li>
<li>Write a row to the your SDB Domain: <code>$go_simple_db->putAttributes( YOUR_SDB_DOMAIN, array( 'post_id' => array( 'value' => '1234' ) ) )</code></li>
<li>Query your SDB Domain: <code>$go_simple_db->select( 'SELECT * FROM `' . YOUR_SDB_DOMAIN . '` LIMIT 100, NULL );</code>
<ul>
<li>In the case where you are getting the next chunk of results from you SDB Domain the NULL value in the code above would be replaced with a SDB Next Token (which essentially triggers an offset in the query) see the <a href="http://docs.aws.amazon.com/AmazonSimpleDB/latest/DeveloperGuide" rel="nofollow ugc">Developer Guide</a> for more info on that. </li>
<li>Queries are quite different in SDB and you’ll need to familiarize yourself with those differences.</li>
<li>Did I mention the <a href="http://docs.aws.amazon.com/AmazonSimpleDB/latest/DeveloperGuide" rel="nofollow ugc">SDB Developer Guide</a>?<br />
<h3>Contributing</h3>
<p>This plugin is developed and <a href="https://github.com/GigaOM/go-simple-db" rel="nofollow ugc">available on GitHub</a>. Contributions and questions are welcome!</li>
</ul>
</li>
</ol>


Alternatives to Gigaom Simple DB

Top alternatives