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:
- Derby/JavaDB
- H2
- HSQLDB/HyperSQL
- MySQL
- PostgreSQL
- SQLite
Support for Oracle, IBM DB2 and Microsoft SQL Server is available for production use by Typesafe subscribers (free for evaluation and development) in the Slick Extensions package. See the Slick manual for details.
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. There is some older documentation (which may still apply to some extent to Slick) in the ScalaQuery Wiki.
Licensing conditions (BSD-style) can be found in LICENSE.txt.