Fetch `tables()` on demand in the UI and autocomplete
Nobody has claimed this yet.
- 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
-
WHEREfor checking table existence in Import CSV
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- 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