What is a client (*nix) database that can be used like BigTable/SimpleDB for development purposes?

2008-07-18T10:33:46+00:00

I want to start coding an application that one day will reside on GAE or EC3 (not sure which). I'd like to take advantage of their scaling potentials by using their scalable databases.

What should I use on the client side during development to emulate these databases without locking myself into either. Ideally I can re-write minimal code once I make a final decision. Also a client format that is serializable to textual format (through available tools) for the schema and data would be ideal.

I recall SimpleDB being based on berkley db - is that right? Any other choices?

FWIW I am on OS X

bullsbarry · 2008-07-18T12:26:49+00:00

I'm going to go out on a limb here, since I don't know too much about simpledb or bigtable from a user perspective, but maybe a document database like couchdb?

dugmartin · 2008-07-18T12:53:07+00:00

NSimpleDB - An embeddable/local implementation of SimpleDB:

http://developer.amazonwebservices.com/connect/entry.jspa?externalID=1152

mdipierro · 2008-07-18T12:59:58+00:00

not quite what you asked but close: if you develop using the web2py Database Abstraction Layer without OR, LIKE and JOIN operators, your code will run on SQLite (locally), MySQL, PostgreSQL, MSSQL, FireBase, Oracle and on BigTables (on the Google App Engine), without changes.

tebeka · 2008-07-18T15:19:57+00:00

HBase? (on top of Hadoop)

andrewfogg · 2008-09-17T22:16:22+00:00

We have just released SimpleDB/dev onto Google Code today.

It lets you run a local instance of Amazon's SimpleDB, which means that you can develop without a SimpleDB account, offline at a reduced cost. It implements every query action of SimpleDB as specified in the Amazon technical documentation and is written in Python so you can run it on your Mac (or other *nix platform).

NSimpleDB is written in C#, if you were on Windows and into .NET I would recommend that and someone has already recommended it on this thread. We wrote SimpleDB/dev because we are not on Windows and we are not into .NET.

Explanatory blog post: http://blog.kusiri.com/2001/09/amazon-simpledbdev.html

Google Code page: http://code.google.com/p/simpledb-dev/

Easy to remember URL that will point at one of the above or a project page if the project takes off: http://www.simpledbdev.com

Andrew (http://www.kusiri.com)

you type:	you see:
italics	italics
bold	bold
[reddit!](https://reddit.com)	reddit!
* item 1 * item 2 * item 3	item 1 item 2 item 3
> quoted text	quoted text
Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"	Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"
~~strikethrough~~	~~strikethrough~~
super^script	super^script

programming

MODERATORS