Squill: Not Another ORM
Abstract
The Java ecosystem has more or less settled on the leading ORM systems (Hibernate and TopLink), standardized by the JPA. However ORMs encourage selecting relatively large object graphs and lazy quering, which means that a large percentage of efficient queries are still written in JDBC/SQL (often with help from Spring JDBC or similar templates).
Instead of asbtracting away from the relational databases, Squill introduces a slick internal DSL to write SQL queries in pure Java. By generating the basic data objects from the table metadata it ensures that all queries are completely typesafe. It also makes it dead simple to select individual columns and requires explicit queries for selecting data. Finally, being a DSL close to SQL it can be optimized by the DBA with just a little assitance from the developer. Altogether this means that you get a safe and simple way to write SQL in Java without any kind of pre/postprocessing.
In this talk Jevgeni Kabanov will review how to start using Squill either from scratch or in an existing project. He will also go though typical queries, DSL idioms and lightweight ORM features that makes developing with Squill a pleasure.
Speaker
For the last five years, Jevgeni has been the R&D lead of Webmedia, Ltd, the largest custom software development company in the Baltics. During that time, he has spearheaded the movement to decrease the development turnaround time. As a result, two products (JavaRebel and JspWeaver) were developed under the trademark ZeroTurnaround, of which Jevgeni is the technical lead. Both projects contributed directly to the immense reduction in turnaround time. Jevgeni is also a co-founder of the open source Aranea and Squill projects. His personal blog can be found at dow.ngra.de.
