wpsql - Web PostgreSQL client
Server
Install
go get github.com/UNO-SOFT/wpsql
Usage
wpsql [opts] serve [flags]
This starts a server that connects to the allowed databases (-databases
flag),
on -db-host
with -db-user
using the password in the -pwenv
environment variable.
It allows modifiaction only with the shared secret specified in -update-secret-env
environment variable.
Client
There's a library under ./client (go get github.com/UNO-SOFT/wpsql/client
),
and a simple command line client is usable as
wpsql client -db=remote_db -server=http://remote_host:port "SELECT * FROM information_schema.tables"