Postgres Browser Proxy
Query your Postgres Database directly from the Browser.
Video:
https://youtu.be/ohr9gBPC3cE
Download the latest binaries:
https://github.com/yandeu/postgres-browser-proxy/releases
Add more types to it:
https://docs.rs/postgres/latest/postgres/types/trait.FromSql.html#types
How
The proxy is by default running on port 3000 and is connecting to Postgres on localhost:5432 with user "postgres" and password "mysecretpassword".
# start postgres (using docker)
docker run --name some-postgres -p 5432:5432 -e POSTGRES_PASSWORD=mysecretpassword -d postgres:15-alpine
Windows
.\postgres-browser-proxy.exe
Linux/MacOS
chmod +x postgres-browser-proxy
./postgres-browser-proxy
CLI Options
Usage: postgres-browser-proxy.exe [OPTIONS]
Options:
--host <HOST> [default: localhost]
--user <USER> [default: postgres]
--password <PASSWORD> [default: mysecretpassword]
--port <PORT> [default: 3000]
--pg-port <PG_PORT> [default: 5432]
-h, --help Print help information
-V, --version Print version information
Example
It looks like this in your client-side javascript.
More examples are in the examples directory.
// @ts-check
// @ts-ignore
import { query } from 'http://localhost:3000/query.js'
// await query(/*sql*/ `DROP TABLE users;`)
await query(/*sql*/ `
CREATE TABLE IF NOT EXISTS users (
id SERIAL PRIMARY KEY,
username VARCHAR(255) NOT NULL,
age INT,
created_at TIMESTAMP WITH TIME ZONE DEFAULT now()
);
`)
await query(/*sql*/ `
INSERT INTO
users (username, age)
VALUES
('Macy', 24),
('Terry', NULL),
('Evan', NULL);
`)
const users = await query(/*sql*/ `SELECT * FROM users;`)
console.log(users)
License
Licensed under GPLv3 Copyright (c) 2022, Yannick Deubel
Please have a look at the LICENSE for more details.
1 Dec 6, 2021
6 Nov 7, 2022
44 Jan 29, 2023
341 Feb 6, 2023
462 Mar 6, 2023
16 Dec 15, 2022
26 Jun 15, 2023
37 Jun 24, 2023
5 Oct 3, 2023
3 Oct 22, 2022
5 Aug 3, 2023
7 Nov 1, 2023
11 Dec 26, 2022
409 Oct 23, 2022
7 Mar 19, 2022
246 Dec 20, 2022
8 Aug 30, 2022
1 Mar 15, 2022
2 Mar 18, 2022