Deploy Postgres HTTP (Canary)

Turns your postgres db into an REST api

Deploy Postgres HTTP (Canary)

/var/lib/postgresql/data

Postgres HTTP (Canary)

lassejlv/postgres_http:canary

Just deployed

Postgres HTTP (Canary)

Beaware this is canary version with. Use the stable one if you dont wanna see bugs: https://railway.com/template/UYtPO2?referralCode=lasse

Turns your postgres db into an http server. Great for beginners or just small projects and testing.

You can find the source code here: github.com/lassejlv/postgres_http

API reference

- POST /query
  - body: { query: string, args: any[] }
  - headers: { Authorization: Bearer  }
  - response: { rows: any[] }

- GET /status
   - headers: { Authorization: Bearer  }
   - response: { ok: boolean, ping: number  }

I cant run...

By default you cannot run: DELETE, DROP, TRUNCATE. Update the env variable ALLOW_DANGEROUS_SQL_COMMANDS and set it to true if you wanna be doing that.

API key

You will find the api under the variables tab. It's randomly generated under creation.


Template Content

More templates in this category

View Template
Rocky Linux
Hosted Rocky Linux 9 workspace with SSH and persistent storage. 🚀

codestorm
51
View Template
Foundry Virtual Tabletop
Self-hosted virtual tabletop for role-playing games (license required)

Lucas
71
View Template
NEW
Double Commander in your browser
The Double Commander file manager in the cloud, from any device

Nermin Sabanovic
0