df-research/dataframe/docs/StardustDocs/topics/dataSources/sql/MariaDB.md

MariaDB

Access MariaDB databases using Kotlin DataFrame and JDBC — fetch data from tables or custom SQL queries with ease. Seamlessly integrate MariaDB with Kotlin DataFrame — load data using JDBC and analyze it in Kotlin. Read data from MariaDB into Kotlin DataFrame using standard JDBC configurations.

Kotlin DataFrame supports reading from MariaDB database using JDBC.

Requires the dataframe-jdbc module, which is included by default in the general dataframe artifact and in %use dataframe for Kotlin Notebook.

You’ll also need the official MariaDB JDBC driver:

dependencies {
    implementation("org.mariadb.jdbc:mariadb-java-client:$version")
}

USE {
    dependencies("org.mariadb.jdbc:mariadb-java-client:$version")
}

The actual Maven Central driver version could be found here.

Read

DataFrame can be loaded from a database in several ways:
a user can read data from a SQL table by given name (readSqlTable),
as a result of a user-defined SQL query (readSqlQuery),
or from a given ResultSet (readResultSet).
It is also possible to load all data from non-system tables, each into a separate DataFrame (readAllSqlTables).

See for more details.

import org.jetbrains.kotlinx.dataframe.io.DbConnectionConfig
import org.jetbrains.kotlinx.dataframe.api.*

val url = "jdbc:mariadb://localhost:3306/testDatabase"
val username = "root"
val password = "password"

val dbConfig = DbConnectionConfig(url, username, password)

val tableName = "Customer"

val df = DataFrame.readSqlTable(dbConfig, tableName)