Cloud functions run in a NodeJS virtual machine with modified global variables and methods. The connect function is designed to work with a Postgresql database. To get a cloud database up and running quickly, try ElephantSQL.

Samples

// Connect to database, make a query, then send a response.
connect(env.connectionString)
let rows = await sql("select now()")
send(rows[0].now + '<br>User Agent: ' + getHeader('user-agent'))

// Simple Proxy
let req = await fetch(query.url, {method: method, body: JSON.stringify(json)})
let response = await req.text()
send(response)

/* 
  Uraik.us SSO Validation
  With your client, include your public key in as the authorization header: 'Bearer ' + sso.publicKey
  See https://sso.uraik.us/api/
*/
let userId = await validate() // Will be null on fail
if (userId) send(200)
else send(401)

Global Variables

method:String // http method
env:Object // environmental variable object
query:Object // request query string variables
json:Object || :Null // uploaded json body, request header must include header: {'Content-Type': 'application/json'}

Global Methods

connect(postgresqlConnection:String)
sql(sql:String, sqlVariables:Array)
status(httpCode:Number)
getHeader(header:String)
redirect(url:String)
validate()
send(response:Any) // Objects will automatically send with JSON headers
fetch(url:String, options:Object) // Mirrors client JS fetch function