QTable · one complete open-source product

Structured work,
unified from interface to services.

QTable unifies the web application, API and domain services around one data model, permission boundary and release cadence to form a complete self-hostable work system.

5 viewsGrid · Kanban · Gantt · Calendar · Gallery
Complete work shellHome · My Work · Projects · Dashboards · Automations
Self-hostablePostgreSQL · Redis · S3-compatible
Apache-2.0v0.1.1-alpha open-source preview
Product composition

One product, two implementation layers.

Separate code repositories are an engineering boundary. Product experience and data contracts stay unified.

WEBWeb frontend implementation

QTable Web App

The React application used by end users: work centers, five views, dashboards, automation, notifications, record collaboration, search, recycle, AI and Source Inbox.

  • React 19 + TypeScript 7
  • VTable / VTable Gantt
  • Apollo Client + Zustand
  • Nginx self-hosted runtime
Frontend implementation source ↗
APIAPI & domain services

QTable API & Domain Services

The core service layer for server-side models, security boundaries and auditable mutations.

  • FastAPI + Strawberry GraphQL
  • Workspace / row-level permission
  • Automation / Dashboard / ChangeSet
  • PostgreSQL + Redis + S3-compatible storage
Backend source ↗
REST / GraphQL / WebSocket / Auth / OAuth
Core capabilities

End-to-end capability around one work model.

Projects, views, collaboration, automation, dashboards and AI do not need a second task database.

Multidimensional tables

Fields, records, filters, multi-field sorting, grouping, named views and work semantics.

Five project views

Move the same records through Grid, Kanban, Gantt, Calendar and Gallery.

Work centers

Home / My Work / Projects provide real personal and project entry points.

Permissions & safety

Workspace, object and row-level permission protects detail, aggregation, search and AI.

Automation

Rule validation, execution, enable/disable, testing and execution history.

Dashboards

Dashboard Center, Workbench, server aggregation and safe public sharing.

Collaboration

Notifications, record workspace, activity and realtime paths.

Search & recovery

Permission-aware global search, ChangeSet and Recycle Bin.

Private attachments

Stable object identity, permission revalidation and recoverable S3 lifecycle.

QTable web experience

The QTable web experience carries the complete product interaction model.

The interactive tour below uses local simulated data to demonstrate QTable’s five views. The real runtime is implemented by the frontend repository against QTable APIs.

React 19TypeScript 7VTableApollo ClientZustandVChart
Live interface tourRelease workspace
Interactive demo · no backend requiredFrontend implementation source
AI-native workflows

AI suggestions stay inside QTable’s permission and mutation model.

From goal generation to Project Steward and safe action plans, AI reuses existing Table / View / Dashboard / Permission models.

01

Goal → Workspace

Generate an initial work structure from a goal.

02

Task planning

Break goals into executable tasks and project structure.

03

Workload & assignment

Estimate workload and schedule, then suggest workspace members.

04

Project Steward

Diagnose project state and answer questions from permission-filtered records.

05

AI views & dashboards

Generate visual structures through existing View and Dashboard models.

06

Preview → Confirm → Apply

Inspect diffs, accept selectively, then revalidate permission and state.

Safety & data lifecycle

Writes, files and collaboration stay inside server-side safety boundaries.

The client experience does not weaken QTable’s permission, paging, audit or private attachment contracts.

Permission & auditable changes

  • AI reads only context visible to the current user
  • Preview never mutates business data
  • Apply revalidates permission and concurrent state
  • Large-table paths preserve server paging and aggregation

Private attachment lifecycle

  • Records keep stable attachmentId / objectKey metadata
  • Upload, read and delete re-check permission
  • Recycle / Restore preserves object identity
  • Upload Intent supports recovery and cleanup after interrupted writes
Self-hosting

The canonical stack runs the complete QTable in one path.

PostgreSQL is the normal development and deployment default; SQLite is an explicit lightweight fallback only.

Quick start →

QTable Web App

Nginx · PORT 9100

React 19 + TypeScriptVTable + ApolloWeb frontend implementation

QTable API

FastAPI · PORT 9000

GraphQL · RESTWebSocket · OAuthPermission · Automation · AI

Data & storage

recommended data store

PostgreSQL 16Redis 7MinIO / external S3SQLite fallback

Launch the complete QTable stack.

Quick Start launches API dependencies and the web frontend; the Feature Matrix documents current Alpha boundaries.