Play scala advice on anorm vs slick

playframework slick anorm
zulqarnain picture zulqarnain · Aug 14, 2013 · Viewed 9.2k times · Source

I am thinking of learning and using the play framework with scala for building web apps. However, I would like real advice on choosing between anorm and slick. My reservation for slick is the following:

  1. Will it remain free? Note: Quote from the licensing mentioned that using DB2, Oracle and SQL server in production requires purchasing a license even though these DBs have free versions?
  2. Will typesafe continue providing and maintaining a free version and providing patches?

Anorm also will play team continue making it the default and supporting it? If so, the only downside will be using it for different DBs but that is unlikely for now.

I could have gone with Java and Hibernate but am not sure about the future support for Java as well and as I perceive now (I may be wrong) scala is the way to go.

Please no flame wars, if you have experiences or facts and/or advice on better choices let me know.

NB: Paying for some services once business is established is ok but for startups it may not be ideal.

Answer

OlivierBlanvillain picture OlivierBlanvillain · Sep 2, 2013

Slick is actively developed and will remain free/open source for databases other than DB2, Oracle, and MS SQL Server.

It will also eventually become the database connector for the Play framework (Slide #20).

If you want to know more about the advantages of Slick over plain SQL (== Anorm), this talk explains Slick functionalities in about one hour.

Related questions

Logging options for Slick

I'm createing a Play 2.1 app, in which I have decided to use Slick for database interaction. However I can't find documentation about how to configure/enable logging for Slick. Anyone knows this?

Read More
How to catch slick postgres exceptions for duplicate key value violations

My table has a unique index on a pair of columns in my postgresql database. I want to know how I can catch a duplicate key exception when I am inserting: def save(user: User)(implicit session: Session): User = { val …

Read More
Error: Argument is not a function, got undefined

Using AngularJS with Scala Play, I'm getting this error. Error: Argument 'MainCtrl' is not a function, got undefined I'm trying to create a table consisting of the days of the week. Please take a look at my code. I had …

Read More