Grind’s Database provider integrates Grind with knex.js.

First, add the grind-db package via your preferred package manager:

yarn add grind-db

Next, you’ll need to add DatabaseProvider to your app providers in app/Boostrap.js:

import Grind from 'grind-framework'
import { DatabaseProvider } from 'grind-db'
 
const app = new Grind()
app.providers.push(DatabaseProvider)

In order to actually use a database, you’ll first need to install the database driver(s) you need. Knex supports a variety of different drivers:

yarn add mysql2
yarn add mariasql
yarn add sqlite3
yarn add pg

The default database connection is exposed via app.db. For full details on how the query builder works, head over to the knex.js documentation.

app.db('users').where('name', 'like', 'grind%').then(users => {
  Log.comment('Retrieved users', users)
})

Your database config should live in /config/database.json.

Here’s an example of a config file that supports both MariaDB and SQLite:

{
  "default": "sqlite3",
  "connections": {
    "maria": {
      "driver": "mariasql",
      "host": "localhost",
      "db": "app-db-name",
      "user": "app-user",
      "password": "app-password",
      "charset": "utf8"
    },
    "sqlite3": {
      "driver": "sqlite3",
      "filename": "./database/database.sqlite",
      "useNullAsDefault": true
    }
  }
}

The default key tells the Database provider which connection it should load by default.

Edit