Lightbend Activator

Hello ScalikeJDBC!

Activator will be EOL-ed on May 24, 2017.

We’re making it easier and simpler for developers to get started with Lightbend technologies. This unfortunately means that future releases of Play, Akka and Scala will no longer include Activator support, and Lightbend’s Activator server will be decommissioned by the end of 2017. Instead of supporting Activator to create and set up development projects, we'll be supporting standard Giter8 templates for sbt users and Maven archetypes for Maven users. So going forward,

To create new Lightbend projects

Instead of using the Activator command, make sure you have sbt 0.13.13 (or higher), and use the “sbt new” command, providing the name of the template. For example, “$ sbt new akka/hello-akka.g8”. You can find a list of templates here.

Also, as a convenience, the Lightbend Project Starter allows you to quickly create a variety of example projects that you just unzip and run.

To create new templates

If you want to create new templates, you can now do that in Giter8.

To migrate templates from Activator to Giter8

If you created Activator templates in the past, please consider migrating them to Giter8 with this simple process.

Hello ScalikeJDBC!

May 7, 2016
scala database backbonejs coffeescript

Just write SQL and get things done! ScalikeJDBC is A tidy SQL-based DB access library for Scala developers. This library naturally wraps JDBC APIs and provides you easy-to-use APIs. This template is built with ScalikeJDBC, Play2, Backbone.js and CoffeeScript.

How to get "Hello ScalikeJDBC!" on your computer

There are several ways to get this template.

Option 1: Choose scalikejdbc-activator-template in the Lightbend Activator UI.

Already have Lightbend Activator (get it here)? Launch the UI then search for scalikejdbc-activator-template in the list of templates.

Option 2: Download the scalikejdbc-activator-template project as a zip archive

If you haven't installed Activator, you can get the code by downloading the template bundle for scalikejdbc-activator-template.

  1. Download the Template Bundle for "Hello ScalikeJDBC!"
  2. Extract the downloaded zip file to your system
  3. The bundle includes a small bootstrap script that can start Activator. To start Lightbend Activator's UI:

    In your File Explorer, navigate into the directory that the template was extracted to, right-click on the file named "activator.bat", then select "Open", and if prompted with a warning, click to continue:

    Or from a command line:

     C:\Users\typesafe\scalikejdbc-activator-template> activator ui 
    This will start Lightbend Activator and open this template in your browser.

Option 3: Create a scalikejdbc-activator-template project from the command line

If you have Lightbend Activator, use its command line mode to create a new project from this template. Type activator new PROJECTNAME scalikejdbc-activator-template on the command line.

Option 4: View the template source

The creator of this template maintains it at

Option 5: Preview the tutorial below

We've included the text of this template's tutorial below, but it may work better if you view it inside Activator on your computer. Activator tutorials are often designed to be interactive.

Preview the tutorial

Run snippets on sbt console

You can try snippets on sbt console as follows.

// basic import
import scalikejdbc._

// load conf/application.conf
import scalikejdbc.config._

// prepare data
import models._, utils._
GlobalSettings.sqlFormatter = SQLFormatterSettings("utils.HibernateSQLFormatter")

implicit val autoSession = AutoSession

// run snippets
val c = Company.syntax("c")
val companies: List[Company] = withSQL {
  select.from(Company as c).where.isNull(c.deletedAt).orderBy(

More Examples

Let's move on to app/models/Company.scala which contains some examples.

Next Steps

For more information, check out the manual on the website.