remix/data-table/mysql · Function

View Source

createMysqlDatabaseAdapter

Summary

Creates a mysql DatabaseAdapter.

Signature

function createMysqlDatabaseAdapter(client: MysqlQueryable): MysqlDatabaseAdapter

Example

import { createPool } from 'mysql2/promise'
import { createDatabase } from 'remix/data-table'
import { createMysqlDatabaseAdapter } from 'remix/data-table/mysql'

let pool = createPool({ uri: process.env.DATABASE_URL })
let adapter = createMysqlDatabaseAdapter(pool)
let db = createDatabase(adapter)

Parameters

client

Mysql pool or connection.

Returns

A configured mysql adapter.