PostgREST Instant REST API with PostgreSQL 17 on Ubuntu 24.04 LTS

Azure Application Infrastructure

An instant REST API over a relational database, generated from the schema itself with no application code to write.

Base
Hardened build
minimal ports, security patches applied at build time
Access
Unique credentials
generated on first boot, readable only by root
Verified
Boots working
services pass a health gate before release
Support
24/7, 365 days
by email and live chat, 24 hour response SLA

Overview

PostgREST turns a PostgreSQL database directly into a RESTful API. It reads the database schema and serves every table, view and function as a JSON endpoint, so filtering, ordering, pagination and writes all come for free. Authorisation is the database's own role and grant system rather than a separate application layer, and access is carried in signed JSON Web Tokens.

Why the cloudimg image

cloudimg ships PostgREST and PostgreSQL together on one hardened, fully patched appliance, wired up and serving a worked example schema the moment it boots. The API is deny by default: unauthenticated callers can reach only a health endpoint, and everything else requires a token signed with a secret unique to that instance. The database superuser password, the API connection password and the token signing secret are all generated on first boot with no default login, every connection is encrypted with a per instance TLS certificate, and 24/7 support is included.

Common uses

  • REST backends for single page apps
  • Rapid API prototyping over existing data
  • Serverless and mobile data services