There are numerous libraries to make SQL calls to database using JDBC, which is the gold standard on the JVM world to access relational databases. In this project, we have used the Slick library to access database.
Slick is like LINQ of the Microsoft world. It adheres to the Reactive Manifesto (http://www.reactivemanifesto.org/) (you will learn more about Reactive Manifesto in Chapter 5, Reactive Manifesto). Slick lets you access data from a relational database, and the experience is like dealing with collections rather than a database. We deal with tables as if they are collections in reality. Although, in the background, it auto-generates SQL queries.
For example, consider the following lines of code:
val q = for {
user <- users if user.name == "***@gmail.com"
} yield (user.name, user.creationTime)
This will generate an SQL...