Design an Internal-Tools / App-Builder Platform

Problem

Design Retool's platform: a low-code internal-tools builder where users assemble apps that query their databases/APIs.

Requirements

Functional:

  • Drag-drop components bound to data sources
  • Run queries against user DBs/APIs securely
  • Reactive bindings between components
  • Permissions and audit

Non-functional:

  • Many orgs, sensitive data sources
  • Secure query execution
  • Fast reactive UI

Discussion points

  1. App definition model (components + bindings)
  2. Secure query proxy to user data sources
  3. Reactive evaluation engine
  4. JavaScript sandboxing for custom code
  5. Permissions, audit, multi-tenancy
added …
LeaderboardSalaryAccount