Add a Kotlin language backend #287

Activity

1. kyleconroy commented on Jan 24, 2020

   

   kyleconroy

   on Jan 24, 2020

   Collaborator

   More actions

   I saw there's Typescript support in the works (is there a tracking issue?)

   There wasn't, but I just created #296

   JVM support for Java/Kotlin would be really cool.

   Agreed! Do you have some example code that you'd hope sqlc would generate for you?

   Java/Kotlin support is far off. We're still working through supporting both MySQL and PostgreSQL for Go. Have you looked at jOOQ? It may fit your need.

   jOOQ generates Java code from your database and lets you build type safe SQL queries through its fluent API

   I'm going to go ahead and close this for now. Once we're ready to add Java/Kotlin, we'll re-open it.
2. kyleconroy

   closed this as completedon Jan 24, 2020
3. kyleconroy

   added

   futureIn the year 3000...In the year 3000...

   on Jan 24, 2020
4. mightyguava commented on Jan 24, 2020

   

   mightyguava

   on Jan 24, 2020

   Last edited by mightyguava

   ContributorAuthor

   More actions

   Yes we use jOOQ. Its code generation is pretty limited, only going as far as introspecting the DB to generate the models. The fluent API makes it similar to squirrel, but with more type safety. But it's the SQL => Function code generation that really makes sqlc powerful imo.

   I think the code (for Kotlin at least), looks quite similar to Go. Here's what I think createAuthor() could look like.

   package com.example.testmodule
   
   import java.sql.Connection
   import java.sql.SQLException
   
   data class Author(val id: Int, val name: String, val bio: String?);
   data class CreateAuthorParams(val name: String, val bio: String?)
   
   const val createAuthor = """-- name: CreateAuthor :one
   INSERT INTO authors (
             name, bio
   ) VALUES (
     \$1, \$2
   )
   RETURNING id, name, bio
   """
   
   class Queries(private val conn: Connection) {
     @Throws(SQLException::class)
     fun createAuthor(arg: CreateAuthorParams): Author {
       val stmt = conn.prepareStatement(createAuthor)
       stmt.setString(1, arg.name)
       stmt.setString(2, arg.bio)
   
       val rs = stmt.executeQuery()
       rs.next()
       val author = Author(rs.getInt(1), rs.getString(2), rs.getString(3))
       if (rs.next()) {
         throw SQLException("expected one row, but got many")
       }
       return author
     }
   }

   SQLDelight has a much fancier take on it, though I'm not sure if sqlc needs to do the same

   • SQL files
   • Generated code -- the generated queries are in testmodule/TestDatabaseImpl.

   I understand not wanting to take on too much for such a young project. But maybe naively I don't think Kotlin support would be all that more complex than Typescript support. I spend a lot of time in Go and Kotlin, and they are similar in certain aspects. And Kotlin <=> Java is completely interoperable.

   Again, if I might be able to convince you this is worthwhile to do soon, I would definitely love to contribute!
5. mightyguava commented on Jan 24, 2020

   

   mightyguava

   on Jan 24, 2020

   ContributorAuthor

   More actions

   Spent some time building a more complete example: https://gist.github.com/mightyguava/f2b7b0c3d1385df8eac509cc93f8d4f2
6. kyleconroy

   added

   enhancementNew feature or requestNew feature or request

   and removed

   futureIn the year 3000...In the year 3000...

   on Jan 30, 2020
7. kyleconroy

   changed the title [-]Kotlin support[/-] [+]Add a Kotlin language backend[/+] on Jan 30, 2020
8. kyleconroy

   reopened this on Jan 30, 2020
9. kyleconroy

   modified the milestone: v1.0.0 on Feb 10, 2020
10. kyleconroy commented on Feb 12, 2020

    

    kyleconroy

    on Feb 12, 2020

    Collaborator

    More actions

    The first version of this has now landed! I'm going to mark this as complete. I've added a new kotlin label for future issues.
11. kyleconroy

    closed this as completedon Feb 12, 2020