For making SQL queries directly from the browser to a pg database. Because why not!
import pegsocket from './pegsocket.js'
const pg = await pegsocket({ url: 'ws:https://example.com:15432', database: 'web', user: 'browser' });
const result = await pg.query("select 'Hello ' || $1 || '!' msg", ['world']);
=> { rows:[{ msg: "Hello world!" }], updated: 0 }- Expose pg port as WebSocket endpoint with e.g., pg_websocket.
- Configure scram-sha-256 or trust authentication for a db user in
pg_hba.conf.