Slick VS cats-effect

Made a PR on slick to document this https://github.com/slick/slick/pull/2760 (workaround is quite easy, you can just define def tupled = (apply _).tupled in the companion object of the case class and it will also compile for all Scala versions).

The Scala ecosystem has a few ways to do composable type-safe query building, e.g. Slick[0] or more recently Quill[1]. . I believe both also have ways to do compile-time string interpolation (e.g. sql"""select * from users where id = ${user.id}""") which generate prepared statements (I know Slick does prepared statements. Quill has similar macros but I haven't looked into how safe they are to use).

[0] https://scala-slick.org/

Release notes at https://github.com/slick/slick/releases/tag/v3.5.0-M3

With all this in mind, I landed at the first candidate: slick from https://scala-slick.org/ that you all probably know.

I think Slick's current priority is also getting in Scala 3 support: https://github.com/slick/slick/issues/2177

Future releases might not be announced here. To get notified, go to https://github.com/slick/slick, click the Watch dropdown button at the top, select Custom, check Releases, and click Apply.

https://github.com/slick/slick/pull/2097 now I use slightly lower version of slick so this might be an upgrade that resolves (I do recall using it in 21 and it was still buggy and I filed a ticket, which I cannot find at the moment), but given a complex enough query (we have one in PROD which has tons of flexibility in terms of filters that can be passed in) but it also makes for complex code.

I started writing a reply but then I realized it would be long and depends on exactly what you mean, so maybe it's better to post the question in https://github.com/slick/slick/discussions/categories/questions?

I purchased the very entertaining book Seven Languages in Seven Weeks. Although I found Haskell fascinating and tempting, I knew it was unrealistic to introduce it in our company. Scala on the other hand looked like it could be the holy grail: All the characteristics I was looking for, no need to abandon the JVM and its cornucopia of tools and libraries, and the possibility for coexistence with Java and therefore incremental adoption. After implementing some simple programs to identify any immediate risks of committing to the language and its ecosystem, I started to introduce Scala in customer projects. Luckily, I was fortunate enough to work with open-minded, curious, and ambitious team members who were also experienced enough to appreciate the benefits of the language. We immediately applied our experience with functional programming, and embraced immutability. Libraries like Slick and Akka HTTP (we actually started out with its predecessor, Spray) made building database-backed REST services a breeze. And the resulting code was robust and highly maintainable. Scala's expressive type system and type inference made it easy to build a restrictive, consistent domain model without bloating the code. There was virtually no overhead. Any boilerplate could be easily abstracted out. In the end, the application code felt natural, concise and elegant. Programming was fun again.

Those benchmarks are using a snapshot version of cats-effect. I don't know where that one comes from, but previously they were using a snapshot from https://github.com/typelevel/cats-effect/pull/3332 which had some issues (3.5-6581dc4, 70% performance degradation), which have since been resolved (see that PR for more info and comparative benchmarks).

Recently, CE3 has had similar issues reported across multiple repositories, almost an epidemic of reports!

The one advantage Rust has over Scala is that it detects data races at compile time, and that's a big time saver if you use low level thread synchronization. However, if you write pure FP code with ZIO or Cats Effect that's basically a non-issue anyway.

See also cats-effect and fs2. cats-effect gives you your IO Monad (and IOApp to run it with on supported platforms). fs2 is the ecosystem’s streaming library, which is much more pervasive in functional Scala than in Haskell. For example, http4s and Doobie are both based on fs2.

On the contrary, switching to the functional mindset, with something like Typelevel Scala3 and respective cats and cats-effect fs2 frameworks, helps to rethink a lot of designs and development approaches.

I think "better Haskell on JVM" (in contrast to "worse Haskell") is a good identity for Scala to have. (Please note that this is an intentional hyperbole.)

Of course, there are areas where Haskell is stronger than Scala (hint: modularity, crucial for good Software Engineering, is not one of them). And Scala has its own way of doing things, so just imitating Haskell won't work well.

Examples of this "better Haskell" are https://typelevel.org/cats-effect/ and https://zio.dev/ .

All together, Scala may be a better choice for you if you want to do Pure Functional Programming. And is definitely less risky (runs on JVM, Java libraries interop, IntelliJ, easy debugging, etc...).

None of the other languages you mentioned are viable in this sense (if also you want a powerful type system, which rules out Clojure).

I agree that Rust's identity is pretty clear: a modern language for use cases where only C or C++ could have been used before.

I would use Scala. I like FP and Scala comes with some awesome libraries for concurrent/async programming like Cats Effect or ZIO. Good choice for creating modern style micro-services to be run in the cloud (or even macro-services, Scala has a powerful module system, so it's made to handle large codebases).

https://typelevel.org/cats-effect/

https://zio.dev/

The language, the community and customs are great. You don't have to worry about nulls, things are immutable by default, domain modelling with ADTs and patter matching is pure joy.

The tooling available is from good to great and Scala is big enough that there are good libraries for typical if not vast majority of stuff and Java libs as a reliable fallback.

What took my interest is this (for both JVM and future multithreaded Scala native): https://github.com/typelevel/cats-effect/discussions/3070 Having the same threads poll available IO events and execute callbacks should improve performance greatly

The author is the creator of Monix and implemented the first version of cats-effect. He knows what he is doing.

You want Kernmantle, which quite honestly shouldn't be hard to implement around Cats and cats-effect. In particular, although Kernmantle doesn't require the use of the Arrow typeclass, there happen to be Arrow (actually ArrowChoice) instances for both Function1 from the standard library and Kleisli from Cats itself, given a Monad instance for the Kleilsi's F[_] type parameter. In other words, we should be able to port Kernmantle from Haskell to Scala (with the Typelevel ecosystem) and instantly be able to use pretty much anything else from the Typelevel ecosystem, or wrapped with it, in our workflow graphs. Pure functions, monadic functions, applicative functions, GADTs with hand-written interpreters, any of it. I think this would be eminently worth doing.