Playing with Panda without SimpleDB account
If you are interested in trying out panda without getting a SimpleDB account we’ve got good news for you!
There are currently 2 simpledb like tools at this moment(as far as I know). They won’t be for production use, but should be enough to play around or use it for development purpose.
- simplerdb = Ruby implementation.
- simpledb-dev = Python implementation
I initially tried simplerdb, but found that the implementation is not complete, therefore not suitable for Panda use. Also it’s an in-memory db, so the data will be lost every time you stop simplerdb.
I then tried simplerdb-dev(the Python one). simpledb-dev stores data on file systems, so you don’t need to worry about losing data every time you stop simpledb-dev. However, EC2 vapors every time you restart the instance, so you still need to use
Amazon Elastic Block Store to keep your data.
Here are the quick steps to use simpledb-dev at Panda. Please give a try and let me know if you find any issues. If people find this solution useful, I will add simpledb-dev into next AMI release image, and also update the documentation.
-
Setup simplerdb-dev on your EC2 instance.
#You can skip this part if python version is already 2.5 apt-get update apt-get install python2.5-dev rm /usr/bin/python ln -s /usr/bin/python2.5 /usr/bin/python # This step is to install easy_install, Python equivalent of Gems. # If you are installing Panda locally on your machine (I only tried on OSX Leopard), # you may already have easy_install, so you can skip it. curl -O http://peak.telecommunity.com/dist/ez_setup.py python ez_setup.py # Installing Web module easy_install web.py # Downloading simpledb-dev wget http://simpledb-dev.googlecode.com/files/simpledb-dev-0.1.5.zip unzip simpledb-dev-0.1.5.zip cd SimpleDB-Dev/ cd src # Starting simpledb_dev server python simpledb_dev.py 8087 (can be any port number.). Open up another terminal, and follow up to “Configure Panda” section of Getting Started guide
-
Override simpledb url, before “Create S3 buckets and SimpleDB domains” of Getting Started guide. Add the following line at the beginning of config/aws.rb file of Panda
Amazon::SDB::Base::BASE_PATH = 'http://127.0.0.1:8087' -
Continue “Create S3 buckets and SimpleDB domains” of Getting Started guide. Once it’s all done, confirm via console that you can connect to simpledb-dev
$cd /var/local/www/panda $merb -i ~ Loaded DEVELOPMENT Environment... ~ loading gem 'merb-assets' ... ~ loading gem 'merb-mailer' ... ~ loading gem 'merb_helpers' ... ~ loading gem 'uuid' ... ~ loading gem 'to_simple_xml' ... ~ loading gem 'rog' ... ~ loading gem 'amazon_sdb' ... ~ loading gem 'simple_db' ... ~ loading gem 'retryable' ... ~ loading gem 'activesupport' ... ~ loading gem 'rvideo' ... ~ loading gem 'panda' ... ~ loading gem 'gd_resize' ... ~ loading gem 'map_to_hash' ... ~ loading gem 'spec_eql_hash' ... ~ loading gem 'error_sender' ... ~ Compiling routes... ./config/aws.rb:1: warning: already initialized constant BASE_PATH ~ Starting Merb server listening at 0.0.0.0:4000 irb(main):001:0> Amazon::SDB::Base::BASE_PATH => "http://127.0.0.1:8087" irb(main):002:0> User.query => [#<User:0xb71fda08 @key="admin", @new_record=false, @attributes=#<Amazon::SDB:: Multimap:0xb71fd9e0 @size=nil, @mset={}>>] irb(main):003:0> Profile.query => [#<Profile:0xb71dc1c8 @key="561e38b0-706e-012b-b437-123138002d32", @new_record=false, @attributes=#<Amazon::SDB::Multimap:0xb71dc1a0 @size=nil, @mset={}>>, #<Profile:0xb71dc1b4 @key="562ef420-706e-012b-b437-123138002d32", @new_record=false, @attributes=#<Amazon::SDB::Multimap:0xb71dc164 @size=nil, @mset={}>>, #<Profile:0xb71dc18c @key="56101ea0-706e-012b-b437-123138002d32", @new_record=false, @attributes=#<Amazon::SDB::Multimap:0xb71dc128 @size=nil, @mset={}>>, #<Profile:0xb71dc150 @key="5621fa70-706e-012b-b437-123138002d32", @new_record=false, @attributes=#<Amazon::SDB::Multimap:0xb71dc0ec @size=nil, @mset={}>>, #<Profile:0xb71dc114 @key="56dd8600-706e-012b-b437-123138002d32", @new_record=false, @attributes=#<Amazon::SDB::Multimap:0xb71dc0b0 @size=nil, @mset={}>>]
Enjoy
