loicknuchel / safeql

A Scala DSL to build typesafe SQL queries on top of Doobie

Version Matrix


travis-badge codecov-badge release-badge maven-badge license-badge

A Scala DSL to build typesafe SQL queries on top of Doobie.

Warning: This lib was extracted from Gospeak, so it's still very young and probably a bit use case specific. Any feedback or new use case is very welcome to help make it more generic. If you want to look at a production use case, here it is.

Quick Start

Add the dependency to your build.sbt (Scala 2.12 or later):

libraryDependencies += "fr.loicknuchel" %% "safeql" % "<version>"

Then you can generate table classes from your db, for example with Flyway but you can also use a real database connection, or a list of SQL files:

import fr.loicknuchel.safeql.gen.Generator
import fr.loicknuchel.safeql.gen.writer.ScalaWriter

object FlywaySample {
  def main(args: Array[String]): Unit = {
      .writer(ScalaWriter(packageName = "com.company.db"))

Once you generated the tables, you have a typesafe model of your database. Use it to perform queries:

USERS.insert.values(User.Id(4), "Lou", "lou@mail.com").run(xa).unsafeRunSync()
USERS.update.set(_.NAME, "LouLou").set(_.EMAIL, "loulou@mail.com").where(_.ID is User.Id(4)).run(xa).unsafeRunSync()
USERS.delete.where(_.ID is User.Id(4)).run(xa).unsafeRunSync()

val user: Option[User] = USERS.select.where(_.ID is User.Id(1)).option[User].run(xa).unsafeRunSync()
val users: List[User] = USERS.select.all[User].run(xa).unsafeRunSync()
val postsWithUsers: List[(Post, User)] = POSTS.joinOn(_.AUTHOR).select.all[(Post, User)].run(xa).unsafeRunSync()



Every commit on master is released as SNAPSHOT so you can use it immediately thanks to sbt-ci-release plugin. To push a release, you need to create a tag starting with 'v' (ex: v0.1.0). This can be done through git git tag -a v0.1.0 -m "v0.1.0" && git push --tags or via a github release with the correct tage name.

Building documentation

Documentation is automatically built and released on travis but you can build and view it locally (you will need jekyll 4.0.0+) :

  • generate the site using sbt makeMicrosite
  • then go to target/site and serve it with jekyll: jekyll serve -b /SafeQL
  • and finally, open localhost:4000/SafeQL