Simon Willison’s Weblog

Subscribe

Friday, 27th March 2020

PostGraphile: Production Considerations. PostGraphile is a tool for building a GraphQL API on top of an existing PostgreSQL schema. Their “production considerations” documentation is particularly interesting because it directly addresses some of my biggest worries about GraphQL: the potential for someone to craft an expensive query that ties up server resources. PostGraphile suggests a number of techniques for avoiding this, including a statement timeout, a query allowlist, pagination caps and (in their “pro” version) a cost limit that uses a calculated cost score for the query.

# 1:22 am / apis, postgresql, scaling, graphql

2020 » March

MTWTFSS
      1
2345678
9101112131415
16171819202122
23242526272829
3031