Introducing Troy: The schema-safe Cassandra toolkit - Advanced

8th December 2016 in London at Business Design Centre

There are 57 other SkillsCasts available from Scala eXchange 2016

Please log in to watch this conference skillscast.

607924786 640

Troy is an open source macro-based Cassandra driver, similar to Slick and Quill, provides type-safe & compile-time checking for database queries. Nevertheless, it doesn't impose a DSL to express the queries in Scala. Instead, it allows developers to write plain Cassandra-query-language (CQL) queries within Scala code, complete with schema validation. In addition, it provides cross-validation against the previous versions, ensuring safe and smooth schema migrations.

It is worth noting that Troy doesn't connect to Cassandra during compilation. Instead, the schema is provided as CQL scripts, checked-in within same code base, consisting of plain CREATE TABLE CQL statements. That get's loaded at compile-time into a light-weight Schema engine capable of analysing queries and providing information about column types. Those CQL scripts can be written as increments, by adding new scripts containing ALTER TABLE statement, instead of editing existing scripts. This allows Troy to check backwards and forward compatibility of queries against different versions of the schema. As well as providing tools to write migration scripts.

Currently, Troy uses reflection-based black-box macros. But also has a working proof-of-concept using the new style inline/meta as well.

There will be slides and code, along with live coding examples.

The Call for Papers is now open for Scala eXchange 2017! Submit your talk for the chance to join a stellar line-up of experts on stage. Find out more.

Get your tickets for Scala eXchange 2017!


Introducing Troy: The schema-safe Cassandra toolkit - Advanced

Tamer AbdulRadi

Tamer is the author of Troy, the schema-safe Scala Cassandra driver. He has been building stuff with Scala since 2012, now he is a senior software engineer at Cake Solutions.