Upgrade to Pro — share decks privately, control downloads, hide ads and more …

A Multiplatform Delight (KotlinConf 2018)

Jake Wharton
PRO
October 04, 2018
Programming
18
2.2k

A Multiplatform Delight (KotlinConf 2018)

SQL Delight, a type-safe database API, recently completed migration from being a Java-generating, Android-specific tool to a Kotlin-generating, multiplatform one. Migrating an API from Java to Kotlin has obvious benefits, but adding multiplatform support for iOS introduces a dynamic which complicates the API, code generation, and runtime.

This talk will cover the challenges of platform-agnostic API design, type-safe multiplatform Kotlin code generation, and the integration of platform-specific runtimes such that the library not only runs efficiently on each platform but also integrates well with the other languages each might be using.

Presented with Alec Strong.

Video: https://youtu.be/WkIry790PHI

Jake Wharton
PRO

October 04, 2018
Tweet

More Decks by Jake Wharton

See All by Jake Wharton
Native UI with Multiplatform Compose (Droidcon NYC 2022)
jakewharton
PRO
2
3.6k
What's new in Java 19: The end of Kotlin? (KotlinConf 2019)
jakewharton
PRO
6
8.6k
Diffusing Changes in Your APKs (Droidcon Toronto 2019)
jakewharton
PRO
5
4k
Using Kotlin/JS and Kotlin/Native on Android (Droidcon NYC 2019)
jakewharton
PRO
4
6.5k
Mechanisms of Metaprogramming (Chicago Roboto 2019)
jakewharton
PRO
5
7.4k
Kotlin: Write Once, Run Actually Everywhere (QCon SF 2018)
jakewharton
PRO
19
3.9k
Helping Dagger Help You (Droidcon UK 2018)
jakewharton
PRO
22
19k
Digging Into D8 and R8 (Droidcon NYC 2018)
jakewharton
PRO
30
9.6k
Rinsing the Brush – Picasso 3.0 (Droidcon NYC 2018)
jakewharton
PRO
18
2.7k

Other Decks in Programming

See All in Programming
時間を気にせず普通にカンニングもしつつ ISUCON12 本選問題を PHP でやってみる
sji
0
1.2k
基盤システムへのマイクロフロントエンドの活用事例
sainu
2
150
積もってく会議メモをどうにかしたかった
kazutan
0
110
AT Protocol (BlueSky Social)仕様解説 ～ W3C DID仕様を添えて ～
gpsnmeajp
0
150
私がSymfonyはいいぞ、Doctrineはいいぞと言い続ける理由
77web
3
220
パフォーマンスを改善せよ！大規模システム改修の仕事の進め方 / Improve performance with Big project for PHPerKaigi 2023
taclose
0
710
改めて整理するWebアプリのビルド・デプロイの基本【コンテナ編】
os1ma
2
330
PHPUnit 10 概論 / Introduction of PHPUnit 10
cocoeyes02
0
760
Larastan に自作 OSS ライブラリのテストをぶっ壊された話
mpyw
0
150
Babylon.js書籍出版の裏側。ツイートから始まった奇跡の1年を振り返る
iwaken71
0
120
トランクベース開発の実現に向けた開発プロセスとCIパイプラインの継続的改善
aanrii
5
1k
【Symfony超入門】コマンドだけでCRUD画面を作るチート法
kin29
0
160

Featured

See All Featured
How To Stay Up To Date on Web Technology
chriscoyier
779
250k
The Invisible Customer
myddelton
113
12k
Visualizing Your Data: Incorporating Mongo into Loggly Infrastructure
mongodb
32
7.4k
The Success of Rails: Ensuring Growth for the Next 100 Years
eileencodes
25
5.1k
Designing Experiences People Love
moore
130
22k
Build your cross-platform service in a week with App Engine
jlugia
221
17k
Refactoring Trust on Your Teams (GOTO; Chicago 2020)
rmw
23
1.8k
Art Directing for the Web. Five minutes with CSS Template Areas
malarkey
197
11k
XXLCSS - How to scale CSS and keep your sanity
sugarenia
236
1.1M
Put a Button on it: Removing Barriers to Going Fast.
kastner
56
2.6k
The Brand Is Dead. Long Live the Brand.
mthomps
48
3k
The Pragmatic Product Professional
lauravandoore
22
3.7k

Transcript

  1. Alec Strong
    Jake Wharton

    View Slide

  2. data class Player(A
    val name: String,
    val ranking: Int,
    val country: String
    )A

    View Slide

  3. @Entity
    data class Player(A
    val name: String,
    val ranking: Int,
    val country: String
    )A

    View Slide

  4. @Entity
    data class Player(A
    val name: String,
    val ranking: Int,
    val country: String
    )A
    @Entity
    data class Match(A
    val player1: Player,
    val player2: Player,
    val winner: Player
    )A

    View Slide

  5. Source Code
    Annotation

    Processor
    Reflection
    @Entity
    data class Player(A
    val name: String,
    val ranking: Int,
    val country: String
    )A
    @Entity
    data class Match(A
    val player1: Player,
    val player2: Player,
    val winner: Player
    )A

    View Slide

  6. Source Code
    Annotation

    Processor
    Reflection
    SQLite
    @Entity
    data class Player(A
    val name: String,
    val ranking: Int,
    val country: String
    )A
    @Entity
    data class Match(A
    val player1: Player,
    val player2: Player,
    val winner: Player
    )A

    View Slide

  7. CREATE TABLE player (A
    name TEXT NOT NULL,
    country TEXT NOT NULL,
    ranking INTEGER NOT NULL
    );
    CREATE TABLE match (A
    player1 INTEGER NOT NULL REFERENCES player,
    player2 INTEGER NOT NULL REFERENCES player,
    winner INTEGER NOT NULL REFERENCES player
    );

    View Slide

  8. CREATE TABLE player (A
    id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
    name TEXT NOT NULL,
    country TEXT NOT NULL,
    ranking INTEGER NOT NULL
    );
    CREATE TABLE match (A
    player1 INTEGER NOT NULL REFERENCES player,
    player2 INTEGER NOT NULL REFERENCES player,
    winner INTEGER NOT NULL REFERENCES player
    );B

    View Slide

  9. CREATE TABLE player (A
    id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
    name TEXT NOT NULL,
    country TEXT NOT NULL,
    ranking INTEGER NOT NULL
    );
    CREATE TABLE match (A
    player1 INTEGER NOT NULL REFERENCES player,
    player2 INTEGER NOT NULL REFERENCES player,
    winner INTEGER NOT NULL REFERENCES player,
    PRIMARY KEY (player1, player2)
    ) WITHOUT ROWID;B

    View Slide

  10. SQLite
    Source Code
    Annotation

    Processor
    Reflection
    @Entity
    data class Player(
    val name: String,
    val ranking: Int,
    val country: String
    )
    @Entity
    data class Match(
    val player1: Player,
    val player2: Player,
    val winner: Player
    )
    CREATE TABLE player (A
    id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
    name TEXT NOT NULL,
    country TEXT NOT NULL,
    ranking INTEGER NOT NULL
    );
    CREATE TABLE match (A
    player1 INTEGER NOT NULL REFERENCES player,
    player2 INTEGER NOT NULL REFERENCES player,
    winner INTEGER NOT NULL REFERENCES player,
    PRIMARY KEY (player1, player2)
    ) WITHOUT ROWID;

    View Slide

  11. @Entity
    data class Player(A
    val name: String,
    val ranking: Int,
    val country: String
    )A
    @Entity
    data class Match(A
    val player1: Player,
    val player2: Player,
    val winner: Player
    )A

    View Slide

  12. @Entity
    data class Player(A
    @PrimaryKey @Autoincrement val id: Int,
    val name: String,
    val ranking: Int,
    val country: String
    )A
    @Entity
    data class Match(A
    val player1: Player,
    val player2: Player,
    val winner: Player
    )A

    View Slide

  13. @Entity
    data class Player(A
    @PrimaryKey @Autoincrement val id: Int,
    val name: String,
    val ranking: Int,
    val country: String
    )A
    @Entity(primaryKeys = ['player1', ‘player2'])
    data class Match(A
    val player1: Player,
    val player2: Player,
    val winner: Player
    )A

    View Slide

  14. @Entity
    data class Player(A
    @PrimaryKey @Autoincrement val id: Int,
    val name: String,
    val ranking: Int,
    val country: String
    )A
    @Entity(primaryKeys = ['player1', ‘player2'])
    data class Match(A
    val player1: Player,
    val player2: Player,
    val winner: Player
    )A
    A
    @PrimaryKey @Autoincrement val id: Int,
    @Entity(primaryKeys = ['player1', ‘player2'])

    View Slide

  15. ALTER TABLE player
    ADD COLUMN id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT;
    CREATE TABLE new_match (
    player1 INTEGER NOT NULL REFERENCES player,
    player2 INTEGER NOT NULL REFERENCES player,
    winner INTEGER NOT NULL REFERENCES player,
    PRIMARY KEY (player1, player2)
    ) WITHOUT ROWID;
    -- migrate match to new_match

    View Slide

  16. QueryBuilders

    View Slide

  17. View Slide

  18. QueryBuilders
    jakes.link/resurgence-of-sql

    View Slide

  19. SQL Delight

    View Slide

  20. SQLite
    Source Code
    Annotation

    Processor
    Reflection

    View Slide

  21. SQLite Compiler
    Generated
    Code

    View Slide

  22. CREATE TABLE player (A
    id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
    name TEXT NOT NULL,
    country TEXT NOT NULL,
    ranking INTEGER NOT NULL
    );

    View Slide

  23. CREATE TABLE player (A
    id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
    name TEXT NOT NULL,
    country TEXT NOT NULL,
    ranking INTEGER NOT NULL
    );
    withRanking:
    SELECT *
    FROM player
    WHERE ranking = ?;

    View Slide

  24. SQLite Compiler
    Generated
    Code
    CREATE TABLE player (A
    id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
    name TEXT NOT NULL,
    country TEXT NOT NULL,
    ranking INTEGER NOT NULL
    );
    withRanking:
    SELECT *
    FROM player
    WHERE ranking = ?;

    View Slide

  25. interface PlayerModel {A
    long id();
    @NonNull String name();
    @NonNull String country();
    long ranking();
    final class Factory {A
    public Factory(Creator creator);
    public SqlDelightQuery withRanking(long ranking);
    public RowMapper withRankingMapper();
    }A
    }A

    View Slide

  26. interface PlayerModel {A
    …
    final class Factory {A
    public Factory(Creator creator);
    …
    }B
    }A
    @AutoValue
    public abstract class MyPlayerModel implements PlayerModel {A
    public static Factory FACTORY =
    new Factory(AutoValue_MyPlayerModel::new)
    }A

    View Slide

  27. SqlDelightStatement query = MyPlayerModel.FACTORY.withRanking(10);
    Observable> rank10 =
    db.createQuery(query.tables, query.statement, query.args)
    .mapToList(MyPlayerModel.FACTORY::withRankingMapper);
    interface PlayerModel {A
    …
    final class Factory {A
    public Factory(Creator creator);
    public SqlDelightQuery withRanking(long ranking);
    public RowMapper withRankingMapper();
    }B
    }A

    View Slide

  28. SQL Delight 0.7

    View Slide

  29. View Slide

  30. QueryBuilders
    jakes.link/embracing-sql

    View Slide

  31. SQL Delight 1.0

    View Slide

  32. SQLite Compiler
    Generated
    Code
    CREATE TABLE player (
    id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
    name TEXT NOT NULL,
    country TEXT NOT NULL,
    ranking INTEGER NOT NULL
    );
    withRanking:
    SELECT *
    FROM player
    WHERE ranking = ?;
    insertPlayer:
    INSERT INTO player (name, country, ranking)
    VALUES (?, ?, ?);

    View Slide

  33. CREATE TABLE player (
    id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
    name TEXT NOT NULL,
    country TEXT NOT NULL,
    ranking INTEGER NOT NULL
    );
    withRanking:
    SELECT *
    FROM player
    WHERE ranking = ?;
    insertPlayer:
    INSERT INTO player (name, country, ranking)
    VALUES (?, ?, ?);

    View Slide

  34. SQLite Compiler
    Generated
    Code
    CREATE TABLE player (
    id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
    name TEXT NOT NULL,
    country TEXT NOT NULL,
    ranking INTEGER NOT NULL
    );
    withRanking:
    SELECT *
    FROM player
    WHERE ranking = ?;
    insertPlayer:
    INSERT INTO player (name, country, ranking)
    VALUES (?, ?, ?);

    View Slide

  35. interface Player {A
    val id: Long
    val name: String
    val country: String
    val ranking: Long
    data class Impl(A
    override val id: Long,
    override val name: String,
    override val country: String,
    override val ranking: Long
    ) : Player
    }A

    View Slide

  36. class PlayerQueries : Transacter {A
    fun withRanking(
    ranking: Long,
    mapper: (
    id: Long,
    name: String,
    country: String,
    ranking: Long
    ) -> T
    ): Query
    fun withRanking(ranking: Long): Query
    fun insertPlayer(
    name: String,
    country: String,
    ranking: Long
    ): Long
    }A

    View Slide

  37. headToHead:
    SELECT player1.name AS player1Name,
    player2.name AS player2Name,
    count(nullif(match.winner = player1.id, 0)) AS player1Wins,
    count(nullif(match.winner = player2.id, 0)) AS player2Wins
    FROM match
    JOIN player AS player1
    ON (player1.name = :firstPlayerName AND
    (player1.id = match.player1 OR player1.id = match.player2)
    )
    JOIN player AS player2
    ON (player2.name = :secondPlayerName AND
    (player2.id = match.player1 OR player2.id = match.player2)
    )
    ;

    View Slide

  38. class PlayerQueries : Transacter {A
    fun headToHead(
    firstPlayerName: String,
    secondPlayerName: String,
    mapper: (
    player1Name: String,
    player2Name: String,
    player1Wins: Long,
    player2Wins: Long
    ) -> T
    ): Query
    fun headToHead(
    firstPlayerName: String,
    secondPlayerName: String
    ): Query
    }A

    View Slide

  39. class PlayerQueries : Transacter {A
    fun withRanking(
    ranking: Long,
    mapper: (
    id: Long,
    name: String,
    country: String,
    ranking: Long
    ) -> T
    ): Query
    fun withRanking(ranking: Long): Query
    fun insertPlayer(
    name: String,
    country: String,
    ranking: Long
    ): Long
    }A

    View Slide

  40. class PlayerQueries : Transacter {A
    fun withRanking(ranking: Long): Query
    }A
    val player: Query = playerQueries.withRanking(10)

    View Slide

  41. Query< >
    class PlayerQueries : Transacter {A
    fun withRanking(ranking: Long): Query
    }A
    val player: Player = playerQueries.withRanking(10).executeAsOne()

    View Slide

  42. class PlayerQueries : Transacter {A
    fun withRanking(ranking: Long): Query
    }A
    val player: Observable> = playerQueries.withRanking(10)
    .asObservable()
    .ex

    View Slide

  43. class PlayerQueries : Transacter {A
    fun withRanking(ranking: Long): Query
    }A
    val player: Observable> = playerQueries.withRanking(10)
    .asObservable()
    .mapToList()

    View Slide

  44. class PlayerQueries : Transacter {A
    fun withRanking(ranking: Long, mapper: (
    id: Long,
    name: String,
    country: String,
    ranking: Long
    ) -> T): Query
    }A
    val player = playerQueries.withRanking(10, ::MyPlayer)
    P
    l
    a
    y
    e
    r

    View Slide

  45. class PlayerQueries : Transacter {A
    }A
    val id = playerQueries.insertPlayer(
    name = "Roger Federer",
    country = "Switzerland",
    ranking = 2
    )
    fun insertPlayer(
    name: String,
    country: String,
    ranking: Long
    ): Long

    View Slide

  46. Generated
    Code
    SQLite Compiler
    CREATE TABLE player (A
    id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
    name TEXT NOT NULL,
    country TEXT NOT NULL,
    ranking INTEGER NOT NULL
    );
    withRanking:
    SELECT *
    FROM player
    WHERE ranking = ?;
    class PlayerQueries : Transacter {A
    fun insertPlayer(
    name: String,
    country: String,
    ranking: Long
    ): Long
    }A

    View Slide

  47. CREATE TABLE player (
    id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
    name TEXT NOT NULL,
    country NOT NULL,
    ranking INTEGER NOT NULL
    );
    TEXT

    View Slide

  48. CREATE TABLE player (
    id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
    name TEXT NOT NULL,
    country NOT NULL,
    ranking INTEGER NOT NULL
    );
    import com.tennis.db.CountryCode;
    TEXT AS CountryCode

    View Slide

  49. import com.tennis.db.CountryCode;
    CREATE TABLE player (
    id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
    name TEXT NOT NULL,
    country TEXT AS CountryCode NOT NULL,
    ranking INTEGER NOT NULL
    );

    View Slide

  50. SQLite Compiler
    Generated
    Code
    import com.tennis.db.CountryCode;
    CREATE TABLE player (
    id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
    name TEXT NOT NULL,
    country TEXT AS CountryCode NOT NULL,
    ranking INTEGER NOT NULL
    );

    View Slide

  51. class QueryWrapper(
    database: SqlDatabase,
    internal val playerAdapter: Player.Adapter
    ) {A
    val playerQueries: PlayerQueries
    }A

    View Slide

  52. class QueryWrapper(
    database: SqlDatabase,
    internal val playerAdapter: Player.Adapter
    ) {A
    val playerQueries: PlayerQueries
    }A
    interface Player {A
    class Adapter(
    val countryAdapter: ColumnAdapter
    )
    }A

    View Slide

  53. class QueryWrapper(
    database: SqlDatabase,
    internal val playerAdapter: Player.Adapter
    ) {A
    val playerQueries: PlayerQueries
    }A
    val queryWrapper = QueryWrapper(
    database = database,
    playerAdapter = Player.Adapter(
    countryAdapter = EnumColumnAdapter()
    ),
    )

    View Slide

  54. class QueryWrapper(
    database: SqlDatabase,
    internal val playerAdapter: Player.Adapter
    ) {A
    val playerQueries: PlayerQueries
    }A
    val queryWrapper = QueryWrapper(
    database = database,
    playerAdapter = Player.Adapter(
    countryAdapter = EnumColumnAdapter()
    ),
    )
    val playerQueries: PlayerQueries = queryWrapper.playerQueries
    val playerQueries: PlayerQueries = queryWrapper.playerQueries
    val playerQueries: PlayerQueries

    View Slide

  55. class QueryWrapper {A
    object Schema : SqlDatabase.Schema {A
    override val version: Int
    get() = 2
    override fun create(db: SqlDatabaseConnection)
    override fun migrate(
    db: SqlDatabaseConnection,
    oldVersion: Int,
    newVersion: Int
    )
    }A
    }A

    View Slide

  56. SQLite
    Generated
    Code
    Compiler
    CREATE TABLE player (A
    id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
    name TEXT NOT NULL,
    country TEXT NOT NULL,
    ranking INTEGER NOT NULL
    );
    withRanking:
    SELECT *
    FROM player
    WHERE ranking = ?;
    class QueryWrapper {A
    object Schema : SqlDatabase.Schema {A
    override val version: Int
    get() = 2
    override fun create(db: SqlDatabaseConnection)
    override fun migrate(
    db: SqlDatabaseConnection,
    oldVersion: Int,
    newVersion: Int
    )
    }A
    }A

    View Slide

  57. SQLite
    Generated
    Code
    Compiler
    SQLite
    Migrations

    View Slide

  58. ALTER TABLE player
    ADD COLUMN id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT;
    CREATE TABLE new_match (
    player1 INTEGER NOT NULL REFERENCES player,
    player2 INTEGER NOT NULL REFERENCES player,
    winner INTEGER NOT NULL REFERENCES player,
    PRIMARY KEY (player1, player2)
    ) WITHOUT ROWID;
    -- migrate match to new_match

    View Slide

  59. SQLite
    Migrations
    SQLite
    Generated
    Code
    Compiler
    ALTER TABLE player
    ADD COLUMN id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT;
    CREATE TABLE new_match (
    player1 INTEGER NOT NULL REFERENCES player,
    player2 INTEGER NOT NULL REFERENCES player,
    winner INTEGER NOT NULL REFERENCES player,
    PRIMARY KEY (player1, player2)
    ) WITHOUT ROWID;
    -- migrate match to new_match

    View Slide

  60. SQL Delight 1.0

    View Slide

  61. SQL Delight Multiplatform?

    View Slide

  62. SQL Delight Multiplatform?

    View Slide

  63. CashApp

    View Slide

  64. db
    backend
    presenters
    api
    CashApp
    proto
    viewmodels

    View Slide

  65. db

    View Slide

  66. SQLite
    Generated
    Code
    SQL Delight
    CREATE TABLE player (A
    id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
    name TEXT NOT NULL,
    country TEXT NOT NULL,
    ranking INTEGER NOT NULL
    );
    withRanking:
    SELECT *
    FROM player
    WHERE ranking = ?;
    db

    View Slide

  67. Generated
    Code
    SQL Delight
    db
    SQLite

    View Slide

  68. Generated
    Code
    SQL Delight
    db
    SQLite
    Generated
    Swift Code
    Compiler

    View Slide

  69. Generated
    Java
    wire
    protos
    .proto
    Generated C
    protoc

    View Slide

  70. Generated
    Code
    db
    SQL Delight
    SQLite
    Generated
    Swift Code
    Compiler

    View Slide

  71. Generated
    Code
    db
    SQL Delight
    SQLite

    View Slide

  72. Generated
    Code
    Kotlin/Native
    kotlinc Android
    Native

    View Slide

  73. Generated
    Code
    Kotlin/Native
    kotlinc Android
    Native
    kotlinc JVM
    kotlin2js JavaScript

    View Slide

  74. Android
    JVM JavaScript
    Native

    View Slide

  75. Android
    JVM JavaScript
    Native
    android.database.*
    android.database.sqlite.*

    View Slide

  76. Android
    JVM JavaScript
    Native
    android.database.*
    android.database.sqlite.*
    sqlite3.h

    View Slide

  77. Android
    JVM JavaScript
    Native
    android.database.*
    android.database.sqlite.*
    sqlite3.h
    java.sql.*
    org.sqlite.*

    View Slide

  78. Android
    JVM JavaScript
    Native
    android.database.*
    android.database.sqlite.*
    sqlite3.h
    java.sql.*
    org.sqlite.* (xerial)

    View Slide

  79. Android
    JVM JavaScript
    Native
    android.database.*
    android.database.sqlite.*
    sqlite3.h
    java.sql.*
    org.sqlite.*
    Node? WASM? Vanilla JS?
    (xerial)

    View Slide

  80. android.database.*
    android.database.sqlite.*
    sqlite3.h
    Node? WASM? Vanilla JS?
    Generated
    Code
    Android
    JVM
    Native
    JavaScript
    java.sql.*
    org.sqlite.* (xerial)

    View Slide

  81. android.database.*
    android.database.sqlite.*
    sqlite3.h
    Node? WASM? Vanilla JS?
    Generated
    Code
    Android
    Native
    JavaScript
    Database
    Abstraction
    java.sql.*
    org.sqlite.* (xerial)
    JVM

    View Slide

  82. Database Abstraction
    SqlDatabase

    View Slide

  83. Database Abstraction
    SqlDatabase
    SqlDatabase.Schema

    View Slide

  84. Database Abstraction
    SqlDatabase
    SqlDatabase.Schema
    SqlPreparedStatement

    View Slide

  85. Database Abstraction
    SqlDatabase
    SqlDatabase.Schema
    SqlPreparedStatement
    Transacter.Transaction

    View Slide

  86. Database Abstraction
    SqlDatabase
    SqlDatabase.Schema
    SqlPreparedStatement
    Transacter.Transaction
    Transacter

    View Slide

  87. Database Abstraction
    SqlDatabase
    SqlDatabase.Schema
    SqlPreparedStatement
    Transacter.Transaction
    Transacter

    View Slide

  88. Database Abstraction
    SqlDatabase
    SqlDatabase.Schema
    SqlPreparedStatement
    Transacter.Transaction
    Transacter
    SqlCursor

    View Slide

  89. Database Abstraction
    SqlDatabase
    SqlDatabase.Schema
    SqlPreparedStatement
    Transacter.Transaction
    Transacter
    SqlCursor
    Query

    View Slide

  90. android.database.*
    android.database.sqlite.*
    sqlite3.h
    Node? WASM? Vanilla JS?
    Generated
    Code
    Android
    JVM
    Native
    JavaScript
    Database
    Abstraction
    java.sql.*
    org.sqlite.* (xerial)
    S
    Sql
    Sql
    Tran
    T
    S
    Q

    View Slide

  91. android.database.*
    android.database.sqlite.*
    sqlite3.h
    Node? WASM? Vanilla JS?
    Generated
    Code
    Android
    Native
    JavaScript
    Database
    Abstraction
    java.sql.*
    org.sqlite.* (xerial)
    Android
    Driver
    knarch.db
    Driver
    JDBC
    Driver
    JS
    Driver
    JVM

    View Slide

  92. android.database.*
    android.database.sqlite.*
    sqlite3.h
    Android
    Native
    Database
    Abstraction
    java.sql.*
    org.sqlite.* (xerial)
    Android
    Driver
    knarch.db
    Driver
    JDBC
    Driver
    JS
    JVM

    View Slide

  93. android.database.*
    android.database.sqlite.*
    sqlite3.h
    Android
    Native
    java.sql.*
    org.sqlite.* (xerial)
    Android
    Driver
    knarch.db
    Driver
    JDBC
    Driver
    JS
    JVM
    AndroidX Sqlite
    Abstraction
    AndroidX Sqlite
    Framework Impl

    View Slide

  94. android.database.*
    android.database.sqlite.*
    sqlite3.h
    Android
    Native
    java.sql.*
    org.sqlite.* (xerial)
    Android
    Driver
    knarch.db
    Driver
    JDBC
    Driver
    JS
    JVM
    AndroidX Sqlite
    Abstraction
    AndroidX Sqlite
    Framework Impl
    Android
    android.database.*
    net.sqlcipher.database.*
    AndroidX
    SQLCipher Impl

    View Slide

  95. android.
    android.
    sqlite3.h
    Node? WASM? Vanilla JS?
    ed
    Native
    JavaScript
    Database
    Abstraction
    java.sql.*
    org.sqlite.* (xerial)
    Android
    Driver
    knarch.db
    Driver
    JDBC
    Driver
    JS
    Driver
    JVM
    AndroidX Sqlite
    Abstraction
    AndroidX Sqlite
    Framework Impl
    android.
    net.sqlc
    AndroidX
    SQLCipher Impl

    View Slide

  96. android.
    android.
    sqlite3.h
    Node? WASM? Vanilla JS?
    ed
    Native
    JavaScript
    Database
    Abstraction
    java.sql.*
    org.sqlite.* (xerial)
    Android
    Driver
    knarch.db
    Driver
    JDBC
    Driver
    JS
    Driver
    JVM
    AndroidX Sqlite
    Abstraction
    AndroidX Sqlite
    Framework Impl
    android.
    net.sqlc
    AndroidX
    SQLCipher Impl
    AAA
    BBB

    View Slide

  97. sqlite3.h
    Node? WASM? Vanilla JS?
    ed
    Native
    JavaScript
    Database
    Abstraction
    java.sql.*
    org.sqlite.* (xerial)
    Driver
    knarch.db
    Driver
    JDBC
    Driver
    JS
    Driver
    JVM
    Abstraction
    android.
    net.sqlc
    AndroidX
    SQLCipher Impl
    AAA
    BBB

    View Slide

  98. sqlite3.h
    ed
    Native
    Node? WASM? Vanilla JS?
    JavaScript
    Database
    Abstraction
    java.sql.*
    org.sqlite.* (xerial)
    Driver
    knarch.db
    Driver
    JDBC
    Driver
    JVM
    Abstraction
    android.
    net.sqlc
    AndroidX
    SQLCipher Impl

    View Slide

  99. android.database.*
    android.database.sqlite.*
    sqlite3.h
    Generated
    Code
    Android
    Native
    Node? WASM? Vanilla JS?
    JavaScript
    Database
    Abstraction
    java.sql.*
    org.sqlite.* (xerial)
    Android
    Driver
    knarch.db
    Driver
    JDBC
    Driver
    JVM
    AndroidX Sqlite
    Abstraction
    AndroidX Sqlite
    Framework Impl
    Android
    android.database.*
    net.sqlcipher.database.*
    AndroidX
    SQLCipher Impl

    View Slide

  100. android.database.*
    android.database.sqlite.*
    sqlite3.h
    Generated
    Code
    Android
    Native
    Node? WASM? Vanilla JS?
    JavaScript
    Database
    Abstraction
    java.sql.*
    org.sqlite.* (xerial)
    Android
    Driver
    knarch.db
    Driver
    JDBC
    Driver
    JVM
    AndroidX Sqlite
    Abstraction
    AndroidX Sqlite
    Framework Impl
    Android
    android.database.*
    net.sqlcipher.database.*
    AndroidX
    SQLCipher Impl

    View Slide

  101. Database Abstraction
    SqlDatabase
    SqlDatabase.Schema
    SqlPreparedStatement
    Transacter.Transaction
    Transacter
    SqlCursor
    Query

    View Slide

  102. Database Abstraction
    SqlDatabase.Schema
    SqlPreparedStatement
    Transacter.Transaction
    Transacter
    Query
    SqlDatabase
    SqlCursor

    View Slide

  103. package com.squareup.sqldelight.db
    expect interface Closeable {
    fun close()
    }
    expect inline fun T.use(body: (T) -> R): R

    View Slide

  104. package com.squareup.sqldelight.db
    expect interface Closeable {
    fun close()
    }
    expect inline fun T.use(body: (T) -> R): R
    package com.squareup.sqldelight.db
    import kotlin.io.use as kotlinIoUse
    actual typealias Closeable = java.io.Closeable
    actual inline fun T.use(body: (T) -> R): R =
    kotlinIoUse(body)

    View Slide

  105. package com.squareup.sqldelight.db
    expect interface Closeable {
    fun close()
    }
    expect inline fun T.use(body: (T) -> R): R
    package com.squareup.sqldelight.db
    actual interface Closeable {
    actual fun close()
    }
    actual inline fun T.use(body: (T) -> R): R {
    // Copy/paste JVM implementation…
    }

    View Slide

  106. apply plugin: 'org.jetbrains.kotlin.platform.common'
    dependencies {
    compile 'com.squareup.sqldelight:runtime-common:1.0.0'
    }
    apply plugin: 'org.jetbrains.kotlin.platform.jvm' // Or .android
    dependencies {
    compile 'com.squareup.sqldelight:runtime-jdk:1.0.0'
    }
    apply plugin: 'org.jetbrains.kotlin.platform.js'
    dependencies {
    compile 'com.squareup.sqldelight:runtime-js:1.0.0'
    }

    View Slide

  107. apply plugin: 'org.jetbrains.kotlin.platform.common'
    dependencies {
    compile 'com.squareup.sqldelight:runtime-common:1.0.0'
    }
    apply plugin: 'org.jetbrains.kotlin.platform.jvm' // Or .android
    dependencies {
    compile 'com.squareup.sqldelight:runtime-jdk:1.0.0'
    }
    apply plugin: 'org.jetbrains.kotlin.platform.js'
    dependencies {
    compile 'com.squareup.sqldelight:runtime-js:1.0.0'
    }
    apply plugin: 'org.jetbrains.kotlin.platform.native' // ???

    View Slide

  108. apply plugin: 'org.jetbrains.kotlin.platform.common'
    dependencies {
    compile 'com.squareup.sqldelight:runtime-common:1.0.0'
    }
    apply plugin: 'org.jetbrains.kotlin.platform.jvm' // Or .android
    dependencies {
    compile 'com.squareup.sqldelight:runtime-jdk:1.0.0'
    }
    apply plugin: 'org.jetbrains.kotlin.platform.js'
    dependencies {
    compile 'com.squareup.sqldelight:runtime-js:1.0.0'
    }
    apply plugin: 'org.jetbrains.kotlin.platform.native' // nope!

    View Slide

  109. apply plugin: 'org.jetbrains.kotlin.multiplatform'
    dependencies {
    compile 'com.squareup.sqldelight:runtime:1.0.0'
    }

    View Slide

  110. apply plugin: 'org.jetbrains.kotlin.multiplatform'
    dependencies {
    compile 'com.squareup.sqldelight:runtime:1.0.0'
    }
    // settings.gradle
    enableFeaturePreview('GRADLE_METADATA')

    View Slide

  111. com.squareup.sqldelight
    + runtime

    View Slide

  112. com.squareup.sqldelight
    - runtime
    runtime-1.0.0-sources.jar
    runtime-1.0.0-javadoc.jar
    runtime-1.0.0.pom
    runtime-1.0.0.module

    View Slide

  113. runtime-1.0.0.module
    {
    "variants": [
    {
    "name": "iosArm64-api",
    "available-at": {
    "url": "../../runtime-iosarm64/runtime-iosarm64-1.0.0.module"
    }
    },
    ...
    ]

    }

    View Slide

  114. com.squareup.sqldelight
    - runtime
    runtime-1.0.0-sources.jar
    runtime-1.0.0-javadoc.jar
    runtime-1.0.0.pom
    runtime-1.0.0.module

    View Slide

  115. com.squareup.sqldelight
    + runtime

    View Slide

  116. com.squareup.sqldelight
    + runtime
    + runtime-common
    + runtime-iosarm64
    + runtime-iosx64
    + runtime-jvm
    + runtime-js

    View Slide

  117. com.squareup.sqldelight
    + android-driver
    + runtime
    + runtime-common
    + runtime-iosarm64
    + runtime-iosx64
    + runtime-jvm
    + runtime-js

    View Slide

  118. com.squareup.sqldelight
    - android-driver
    android-driver-1.0.0.aar
    android-driver-1.0.0-javador.jar
    android-driver-1.0.0-sources.jar
    android-driver-1.0.0-pom.xml
    + runtime
    + runtime-common
    + runtime-iosarm64
    + runtime-iosx64
    + runtime-jvm
    + runtime-js

    View Slide

  119. com.squareup.sqldelight
    - android-driver
    android-driver-1.0.0.aar
    android-driver-1.0.0-javador.jar
    android-driver-1.0.0-sources.jar
    android-driver-1.0.0-pom.xml
    + runtime
    + runtime-common
    + runtime-iosarm64
    + runtime-iosx64
    + runtime-jvm
    + runtime-js
    android-driver-1.0.0-pom.xml
    + runtime-jvm

    View Slide

  120. com.squareup.sqldelight
    - android-driver
    android-driver-1.0.0.aar
    android-driver-1.0.0-javador.jar
    android-driver-1.0.0-sources.jar
    android-driver-1.0.0-pom.xml
    + runtime
    + runtime-common
    + runtime-iosarm64
    + runtime-iosx64
    + runtime-jvm
    + runtime-js
    android-driver-1.0.0-pom.xml
    + runtime

    View Slide

  121. com.squareup.sqldelight
    - android-driver
    android-driver-1.0.0.aar
    android-driver-1.0.0-javador.jar
    android-driver-1.0.0-sources.jar
    android-driver-1.0.0-pom.xml
    + runtime
    + runtime-common
    + runtime-iosarm64
    + runtime-iosx64
    + runtime-jvm
    + runtime-js
    android-driver-1.0.0-pom.xml
    + runtime-jdk

    View Slide

  122. apply plugin: ‘com.android.application’
    apply plugin: 'org.jetbrains.kotlin.multiplatform'
    dependencies {A
    implementation 'com.squareup.sqldelight:android-driver:1.0.0'
    }A
    kotlin {A
    sourceSets {A
    commonMain {A
    dependencies {A
    implementation project(':sqldelight-sample:sample-common')
    }A
    }A
    }A
    }A

    View Slide

  123. apply plugin: ‘com.android.application’
    apply plugin: 'org.jetbrains.kotlin.multiplatform'
    dependencies {A
    implementation 'com.squareup.sqldelight:android-driver:1.0.0'
    }A
    kotlin {A
    sourceSets {A
    commonMain {A
    dependencies {A
    implementation project(':sqldelight-sample:sample-common')
    }A
    }A
    }A
    }A
    A
    implementation 'com.squareup.sqldelight:android-driver:1.0.0'
    A
    A
    implementation project(':sqldelight-sample:sample-common')

    View Slide

  124. apply plugin: ‘com.android.application’
    apply plugin: 'org.jetbrains.kotlin.multiplatform'
    dependencies {A
    implementation (“com.squareup.sqldelight:android-driver:1.0.0) {A
    exclude group: 'com.squareup.sqldelight', module: 'runtime-jdk'
    }A
    }A
    kotlin {A
    sourceSets {A
    commonMain {A
    dependencies {A
    implementation project(':sqldelight-sample:sample-common')
    }A
    }A
    }A
    }A
    implementation ('com.squareup.sqldelight:android-driver:1.0.0') {A
    exclude group: 'com.squareup.sqldelight', module: 'runtime-jdk'
    }A
    implementation project(':sqldelight-sample:sample-common')

    View Slide

  125. SqlDatabase.Schema
    SqlPreparedStatement
    Transacter.Transaction
    Transacter
    Query
    SqlDatabase
    SqlCursor

    View Slide

  126. SqlDatabase.Schema
    SqlPreparedStatement
    Transacter.Transaction
    Transacter
    SqlDatabase
    SqlCursor
    Query

    View Slide

  127. SqlDatabase.Schema
    SqlPreparedStatement
    Transacter.Transaction
    Transacter
    SqlDatabase
    SqlCursor
    abstract class Query {
    }X

    View Slide

  128. abstract class Query {
    fun execute(): SqlCursor
    fun executeAsList(): List
    fun executeAsOne(): RowType
    fun executeAsOneOrNull(): RowType?
    }X

    View Slide

  129. abstract class Query {
    fun execute(): SqlCursor
    fun executeAsList(): List
    fun executeAsOne(): RowType
    fun executeAsOneOrNull(): RowType?
    fun addListener(listener: Listener)
    fun removeListener(listener: Listener)
    interface Listener {
    fun queryResultsChanged()
    }Y
    }X

    View Slide

  130. abstract class Query {
    fun execute(): SqlCursor
    fun executeAsList(): List
    fun executeAsOne(): RowType
    fun executeAsOneOrNull(): RowType?
    fun addListener(listener: Listener)
    fun removeListener(listener: Listener)
    interface Listener {
    fun queryResultsChanged()
    }Y
    fun notifyDataChanged()
    }X

    View Slide

  131. val usersQuery: Query = // …
    val users = usersQuery.executeAsList()
    // Show users somewhere…

    View Slide

  132. val usersQuery: Query = // …
    usersQuery.addListener(object : Listener {
    override fun queryResultsChanged() {
    val users = usersQuery.executeAsList()
    // Show users somewhere…
    }G
    })
    usersQuery.notifyDataChanged()

    View Slide

  133. val usersQuery: Query = // …
    val executor = // …
    usersQuery.addListener(object : Listener {
    override fun queryResultsChanged() {
    executor.execute {
    val users = usersQuery.executeAsList()
    // Show users somewhere…
    }G
    }G
    })
    usersQuery.notifyDataChanged()

    View Slide

  134. val usersQuery: Query = // …
    val executor = // …
    val mainThread = Handler(Looper.getMainLooper())
    usersQuery.addListener(object : Listener {
    override fun queryResultsChanged() {
    executor.execute {
    val users = usersQuery.executeAsList()
    mainThread.post {
    // Show users somewhere…
    }
    }G
    }G
    })
    usersQuery.notifyDataChanged()

    View Slide

  135. val usersQuery: Query = // …

    View Slide

  136. val usersQuery: Query = // …
    val usersObservable = usersQuery.asObservable()

    View Slide

  137. val usersQuery: Query = // …
    val usersObservable: Observable = usersQuery.asObservable()

    View Slide

  138. val usersQuery: Query = // …
    val usersObservable: Observable> = usersQuery.asObservable()

    View Slide

  139. val usersQuery: Query = // …
    val usersObservable: Observable> = usersQuery.asObservable()
    .map { it.executeAsList() }
    Query

    View Slide

  140. val usersQuery: Query = // …
    val usersObservable: Observable> = usersQuery.asObservable()
    .mapToList()

    View Slide

  141. val usersQuery: Query = // …

    View Slide

  142. val usersQuery: Query = // …
    val usersChannel: ReceiveChannel> = usersQuery.asChannel()

    View Slide

  143. val usersQuery: Query = // …
    val usersChannel: ReceiveChannel> = usersQuery.asChannel()
    .map { it.executeAsList() }
    Query

    View Slide

  144. val usersQuery: Query = // …
    val usersChannel: ReceiveChannel> = usersQuery.asChannel()
    .mapToList()

    View Slide

  145. suspend fun users() {
    val usersQuery: Query = // …
    val usersChannel: ReceiveChannel> = usersQuery.asChannel()
    .mapToList()
    return usersChannel.receive()
    }

    View Slide

  146. suspend fun users() {
    val usersQuery: Query = // …
    val usersChannel: ReceiveChannel> = usersQuery.asChannel()
    .mapToList()
    return usersChannel.receive()
    }

    View Slide

  147. suspend fun users() {
    val usersQuery: Query = // …
    val usersChannel: ReceiveChannel> = usersQuery.asChannel()
    .mapToList()
    return usersChannel.receive()
    }

    View Slide

  148. val usersQuery: Query = // …

    View Slide

  149. val usersQuery: Query = // …
    val usersLiveData: LiveData> = usersQuery.asLiveData()B

    View Slide

  150. val usersQuery: Query = // …
    val usersLiveData: LiveData> = usersQuery.asLiveDataList()B
    Query

    View Slide

  151. val usersQuery: Query = // …
    val executor = // …
    val usersLiveData: LiveData> =
    usersQuery.asLiveDataList(executor)B

    View Slide

  152. val pagedQuery = QueryDataSourceFactory(
    queryProvider = { limit, offset -> queries.users(limit, offset) },
    count = queries.usersCount())

    View Slide

  153. apply plugin: 'com.squareup.sqldelight'

    View Slide

  154. apply plugin: 'com.squareup.sqldelight'
    apply plugin: 'org.jetbrains.kotlin.jvm'

    View Slide

  155. apply plugin: 'com.squareup.sqldelight'
    apply plugin: 'org.jetbrains.kotlin.jvm'
    // automatically adds…
    dependencies {
    api 'com.squareup.sqldelight:runtime-jdk:1.0.0'
    }X

    View Slide

  156. apply plugin: 'com.squareup.sqldelight'
    apply plugin: 'org.jetbrains.kotlin.jvm'
    // automatically adds…
    dependencies {
    api 'com.squareup.sqldelight:runtime-jdk:1.0.0'
    }X
    tasks.create('generateSqlDelight', SqlDelightTask) {
    // …
    }X
    tasks.getByName('compileKotlin').dependsOn('generateSqlDelight')

    View Slide

  157. apply plugin: 'com.squareup.sqldelight'
    apply plugin: 'org.jetbrains.kotlin.js'

    View Slide

  158. apply plugin: 'com.squareup.sqldelight'
    apply plugin: 'org.jetbrains.kotlin.js'
    // automatically adds…
    dependencies {
    api 'com.squareup.sqldelight:runtime-js:1.0.0'
    }X
    tasks.create('generateSqlDelight', SqlDelightTask) {
    // …
    }X
    tasks.getByName('compileKotlin').dependsOn('generateSqlDelight')

    View Slide

  159. apply plugin: 'com.squareup.sqldelight'
    apply plugin: 'org.jetbrains.kotlin.multiplatform'

    View Slide

  160. apply plugin: 'com.squareup.sqldelight'
    apply plugin: 'org.jetbrains.kotlin.multiplatform'
    // automatically adds…
    dependencies {
    api 'com.squareup.sqldelight:runtime:1.0.0'
    }X
    tasks.create('generateSqlDelight', SqlDelightTask) {
    // …
    }X
    tasks.getByName('compileKotlin').dependsOn('generateSqlDelight')

    View Slide

  161. apply plugin: 'com.squareup.sqldelight'
    apply plugin: 'org.jetbrains.kotlin.android'

    View Slide

  162. apply plugin: 'com.squareup.sqldelight'
    apply plugin: 'org.jetbrains.kotlin.android'
    // automatically adds…
    dependencies {
    api 'com.squareup.sqldelight:runtime-jdk:1.0.0'
    }X
    tasks.create('generateSqlDelight', SqlDelightTask) {
    // …
    }X
    tasks.getByName('compileKotlin').dependsOn('generateSqlDelight')

    View Slide

  163. m
    u
    l
    t
    i
    p
    l
    a
    t
    f
    o
    r
    m
    apply plugin: 'com.squareup.sqldelight'
    apply plugin: 'org.jetbrains.kotlin.android'
    // automatically adds…
    dependencies {
    api 'com.squareup.sqldelight:runtime-jdk:1.0.0'
    }X
    tasks.create('generateDebugSqlDelight', SqlDelightTask) {
    // …
    }X
    tasks.getByName('compileDebugKotlin').dependsOn('generateDebugSqlDelight')
    tasks.create('generateReleaseSqlDelight', SqlDelightTask) {
    // …
    }X
    tasks.getByName('compileReleaseKotlin').dependsOn('generateReleaseSqlDelight')

    View Slide

  164. tasks.getByName('compileDebugKotlin').dependsOn('generateDebugSqlDelight')
    tasks.getByName('compileReleaseKotlin').dependsOn('generateReleaseSqlDelight')
    m
    u
    l
    t
    i
    p
    l
    a
    t
    f
    o
    r
    m
    apply plugin: 'com.squareup.sqldelight'
    apply plugin: 'org.jetbrains.kotlin.android'
    // automatically adds…
    dependencies {
    api 'com.squareup.sqldelight:runtime-jdk:1.0.0'
    }X
    tasks.create('generateDebugSqlDelight', SqlDelightTask) { /* … */ }X
    tasks.create('generateReleaseSqlDelight', SqlDelightTask) { /* … */ }X
    tasks.create('verifySqlDelightMigration', VerifyMigrationTask) {
    // …
    }X

    View Slide

  165. IntelliJ Plugin

    View Slide

  166. IntelliJ Plugin

    View Slide

  167. IntelliJ Plugin

    View Slide

  168. Gradle
    Plugin
    Compiler
    Generated
    Code
    IntelliJ
    Plugin

    View Slide

  169. Gradle
    Plugin
    Compiler
    Generated
    Code
    IntelliJ
    Plugin

    View Slide

  170. Gradle
    Plugin
    Compiler
    Generated
    Code
    IntelliJ
    Plugin

    View Slide

  171. Gradle
    Plugin
    Compiler
    IntelliJ
    Plugin
    antlr
    SQLDelight 0.7

    View Slide

  172. Gradle
    Plugin
    Compiler
    IntelliJ
    Plugin
    antlr
    PSI
    SQLDelight 0.7

    View Slide

  173. Compiler
    Gradle
    Plugin
    IntelliJ
    Plugin
    PSI
    SQLDelight 1.0

    View Slide

  174. Compiler
    Gradle
    Plugin
    IntelliJ
    Plugin
    sqlite-psi
    SQLDelight 1.0

    View Slide

  175. JavaScript

    View Slide

  176. sqlite3.h
    ed
    Native
    Node? WASM? Vanilla JS?
    JavaScript
    Database
    Abstraction
    java.sql.*
    org.sqlite.* (xerial)
    Driver
    knarch.db
    Driver
    JDBC
    Driver
    JS
    Driver
    JVM
    Abstraction
    android.
    net.sqlc
    AndroidX
    SQLCipher Impl

    View Slide

  177. sqlite3.h
    ed
    Native
    Node? WASM? Vanilla JS?
    JavaScript
    Database
    Abstraction
    java.sql.*
    org.sqlite.* (xerial)
    Driver
    knarch.db
    Driver
    JDBC
    Driver
    JVM
    Abstraction
    android.
    net.sqlc
    AndroidX
    SQLCipher Impl

    View Slide

  178. Node
    WASM
    Vanilla JS
    runtime storage

    View Slide

  179. Node
    WASM
    Vanilla JS
    sqlite3
    runtime storage

    View Slide

  180. Node
    WASM
    Vanilla JS
    sqlite3
    sqlite-wasm
    runtime storage

    View Slide

  181. Node
    WASM
    Vanilla JS
    sqlite3
    sqlite-wasm
    sql.js
    runtime storage

    View Slide

  182. Node
    WASM
    Vanilla JS
    sqlite3
    sqlite-wasm
    sql.js
    filesystem
    runtime storage

    View Slide

  183. Node
    WASM
    Vanilla JS
    sqlite3
    sqlite-wasm
    sql.js
    filesystem
    ???
    ???
    runtime storage

    View Slide

  184. iOS

    View Slide

  185. let firstPlace = playerQueries.withRanking(
    ranking: 1
    ).executeAsOne()

    View Slide

  186. struct Player {A
    var id: NSNumber
    var name: String
    var country: String
    var ranking: NSNumber
    }A
    let firstPlace = playerQueries.withRanking(
    ranking: 1
    ).executeAsOne()

    View Slide

  187. struct Player {A
    var id: NSNumber
    var name: String
    var country: String
    var ranking: NSNumber
    }A
    func createPlayer(id: NSNumber, name: String, country: String,
    ranking: NSNumber) -> Player {A
    return Player(id: id, name: name, country: country,
    ranking: ranking)
    }A
    let firstPlace = playerQueries.withRanking(
    ranking: 1
    ).executeAsOne()

    View Slide

  188. struct Player {A
    var id: NSNumber
    var name: String
    var country: String
    var ranking: NSNumber
    }A
    func createPlayer(id: NSNumber, name: String, country: String,
    ranking: NSNumber) -> Player {A
    return Player(id: id, name: name, country: country,
    ranking: ranking)
    }A
    let firstPlace = playerQueries.withRanking(
    ranking: 1,
    mapper: createPlayer
    ).executeAsOne() as! Player

    View Slide

  189. Generated
    Code
    SQL Delight
    SQLite
    Generated
    Swift Code
    Compiler

    View Slide

  190. SQL Delight
    SQLite
    Compiler
    Generated
    Code
    Generated
    Swift Code

    View Slide

  191. View Slide

  192. View Slide

  193. View Slide

  194. View Slide

  195. View Slide

  196. View Slide

  197. View Slide

  198. View Slide

  199. View Slide

  200. withRanking:
    SELECT name
    FROM player
    WHERE ranking = ?;
    insert:
    INSERT INTO player (name, country, ranking)
    VALUES (?, ?, ?);

    View Slide

  201. withRanking:
    SELECT name
    WHERE ranking = ?;
    insert:
    (name, country, ranking)
    VALUES (?, ?, ?);
    FROM player
    INSERT INTO player

    View Slide

  202. withRanking:
    SELECT name
    FROM player
    WHERE ranking = ?;
    insert:
    INSERT INTO player (name, country, ranking)
    VALUES (?, ?, ?);
    private inner class Insert {
    fun execute(): Long {
    val result = statement.execute()
    notifyQueries(queryWrapper.playerQueries.withRanking)
    return result
    }
    }

    View Slide

  203. withRanking:
    SELECT name
    FROM player
    WHERE ranking = ?;
    insert:
    INSERT INTO player (name, country, ranking)
    VALUES (?, ?, ?);
    private inner class Insert {
    fun execute(): Long {
    val result = statement.execute()
    notifyQueries(queryWrapper.playerQueries.withRanking)
    return result
    }
    }
    private inner class Insert {
    fun execute(): Long {
    val result = statement.execute()
    notifyQueries(queryWrapper.playerQueries.withRanking)
    return result
    }
    }
    withRanking:
    SELECT name
    FROM player
    WHERE ranking = ?;
    insert:
    INSERT INTO player (name, country, ranking)
    VALUES (?, ?, ?);

    View Slide

  204. withRanking:
    SELECT name
    FROM player
    WHERE ranking = ?;
    insert:
    INSERT INTO player (name, country, ranking)
    VALUES (?, ?, ?);
    private inner class Insert {
    fun execute(): Long {
    val result = statement.execute()
    notifyQueries(queryWrapper.playerQueries.withRanking)
    return result
    }
    }
    withRanking:
    SELECT name
    FROM player
    WHERE ranking = ?;
    insert:
    INSERT INTO player (name, country, ranking)
    VALUES (?, ?, ?);

    View Slide

  205. Other SQL Dialects

    View Slide

  206. 1.0!

    View Slide

  207. 1.0! (RC)

    View Slide

  208. github.com/square/sqldelight

    View Slide

  209. github.com/square/sqldelight
    jakes.link/resurgence-of-sql
    jakes.link/embracing-sql

    View Slide

  210. github.com/square/sqldelight
    jakes.link/resurgence-of-sql
    jakes.link/embracing-sql
    IntelliJ Plugins – Friday @ 15:15, Berlagezaal

    View Slide

  211. @Strongolopolis
    @JakeWharton

    View Slide