cassandra with play framework

Question

I am trying to develop an application composed of 2 parts: a web service and an android app. I am planning to implement my web service with the java play framework and cassandra noSQL database.

I have been searching for it for 2 days, I still don't know how I can do it. I need to integrate a java client (hector) as a bridge between the app layer (Play2.0) and the database layer, but how to do it is not clear to me.

Right now, I can not connect cassandra from play; I can not make my queries which my app needs and I dont know whether I can use play2.x like previous versions (without scala language, just java and groovy template).

allright, I am trying to develeop a web service which can be scalable horizontal easly. Because there will be many request, possible most of them at same time, from mobile phones. That is why I choose play frmwork with cassandra (I got enough knowledge about play with relational DB in collage last semester). my web service will return some data to client according to location info of client. That is why search time from DB must be as short as possible.Actually I have already designed my DB model for cassandra, because I already defined what kind of queries my app needs and I got enough information about cassandra data model. I think the tools i choosed for my app is correct and can maintain it. shortly, I can not use cassandra with play like I used MySQL with play :(

Answer 1

Also, PlayOrm for cassandra has a 1.2 and 2.0 playframework plugin and automatically reloads as playframework reloads so annotations take affect immediately in development. Lastly, it has the in-memory nosql db implementation as well so you can just start playframework without cassandra and work your butt off efficiently and connect to cassandra in QA and production.

Answer 2

See if it helps, a sample application hosted at github: https://github.com/firekat/play-kundera

-Vivek

Answer 3

There's nothing stopping you from using Cassandra with Play, just as you could use it with Jetty or Tomcat or any other front-end. Play has some tools available to abstract the usage of popular relational DBs, but these tools are not central to Play, and therefore you don't have to use them. You will need to create your DAL to talk to Cassandra using the library of your choice (Hector, Astyanax, etc.), then use that DAL as you would in any other app. Perhaps you are trying to do something different? If so, please be very specific as to what you need to know.

Also, Play2 is quite different from the first version, so anything you've done in the older Play will need to be revisited. It does still support Java, so that won't be an issue.