page:recipes:form collection:rails:data imports

Host form collection with Rails: structured data imports

Deploy a form collection built with Rails on Ample using the bulk import staging 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, a private S3-compatible bucket holds objects with credentials delivered as encrypted environment variables. Verified on Rails: a CSV staged as an object, row-level validation with per-row errors recorded, and a restart-safe import keyed by import id (imported=2 rejected=1 restart=ok). Not separately tested: your import format, mapping and conflict rules; treat the form collection-specific behavior as your application code.

Representative Queries

Resource Requirements

Infrastructure Requirements

  1. Compute: Managed PostgreSQL 16 runs in its own microVM and is auto-provisioned when an app needs a database.
  2. Postgres: Apps run in isolated x86_64 Firecracker microVMs that auto-pause when idle.
  3. S3-compatible object storage: Buckets are S3-compatible; PutObject and GetObject are verified by canary.

Prerequisites

Workflow Steps

  1. Build and start: Run bundle install and start with rails server.
  2. Implement the pattern on PostgreSQL: Use CSV staged as an object for validation and error recording.
  3. Wire object storage: Create buckets and pass credentials as environment variables.
  4. Deploy: Run the synchronous deploy and check the result.
  5. Verify: Fetch the live URL and perform self-checks.

Examples

Success Checks

Limitations

Cost Estimate

Evidence Summary