Strata workshop: Getting started with Cassandra

Downloading and installing Cassandra:

Linux/Mac:

curl -L http://downloads.datastax.com/community/dsc-cassandra-2.1.4-bin.tar.gz | tar xz

(or use home brew)

Then run:

./bin/cassandra

To start Cqlsh (may need to install Python)

./bin/cqlsh

Windows:

http://planetcassandra.org/cassandra/ or grab a USB key from me.

Workshop code (we may not get to this):

git clone https://github.com/chbatey/strata-cassandra-workshop

Cql docs:

http://docs.datastax.com/en/cql/3.1/cql/cql_intro_c.html

Cassandra docs:

http://docs.datastax.com/en/cassandra/2.1/cassandra/gettingStartedCassandraIntro.html

Java Driver Docs:

http://docs.datastax.com/en/developer/java-driver/2.1/java-driver/whatsNew2.html

Data modelling exercises:

First create the keysapce:

CREATE KEYSPACE killrauction WITH replication = {'class': 'SimpleStrategy' , 'replication_factor': 1 };

1) Get into CQLSH and create a table for users

- username

- firstname

- lastname

- emails

- password

- salt for password

2) Auction item table (no bids)

- name

- identifier?

- owner

- expiration

3) The bids

Data:

 - item identifier

 - bid time

 - bid user

 - bid amount

Considerations

 - Avoid sorting in the application

 - Two bids the same price?

 - Really fast sequential access

 - Current winner?