ScalikeJDBC
kotlin-spark-api
Our great sponsors
| ScalikeJDBC | kotlin-spark-api | |
|---|---|---|
| 4 | 3 | |
| 1,255 | 437 | |
| 0.2% | 1.4% | |
| 8.9 | 4.9 | |
| 7 days ago | 14 days ago | |
| Scala | Kotlin | |
| Apache License 2.0 | Apache License 2.0 |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
ScalikeJDBC
-
What are the possible ways to connect with MYSQL using scala
You can also try http://scalikejdbc.org which is my personal favorite.
-
Scala 3 RDBMS Libraries
Maybe not what you're looking for but ScalikeJDBC is published for Scala 3 since version 4.0.0.
- Query DSL in Scala 3
-
From First Principles: Why Scala?
I have had poor experiences with "fancy" SQL libraries in multiple languages when I go past basic operations. This includes Slick and Quill in Scala.
I don't remember what the problems were with Slick that leave such a bad feeling when I hear its name -- that was 5 years ago -- but I had problems with Quill just last year. I was trying to use it to generate an efficient "in" query against a two column composite primary key, and nothing seemed to work. Since it uses macro magic, one of my attempts triggered an internal compiler error instead of normal compiler feedback.
I ended up dropping Quill for ScalikeJDBC:
http://scalikejdbc.org/
It seems to be less popular/active than other libraries, but it is dead simple to use, even for developers new to Scala. I write exactly the SQL I want just like I would in psql. There is little-to-no magic [1]. I think that the only slightly magical feature I use is ensure that variable interpolation into SQL ("SQLInterpolation") prevents injection attacks.
[1] It actually has capabilities to automatically map tables/columns into different structures and generate code for you, but my team doesn't use any of that. We just write SQL.
kotlin-spark-api
-
What are your favorite Apache Spark open source libraries?
https://github.com/Kotlin/kotlin-spark-api this definitely needs to be in the language bindings section 😅
-
Migration from Scala to Kotlin
Kotlin should mostly have no problems being called in Scala. Give kotlin-spark-api a look to figure out how would that work the other way around.
-
From First Principles: Why Scala?
Scala is nice for doing things with Spark compared to say, Java, but I really think that Kotlin can do just as well. The only advantage Scala has with Spark is the syntactic sugar. Once there is an API for Kotlin (beyond the preview version), I will be dropping Scala like a bad habit. Kotlin is also concise, has better IntelliJ support, and better Java interop.
https://github.com/JetBrains/kotlin-spark-api
What are some alternatives?
Slick - Slick (Scala Language Integrated Connection Kit) is a modern database query and access library for Scala
doobie - Functional JDBC layer for Scala.
Quill - Compile-time Language Integrated Queries for Scala
treelog - Allows logging in a tree structure so that comprehensive logging does not become incomprehensible
Anorm - The Anorm database library
PyCall.jl - Package to call Python functions from the Julia language
Squeryl - A Scala DSL for talking with databases with minimum verbosity and maximum type safety
dotty - The Scala 3 compiler, also known as Dotty.
Relate - Performant database access in Scala
cf020031308