Internal.io

Provides a drag-and-drop interface for non-technical users to construct custom business applications without writing code. Uses a component-based architecture where UI elements (forms, tables, buttons) are declaratively defined and bound to backend data sources through a visual configuration layer, eliminating the need for frontend development while maintaining full customization of layouts and interactions.

Automatically discovers and maps database schemas (tables, columns, relationships, constraints) from connected data sources, exposing them as queryable entities within the platform. Implements connection pooling and query optimization to handle multiple simultaneous database connections while maintaining performance, supporting PostgreSQL, MySQL, and cloud-hosted databases through standardized JDBC/native drivers.

Enforces fine-grained access control at the application, page, and data-level through a role hierarchy system. Implements permission evaluation at query time, filtering database results based on user roles and custom permission rules, ensuring users only see and interact with data they're authorized to access. Supports role inheritance, dynamic role assignment, and audit logging of access decisions.

Enables definition of multi-step approval processes where actions (data submissions, record updates) require sign-off from designated approvers based on configurable rules. Uses a state machine pattern to track workflow progress, route requests to appropriate approvers based on conditions (amount thresholds, department, priority), and enforce sequential or parallel approval steps. Integrates with notification system to alert approvers and track approval history.

Automatically synchronizes form inputs with database records through a two-way binding mechanism, where form field changes are persisted to the database in real-time or on explicit save, and database updates are reflected in the UI without page refresh. Implements optimistic updates (immediate UI feedback) with conflict resolution for concurrent edits, and supports field-level validation rules that execute before database writes.

Allows definition of custom actions (buttons, triggers) that execute arbitrary business logic by calling external APIs, webhooks, or internal services. Supports parameterized API calls where action parameters are derived from form data or database context, with response handling that can update UI state or trigger downstream workflows. Implements request/response transformation to map between platform data formats and external API schemas.

Renders database query results in interactive tables with built-in sorting (by column), filtering (text search, range filters, multi-select), and pagination controls. Implements client-side caching of query results to enable fast sorting/filtering without repeated database queries, and supports lazy-loading for large datasets to maintain UI responsiveness. Allows customization of column visibility, formatting, and inline editing.

Enables definition of recurring tasks (daily, weekly, monthly) or event-triggered jobs that execute actions outside of user interactions, such as data synchronization, report generation, or cleanup operations. Uses a job scheduler to manage task execution timing and retry logic, with support for conditional execution based on data state. Provides execution logs and monitoring to track job success/failure.

Automatically logs all user actions (data reads, writes, deletes, approvals) with timestamps, user identity, and change details, creating an immutable audit trail for compliance and forensics. Stores audit logs in a dedicated system with query capabilities to search by user, action type, resource, or time range. Supports retention policies and export for compliance reporting.