planetscale-node

planetscale-node

This is a very basic (v0.0.1) JavaScript client for connecting to PlanetScale.

Setup

This code uses the PlanetScale API to provision a TLS certificate, and then connects to the database. It uses Service Tokens for authentication, so you'll need to create one for the app:

~> pscale service-token create
  NAME           TOKEN
 -------------- ------------------------------------------
  nyprhd2z6bd3   [REDACTED]

~> pscale service-token add-access nyprhd2z6bd3 connect_production_branch --database [YOUR DB]
  DATABASE   ACCESSES
 ---------- ---------------------------
  [YOUR DB]       connect_production_branch

Once you have this, set the following environment variables in your application:

export PSDB_TOKEN='[REDACTED]'
export PSDB_TOKEN_NAME='nyprhd2z6bd3'
export PSDB_DB_NAME='[YOUR ORG]/[YOUR DB NAME]'

Then, you can use it:

const db = require('psdb-node');
conn = new db('main');
let [rows, fields] = await conn.query('SELECT * FROM reminders')