46 Database queries with Quill

After reading this lesson, you will be able to

  • Connect to a database and execute SQL queries asynchronously using the Quill library
  • Match database tables to case classes
  • Write code to generate and run queries to select, insert, update, and delete records

Now that you’ve learned about the type Future, you’ll discover how to connect and asynchronously perform queries to a database using a popular library called Quill. In particular, you’ll see how to start a test PostgreSQL database instance and connect to it. You’ll see how to execute SQL queries. You’ll master how to define case classes that correspond to their tables and write code that generates SQL queries to retrieve, insert, update, and delete their records. ...

Get Get Programming with Scala now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.