NightwatchDB

Writing your bot's database can be a pain. As you develop your bot, you will constantly modify your schema, risking losing data if you don't migrate it. NightwatchDB solves that issue by allowing you to have a premade database ready to be thrown into your bot. It is designed to store all the data you need plus more.

NightwatchDB is the database module for the Nightwatch Discord bot, made public so anyone can have a premade database for their bot as well.

The purpose of the database being its own module, is to make the parent bot more modular, like a micro-service for the bot. It also allows the database to easily be reused in a web interface for the bot, using Angular 5.

Feel free to suggest new entities/columns, or even create a Pull Request to add your own changes. If I like it, I may even implement it into the Nightwatch bot.

Prerequisites

• Node.js >= 8.9.0
• PostgreSQL > 9.0
• A Discord bot running on Discord.js
• Redis

Installation

$ npm i -s Nightwatch/db

Usage

First we need to import the module.

import{connect,Connection}from'@nightwatch/db'

At the basic level, we need to connect to the database, so we import theconnectmethod. The connect method returns a Promise of typeConnectionso we can import that also.

Theconnectmethod expects an object with a few connection options: host, username, password, database, and port.

// Preferably, you should store these externally, like in a json file. This is just for example.
constoptions={
host:'localhost'
username:'postgres',
password:'',
database:'postgres',
port:5432
}

connect(options)
.then((connection:Connection)=>{
// Connection successful, woohoo!
})
.catch((error:Error)=>{
// Handle error
})

Alternatively, you can useasync/awaitto connect.

constconnection:Connection=awaitconnect(options)

All methods in the module return a promise.

The module itself does not handle any exceptions, it simply executes something and immediately returns the result. You will have to handle the exceptions on your end.