Skip to content

SQL sample

Using the SQL sample bundle

The SQL example bundle in samples/sql demonstrates the ability to access databases. Here is a guide to how to get it working.

Prerequisites

You will need a working nodecg-io installation. If you have non yet take a look at installation guide. You may need to install this bundle, so take a look at the “Try an included sample”-Guide. It will also tell you how to log in and how to use the GUI.

You also need:

  • A database supported by knex

Note

If you don't have a database yet and just want to test things you can use sqlite3 and don't need to set up a database server. You can always move to a different database type later.

Configure the SQL sample bundle

  1. In NodeCG, create a new SQL service instance.

  2. Enter your used database client and a knex connection object for SQL:

    {
        "client": "mysql",
        "connection": {
            "host": "localhost",
            ...
        }
    }
    

    After entering it, click save.

  3. Set the sample's (sql) dependency to be the newly created service instance (of type sql).

  4. Check the NodeCG logs:

    Your first run of the sample bundle will probably fail because your database doesn't contain the used tables. Check samples/sql/extension/index.ts and create the tables as used or create your own tables and adapt the sample accordingly. You can also use this code as a reference on how to use the SQL client to do your queries.