Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: pass (nike.apache.org: domain of synfinatic@gmail.com designates
 209.85.160.44 as permitted sender)
MIME-Version: 1.0
In-Reply-To: <000a01ccbb1a$867a0830$936e1890$@aon.at>
References: <000a01ccbb1a$867a0830$936e1890$@aon.at>
From: Aaron Turner <synfinatic@gmail.com>
Date: Fri, 16 Dec 2011 10:39:03 -0800
Message-ID: 
 <CANAZdzUM=SoiUZAYS_xg3N0nxtastegWsC4N4+N+JpfYsPC4zw@mail.gmail.com>
Subject: Re: Using Cassandra in Rails App
To: user@cassandra.apache.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

On Thu, Dec 15, 2011 at 3:13 AM, Wolfgang Vogl <aon.912508284@aon.at> wrote=
:
> Hi,
>
> I have a couple of questions about working with Ruby on Rails and Cassand=
ra.
>
>
>
> What is the recommended way of Cassandra integration into a Rails app ?
>
> active_column
>
> cassandra-cql
>
> some other gems?
>
>
>
> Is there any reference implementation?
>
> some projects on github that are using the gems?

Depends on what you're trying to use Cassandra for with Rails.  In my
project we're using a SQL DB for meta data and Cassandra as our heavy
lifting datastore for time series data.  After looking at the
available Ruby drivers a few months ago (things have changed since
then btw), I decided to go with JRuby + Hector. This fit in well with
some other requirements I had which JRuby was a great fit (like real
threads) and TorqueBox as my application server.

Due to how my data is stored, it didn't really matter if I used
Hector, CQL or ActiveRecord, I was going to need to write an
abstraction layer on top to make it easier to store & retrieve data.
And using Hector meant I was using one of the most mature, stable and
tested libraries for accessing Cassandra.

My project is big enough that not everything is done in RoR... there
are some cron jobs as well doing some Map/Reduce like jobs as well.
This is where JRuby+Hector really shines since for high performance
you really need your client to be multi-threaded since the single
threaded performance of Cassandra isn't anything to write home about.

Anyways, I'm not sure I would recommend JRuby+Hector if this is the
only reason you'd use JRuby over MRI, but if you might find the
plethora of Java libraries useful it's definitely worth looking into.

--=20
Aaron Turner
http://synfin.net/=A0 =A0 =A0 =A0=A0 Twitter: @synfinatic
http://tcpreplay.synfin.net/ - Pcap editing and replay tools for Unix & Win=
dows
Those who would give up essential Liberty, to purchase a little temporary
Safety, deserve neither Liberty nor Safety.
=A0 =A0 -- Benjamin Franklin
"carpe diem quam minimum credula postero"