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

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:

npm install mysql2 --save
npm install mariasql --save
npm install sqlite3 --save
npm install pg --save

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