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.