Slick 3.1.0-RC2

September 25 2015
by Stefan Zeiger

We have just released Slick 3.1.0-RC2, the second release candidate for Slick 3.1.0. You can find the source code here: https://github.com/slick/slick/tree/3.1.0-RC2. Builds for Scala 2.10 and 2.11 are available from Maven Central, as usual.

These are the major new features since 3.0:
  • New query compiler back-end. The main goal is to avoid subqueries wherever possible.
  • Improved support for monadic joins in the query compiler. In particular, whenever a monadic join cannot be translated into an applicative join (as required for SQL), the query compiler will fail with a useful error message instead of producing invalid code.
  • Improved configuration of database connections via Typesafe Config: You can now configure arbitrary DataSource classes with Java Bean semantics when running without a connection pool (similar to what was already supported by HikariCP).
  • Configurable class loading when resolving Slick drivers: In containers which separate parts of an application into different ClassLoaders (e.g. Play, OSGi), the previous approach of using Class.forName did not work in all cases. You can now provide a custom ClassLoader, and Slick will fall back to the context ClassLoader in other cases.
  • Support for HikariCP is now in a separate module which makes it easier to depend on the correct, binary compatible version of HikariCP.
  • Database connections can be configured through a DATABASE_URL syntax as used on PaaS platforms like Heroku.
  • New query operators “distinct” and “distinctOn”.
  • Performance improvements in the query compiler. Query compilation is now more than 2.5 times as fast as it was in 3.0.

None of the standard Activator templates are available at the moment. They will be ported to 3.1 before the final release. You can find details about upgrading from Slick 3.0 in the Migration Guide. The commercial Slick Extensions package with additional database drivers is also available for this RC. See the manual for details on adding it to your build.

Please provide feedback on the stability of this RC if you encounter any problems.

Here is a complete list of changes since 3.1.0-RC1:
  • cb64121 Release 3.1.0-RC2
  • 5b5ff92 Allow insert operations with no columns to insert.
  • aff4896 Fix typing bug in rewriteJoins:
  • afd6f9b Allow illegal length CHAR defaults to be ignored in JdbcModelBuilder
  • b739255 Some bug fixes concerning Option types:
  • 84cc95a Add Query#subquery as a precaution for implementing workarounds.
  • 8f8ae8b Prevent repetition of bind variables used in GROUP BY:
  • 7199b51 Add countDefined operator:
  • 35b698d Fix source links for Slick core scaladocs
  • 0cfff09 Remove transaction handling from JdbcBackend#Session:
  • 29271b1 Add test cases for Options of primitive types.
  • 007e287 Trampolining for chained DBIOActions
These are the changes from 3.0.0 to 3.1.0-RC1:
  • 9c0d371 Release 3.1.0-RC1
  • d2e50d4 Remove dependent types for .delete and .findby extension methods.
  • 5cbabf6 Add documentation for default string type changes
  • ebfb344 Ensure non-empty “select” clauses in mergeToComprehensions:
  • f82a8fe Better integration of expandConditionals into expandSums
  • 07cd37a Allow selective translation for Take or Drop in removeTakeDrop:
  • dc1c551 Correctly propagate a Driver object to DriverDataSource
  • 6cb62b8 Integrate expandConditionals into expandSums
  • d286c17 Selectively skip compiler phases:
  • 9d8bbee Add Query.distinct and Query.distinctOn operators
  • 04ca00d codegen: schema: Handle case of no tables
  • 53cb788 codegen: Test case of no tables (schema has invalid syntax)
  • bc90afe A simpler and faster implementation of assignUniqueSymbols
  • 969ec5f Use correct discriminator checks under three-valued logic
  • e6acabf Some type-related fixes and improvements from tmp/globaltypes2
  • bcdeeaa Prevent retry of lazy Connection acquisition attempt in BaseSession:
  • 1634965 More intelligent handling of String types on MySQL
  • da7aaa9 Create correct syntax for casts on MySQL
  • c9bdcb1 More micro-optimizations and streamlining of ConstArray use
  • 2adb7c3 Use a custom collection implementation in the AST:
  • b48115a Profiling settings plus small performance improvements
  • 8ac4298 Only set Hikari dataSourceClassName or driverClassName but not both
  • 8dac76f Add two more expr customization for pg current_date and current_time
  • 1c9469f Scalar optimization & better discriminator column picking:
  • b01e539 More query compiler performance improvements:
  • b87c994 Eliminate explicit outer join discriminator columns where possible
  • 34bf73f Set Slick Extensions version in the manual independent of Slick version
  • 3bd24cc Some small query compiler performance optimizations:
  • a71aff4 Add detectRebuild option to mark rebuilt leaf nodes after each phase:
  • ed2af9b Add a benchmark for the query compiler.
  • 7333bd9 More consistent Query.length (“COUNT(*)”) semantics:
  • 16be008 Fix docs and simplify (no binary compatibility constraints for 3.1)
  • c197fdb Move HikariCPJdbcDataSource into a separate module
  • b651a62 Clean up the build file
  • 764b405 Avoid subqueries around zipWithIndex operations
  • 7514666 Database.forConfig uses provided config params numThreads and queueSize
  • 5ca0e5c Add tests for the removeTakeDrop phase:
  • a30d5df Fixed a mistake in the docs markup
  • e957544 Fix the implicit conversions for Compiled queries.
  • ea15636 Workaround SI-7139 caused by eponymous type alias and object
  • c762b55 Improve code generation
  • aaf2a22 Early hoisting of client-side operations:
  • 99c2737 add one more parameter typeName to jdbcTypeToScala
  • ffee22c Improve subquery fusion for Union operations
  • fbd2289 Add the correct scala-sbt repo for resolving sbt-testng.plugin
  • 31672a2 Remove deprecated APIs
  • 2ae5320 Added documentation for DatabaseUrlDataSource
  • 7fcd722 Add a test for DatabaseUrlDataSource
  • f637d52 Revised DatabaseUrlDataSource to have a no-arg cstr. Moved extractUrl to instance method
  • 9cfd03e Added a DatabaseUrlDataSource for use with DATABASE_URL
  • 79d2e67 Support Typesafe Config-based configuration of DataSource beans
  • 4565f09 Clean up the ClassLoader support from #1152:
  • 95dad0a Set hikariCP validationTimeout from config or 1000ms
  • 9b58a50 Pin HikariCP at version 2.3.7 to match play-slick
  • 5ef94f8 Remove AccessDriver
  • cce3b95 Remove the Direct Embedding (deprecated in 3.0)
  • 4b7262e Add test for resolving reference.conf in OSGi context
  • a9dd9a8 Fix OSGi tests (did not run due to duplicate slf4j on classpath)
  • ff264c9 Bump version numbers
  • b9861f1 Remove obsolete code
  • 36d5552 Improve Take, Drop and zip join translation
  • f170783 Fix type bugs and enforce correct types in the query compiler:
  • 85df538 Codegen: Suppress output of schema.create if ddlEnabled is false
  • 4fd654f Add Gitter badge
  • e26a7d0 Remove TypedNode:
  • 1c2d5db AST simplifications
  • 3470fa0 Compiler improvements:
  • 8baa079 New Query Compiler Back-End
  • 2b14139 Early transformation of monadic joins into applicative joins.
  • f53f06e Move createResultSetMapping down after forceOuterBinds
  • 1d55c69 Fix view source for scaladoc and edit this file on github for docs
  • 325f200 Improve tree logging
  • ae7e4d8 Improve logging:
  • 1abf753 Allow classloader to be specified for classloading
  • 0cab15e Add docs about DBIO composition.

Past News Items

Feb 24 2017
We have just released Slick 3.2.0. You can find the source code here: . Builds for Scala 2.11 and 2.12 are available from Maven Central, as usual. From this release...
Feb 10 2017
We have just released Slick 3.2.0-RC1, the first release candidate for Slick 3.2.0. You can find the source code here: . Builds for Scala 2.11 and 2.12 are available from...
Dec 05 2016
We have just released Slick 3.2.0-M2, the second milestone for Slick 3.2. It should show up on Maven Central within the next few hours. You can find the source code...
Jul 04 2016
We have just released Slick 3.2.0-M1, the first milestone for Slick 3.2. It should show up on Maven Central within the next few hours. You can find the source code...
Mar 18 2016
I'd like to draw your attention to the new [community process](/community/process.html) and [code of conduct](/community/conduct.html) for Slick, both of which are based on [Play Framework's](https://playframework.com/community-process). Back in 2008 [I](https://github.com/szeiger) started...
Feb 01 2016
Because nearly every application is driven by some sort of data source, we invested in building Slick, a Functional Relational Mapping (FRM) library for Scala that makes it easy to...
Dec 15 2015
We are happy to announce the release of [Slick](http://slick.typesafe.com/) 3.1.1. The artifacts are available on Maven Central, as usual. You can find the source code here: . Please see for...
Oct 09 2015
We are happy to announce the release of [Slick](http://slick.typesafe.com/) 3.1.0. These are the major new features compared to Slick 3.0.0: * New query compiler back-end. The main goal is to...