Skip to content

SQL-S5 — SQLite Workspace & Table Browser #202

Description

@ZhuchkaTriplesix

Epic: #194
Depends on: #201 (SQL-S4)
Source: docs/planned-0.4.5.md

Goal

Implement the main editor workspace for SQLite and the paginated table grid browser.

Files

  • lib/features/workspace/widgets/sqlite_workspace_home.dart (new)
  • lib/features/workspace/widgets/sqlite_table_view.dart (new)
  • lib/features/workspace/widgets/workspace_panel.dart (edit)

Implementation

  • Update WorkspacePanel to render SqliteWorkspaceHome when an active connection is SQLite.
  • Build SqliteWorkspaceHome containing a SQL Query Editor and results grid.
  • Build SqliteTableView showing paginated browse view of tables (using SELECT ... LIMIT ... OFFSET ...).
  • Integrate scroll physics and standard shadcn UI tables for results.

Acceptance Criteria

  • SQL editor successfully executes queries against SQLite file and shows results.
  • Double-clicking a table in sidebar opens paginated browser.
  • Paginated browser limits memory consumption, loading data in chunks.
  • Code is clean and passes flutter analyze.

Metadata

Metadata

Labels

sqliteSQLite database driver and workspaceuiUser interface components and widgets

Type

No type

Projects

No projects

Relationships

None yet

Development

No branches or pull requests

Issue actions