Primate

MySQL

MySQL is a relational DBMS. Use it for durable, multi-connection workloads.

Setup

Install

npm install @primate/mysql

You need a running MySQL server. Create a database and user with access.

Configure

// config/database/index.ts
import mysql from "@primate/mysql";

export default mysql({
  database: "app",
  // host: "localhost",
  // port: 3306,
  // username: "root",
  // password: "secret",
});

Options

option type default description
database string Database name to use
host string "localhost" MySQL host
port number 3306 MySQL port
username string Username (omit for socket auth)
password string Password (omit if not required)
Previous
MongoDB
Next
PostgreSQL