Neon Serverless Connection

[Brayden]

Purpose

Supports using the native Neon drivers for interacting with Neon data sources.

Tasks

• [X] Add support for the Neon serverless driver
• [X] Use web sockets for communication
• [X] Convert query params to Postgres positional (e.g. $1, $2, etc)
• [x] Write unit tests

Verify

• Add a Neon connection type to the playground (see sample code below)
• Try to execute a chained query
• Try to run a raw query with parameters

const neon = new NeonHttpConnection('postgresql://USER:PASSWORD@ep-damp-hill-a59vzq0g.us-east-2.aws.neon.tech/neondb?sslmode=require');
await neon.connect();
const db = Outerbase(neon);

// Chained query
let { data, query } = await db.selectFrom([
    { table: 'playing_with_neon', columns: ['id', 'name', 'value'] }
])
.where(equalsNumber('id', 1))
.query()

// Raw query
let { data } = await db.queryRaw('SELECT * FROM playing_with_neon WHERE id = $1', ['1']);

Before

After