Ikbsrwdwydphpokr8vlx
SkillsCast

Workshop: Functional DB access in Scala with Doobie

15th December 2018 in London at CodeNode

This SkillsCast was filmed at ScalaX2gether Community Day 2018

This session was not filmed.

Accessing a database is something many applications need and most of developers have do to during their career. During the past 20 years, (relational) database access in the JVM world hasn't changed that much. Luckily for you, despite some of the limitations the JDBC spec has, there are now some libraries that give you the ability to access the database in a complete different way. This workshop will be an introduction to accessing a database using a functional paradigm using Doobie, a ""pure functional JDBC layer for Scala"".

It will cover the following:

  • Introduction, concepts

  • Basic queries (select, insert, update)

  • NULL handling

  • Auto-mapping to case classes

  • Joins

  • Transactions

Workshop Requirements

  • Laptop with Scala, sbt and some editor installed .

  • Code (and some slides) can be found at here.

  • Docker or Postgres installed locally.

YOU MAY ALSO LIKE:

Thanks to our sponsors

Workshop: Functional DB access in Scala with Doobie

Albert Pastrana

During his professional life Albert has worked in different sectors with many different technologies and languages (including Java, Scala, TypeScript, Ruby, PHP, Javascript...). That's why he likes to think of himself as a polyglot developer. He is currently Head of Engineering of Intent HQ and has been working in Scala for the past 4 years.

SkillsCast

This session was not filmed.

Accessing a database is something many applications need and most of developers have do to during their career. During the past 20 years, (relational) database access in the JVM world hasn't changed that much. Luckily for you, despite some of the limitations the JDBC spec has, there are now some libraries that give you the ability to access the database in a complete different way. This workshop will be an introduction to accessing a database using a functional paradigm using Doobie, a ""pure functional JDBC layer for Scala"".

It will cover the following:

  • Introduction, concepts

  • Basic queries (select, insert, update)

  • NULL handling

  • Auto-mapping to case classes

  • Joins

  • Transactions

Workshop Requirements

  • Laptop with Scala, sbt and some editor installed .

  • Code (and some slides) can be found at here.

  • Docker or Postgres installed locally.

YOU MAY ALSO LIKE:

Thanks to our sponsors

About the Speaker

Workshop: Functional DB access in Scala with Doobie

Albert Pastrana

During his professional life Albert has worked in different sectors with many different technologies and languages (including Java, Scala, TypeScript, Ruby, PHP, Javascript...). That's why he likes to think of himself as a polyglot developer. He is currently Head of Engineering of Intent HQ and has been working in Scala for the past 4 years.