page:recipes:graphql api:gin:persistent state

Host graphql api with Gin: Postgres-backed state

Deploy a graphql api built with Gin on Ample using the durable job state pattern. Compute runs the app in an isolated microVM behind a public HTTPS URL, a managed PostgreSQL 16 database is auto-provisioned and injected as DATABASE_URL. Verified on Gin: a jobs table with a state and attempts counter, processing inside a row-locked transaction, and a second run that is a no-op (job=done attempts=1 idempotent=true). Not separately tested: your job types, payload schema and retry policy; treat the graphql api-specific behavior as your application code.

Representative Queries

Resource Requirements

Infrastructure Requirements

  1. Compute

    • Status: verified
    • Summary: Apps run in isolated x86_64 Firecracker microVMs that auto-pause when idle and wake on request; sizes are the priced VM sizes.

  2. Postgres

    • Status: verified
    • Summary: Managed PostgreSQL 16 runs in its own microVM and is auto-provisioned when an app needs a database and no DATABASE_URL is supplied.

Execution Status

Prerequisites

Workflow Steps

  1. Build and start
    CGO_ENABLED=0 go build -o app ./... then ./app on the ubuntu-24.04 template (go.sum committed for a reproducible build). The server must bind 0.0.0.0 on PORT.

  2. Implement the pattern on PostgreSQL
    The fixture's module implements durable job state: a jobs table with a state and attempts counter, processing inside a row-locked transaction, and a second run that is a no-op (job=done attempts=1 idempotent=true). Copy the approach into your schema; keep migrations idempotent and run them with --release-command.

  3. Deploy
    Run the synchronous deploy once and read the result (exit 0 live, 1 failed, 2 blocked). Re-running with no change is a no-op.
    Command: ample deploy . --name --public

  4. Verify
    Fetch the live URL and the pattern self-test route(s) (/p/durable-job-state) from the example; then run your own checks. On failure read ample logs --kind build then --kind runtime.
    Command: ample logs --kind build

Examples

Gin pattern fixture

Limitations

Cost Estimate

Evidence Summary

  1. Kind: canary_run

    • Summary: Gin pattern fixture deployed on Ample (CGO_ENABLED=0 go build -o app ./... then ./app on the ubuntu-24.04 template (go.sum committed for a reproducible build)); checks passed for durable-job-state and configuration-secrets. Pattern proof: a jobs table with a state and attempts counter, processing inside a row-locked transaction, and a second run that is a no-op (job=done attempts=1 idempotent=true).
    • Observed At: 2026-09-21T01:15:54Z
    • Implementation Revision: 50dbac567d2c5cc8e55e6c748a646be0025d9cfb-dirty (CLI 0.1.21)
    • Expires At: 2027-03-20T01:15:54Z
    • Scope: {"checks":["/p/durable-job-state"],"pattern":"pattern:durable-job-state","template":"ubuntu-24.04"}

  2. Kind: canary_run

    • Summary: The same Gin app deployed with a --release-command migration; the marker it created was readable after activation.
    • Observed At: 2026-09-20T02:43:30Z
    • Implementation Revision: 199ff1dfd52683832ae75d3f98b53a7a4bff7f96-dirty (CLI b75e104)
    • Expires At: 2027-03-19T02:43:30Z
    • Scope: {"pattern":"pattern:durable-job-state"}

Last Verified At

Unknowns

Formats

Next Actions

  1. Action ID: browse-catalog

    • Label: Browse the catalog index
    • Method: GET
    • Path: /v1/catalog
    • Requires Authentication: No

  2. Action ID: search-recipes

    • Label: Search published recipes by intent, stack and constraints
    • Method: POST
    • Path: /v1/catalog/search
    • Requires Authentication: No

  3. Action ID: plan:page:recipes:graphql-api:gin:persistent-state

    • Label: Prepare a side-effect-free deployment plan for an authorized project
    • Method: POST
    • Path: /v1/catalog/plan
    • Requires Authentication: Yes

  4. Action ID: auth-setup

    • Label: Read the existing agent authentication setup
    • Method: GET
    • Path: /mcp/setup
    • Requires Authentication: No

  5. Action ID: browse:workload:graphql-api

    • Label: Browse GraphQL API
    • Method: GET
    • Path: /v1/catalog/nodes/workload%3Agraphql-api
    • Requires Authentication: No

  6. Action ID: browse:stack:framework-gin

    • Label: Browse Gin
    • Method: GET
    • Path: /v1/catalog/nodes/stack%3Aframework-gin
    • Requires Authentication: No

  7. Action ID: browse:pattern:durable-job-state

    • Label: Browse Durable job state
    • Method: GET
    • Path: /v1/catalog/nodes/pattern%3Adurable-job-state
    • Requires Authentication: No

  8. Action ID: browse:intent:deploy-api

    • Label: Browse Deploy API
    • Method: GET
    • Path: /v1/catalog/nodes/intent%3Adeploy-api
    • Requires Authentication: No