slick / slick

Scala Language Integrated Connection Kit

Website Github

Slick

Build Status Stories in Ready Gitter

Slick is a modern database query and access library for Scala. It allows you to work with stored data almost as if you were using Scala collections while at the same time giving you full control over when a database access happens and which data is transferred. You can write your database queries in Scala instead of SQL, thus profiting from the static checking, compile-time safety and compositionality of Scala. Slick features an extensible query compiler which can generate code for different backends.

The following database systems are directly supported for type-safe queries. These are the databases and driver versions that have explicit automated tests.

Database JDBC Driver Build status
SQLServer 2008, 2012, 2014 jtds:1.2.8 and msjdbc:4.2 Build status
Oracle 11g ojdbc7:12.1.0.2 Build Status
DB2 10.5 db2jcc4:4.19.20 Build Status
MySQL mysql-connector-java:5.1.23 Build Status
PostgreSQL postgresql:9.1-901.jdbc4 Build Status
SQLite sqlite-jdbc:3.8.7 Build Status
Derby/JavaDB derby:10.9.1.0 Build Status
HSQLDB/HyperSQL hsqldb:2.2.8 Build Status
H2 com.h2database.h2:1.4.187 Build Status

Accessing other database systems is possible, with a reduced feature set.

The manual and scaladocs for Slick can be found on the Slick web site.

Licensing conditions (BSD-style) can be found in LICENSE.txt.