sql
CREATE INDEX IF NOT EXISTS index_name ON table_name (column_name);
kotlin
database.transaction {
val insertStatement = dataModel.insert().prepare()
for (item in items) {
insertStatement.bind(item)
insertStatement.executeInsert()
}
insertStatement.dispose()
}
kotlin
val configuration = HikariConfig()
configuration.jdbcUrl = "jdbc:sqlite:/path/to/database.db"
configuration.maximumPoolSize = 10
val dataSource = HikariDataSource(configuration)
Database.registerSqlDriver(
JdbcSqliteDriver(url = configuration.jdbcUrl, create = { dataSource.connection }, delete = { })
)
kotlin
SELECT *
FROM table1
JOIN table2 ON table1.key = table2.key
SELECT *
FROM table
LIMIT 10
SELECT category, COUNT(*)
FROM products
GROUP BY category
sql
SELECT *
FROM table
LIMIT 10 OFFSET 20
