questdb / questdb/ui

Fetch `tables()` on demand in the UI and autocomplete

Open
#319 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

enhancement Severity: 2 web-console
Dominant language
TypeScript
Stars
29
Forks
39
Avg merge
4d 11h
Merged PRs (30d)
4

Description

The current application logic fetches the table list on boot and refreshes the result set in certain situations (i.e. after a DDL type query). This is fine, unless the user has a lot of tables in the database (1000+), in which case the application can become unstable or stop working altogether.

To fix the problem, the tables() query has to be paginated. There is a number of things that have to be done in the application logic:

  • Add method to fetch tables with LIMIT or WHERE filter
  • LIMIT for table listing
  • WHERE for FIlter search bar
  • Refactor Tables UI to paginate table results
  • Refactor Filter search bar to use SQL filter when searching
  • Refactor Create Table to use search on demand when validating if a given table name exists already
  • WHERE for checking table existence in Import CSV

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start by tracing the boot-time tables() query and the Tables UI, autocomplete, filter search bar, Create Table validation, and Import CSV table-existence check. Done means table listing and searches use bounded or filtered queries, the UI paginates results, and the listed validation flows fetch table data on demand.

Written by the indexing model from the issue text.

Assessment

Tech stack
react, typescript
Domain
database, frontend
Issue type
Refactor
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.