Cloud computing: scalable DB

[Andre Garzia]

David,

I've been looking at the same things. I am a user of Amazon S3 and I made
tests with SDB as well (not from rev at this time).

Depending on the data you want to store, you might want to check out the
following noSQL databases:

* CouchDB http://couchdb.apache.org/
* MongoDB http://www.mongodb.org/ (there's a mongo db hosting service at
MongoHQ )
* Cassandra http://cassandra.apache.org/
* Riak http://riak.basho.com/

I think these are the future of storage for stuff that is not "too
relational". We don't have plugins/adaptors/code to link to any of those
tools but if you're going to write yourself a plugin why not something like
these?

RDBMS are quite complex tools and sometimes they are used for the wrong job
and then designing table schemas become like trying to teach an elephant to
ice skate, if you're patient and wise enough, the elephant will eventually
be able to ice skate but anyone looking into it will be at the same time
amazed and afraid.

I think most of the data we're trying to store these days is document based
where we have something abstract which we call a document and this document
have properties and fields where we store data or other documents such as an
address book can have different entries and fields for different contacts.
This kind of "problem" is easily solved with the above solutions and harder
to code with plain old relational systems.

Hope this is useful

Cheers
Andre



On Tue, May 18, 2010 at 8:23 AM, David Bovill <david at architex.tv> wrote:

> I'm looking into an application which needs a highly scaleable back end
> database. One with low up front costs and yet won;t fall over if it
> suddenly
> takes off. I've noticed Jerry and others describing On-Rev in terms of
> "cloud" storage - but AFAIK it is a simple shared host, and there are no
> services on offer with regard to scaling or true cloud computing?
>
> So - I am looking at using true cloud based database solutions. On-Rev
> would
> provide that administrative functions but web plugins on users own web
> sites
> would directly call the cloud computing backend. I'm looking to prototype
> this in revWeb and then implement the plugins in a suitable AJAX framework.
> It seems to be that this is now a reasonable approach to take given the
> existing state of these services - but I'm only reading about them and
> would
> love some feedback from others on the list.
>
> In particular I am looking at using Amazon - either their
> SimpleDB<
> http://developer.amazonwebservices.com/connect/entry.jspa?externalID=2552&categoryID=146
> >,
> or their Relational Database
> Service<http://aws.amazon.com/rds/?ref_=pe_8050_15319810>,
> but maybe also Google equivalent services? Anyone tried these - I've only
> used Amazon S3 for file storage to date?
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution
>



-- 
http://www.andregarzia.com All We Do Is Code.