Use the full power of PostgreSQL to define your schema. Views, functions, triggers, language extensions, everything works. »
create table project (
id serial primary key,
name text not null,
managerId int,
check (length(name)>2)
);
Leverage the time-tested Role-Based Access Control of your database to define granular and flexible permissions in a clear way. »
grant select on project to managers;
create policy manager_project_policy
for select on project to managers
using (request.user_id()=managerId);
Use the auto-generated GraphQL & REST api to build apps faster than you thought possible, with any frontend technology or framework.
{ projects(
where: {
name: {like: "*subzero*"}
}
) { id name }
}
subZero automates every part of setup, running and scaling of PostgREST+ in AWS. Let your team focus on what they do best - building your product. Leave PostgREST+ management and monitoring to the experts.
If you have compliance or privacy requirements, prefer a specific cloud provider or you want to run it internally on bare-metal, you can take it with you ... not questions asked :). You can purchase a license and download our binary & container distributions or even get the source code.