Stack Overflow
Stack Overflow

Questions tagged [doobie]

Doobie is a pure functional JDBC layer for Scala and Cats.

Doobie is a pure functional JDBC layer for Scala and Cats.

It is not an ORM, nor is it a relational algebra; it simply provides a principled way to construct programs (and higher-level libraries) that use JDBC.

http://tpolecat.github.io/doobie/

99 questions
3
votes
2 answers

How to correctly handle Hikari connection pool with Doobie

I've been using doobie (cats) to connect to a postgresql database from a scalatra application. Recently I noticed that the app was creating a new connection pool for every transaction. I eventually worked around it - see below, but this approach is…
user1830452
  • 33
  • 1
  • 3
2
votes
1 answer

Transactions in Doobie for Scala / Play Framework

I have a question regarding transactions in doobie. I have looked over the documentation here and it looks like it can only handle one query at a time? Is it possible to have something like this sql''' begin; select * from table where id=1 for…
Teddy Dong
  • 362
  • 1
  • 6
  • 20
2
votes
1 answer

How do I convert a java.util.UUID to doobie.syntax.SqlInterpolator.SingleFragment?

I am trying to set up a simple scala app with database using doobie, http4s and circe. How do I convert a java.util.UUID to doobie.syntax.SqlInterpolator.SingleFragment ? final case class User(id: UUID, details: UserDetails) implicit val…
Ry2254
  • 859
  • 1
  • 10
  • 19
2
votes
1 answer

How to raise error while composing ConnectionIO?

For instance I have a set of queries: for { entity <- sql"