jakob / jakob/Postico

Autocomplete improvements for tables

Open
#474 3 comments 0 reactions 0 assignees View on GitHub
Dominant language
Python
Stars
485
Forks
8
PR merge metrics
No merged PRs in 30d

Description

When completing tables (or table like things) the priority of completed items could be improved.
For one thing it makes no sense to offer columns as a completion after `FROM`, `JOIN` keywords.

I think a good list of options (sorted by priority) would be:

- CTE names
- tables/views that are directly visible, i.e. that belong to the `PATH`
- schemas
- functions

After the `UPDATE` keyword the list would not contain CTEs and functions.

Contributor guide

No contributing guide indexed for this repository

Research direction

No files, tests, or entry points are named. Start by tracing completion handling for FROM, JOIN, and UPDATE clauses, then verify that CTEs, visible tables or views, schemas, and functions appear in the requested priority order and that UPDATE excludes CTEs and functions.

Written by the indexing model from the issue text.

Assessment

Tech stack
postgresql, sql
Domain
database
Issue type
Feature
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
38/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.