microsoft / microsoft/vscode-pgsql

Improvements to Intellisense coming from DataGrip

Open
#90 1 comment 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

enhancement
Dominant language
No language data
Stars
395
Forks
33
Avg merge
1h 46m
Merged PRs (30d)
3

Description

Right now the Intellisense autocomplete suggestions are just listed in alphabetical order. For example:

Image

So the results are cluttered with built in functions that happen to have low alphabetical order. Compare this to JetBrains' DataGrip:

Image

It does three things better:

  • It shows the most relevant options first. In this case, the table names of the table we are querying
  • It shows the database and schema where each result is coming from
  • It shows the type of the column or the source database

Maybe this would fit better at pgtoolsservice or maybe pgsql-tools now? But I can't create an issue there.

I'd be happy to help work on improving the language server to improve these.

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

No files or tests are named. Start by tracing the Intellisense language-server implementation and compare the responsibilities of pgtoolsservice and pgsql-tools, which the issue references. Done means relevant table names are prioritized and results show their database, schema, and column or source type metadata.

Written by the indexing model from the issue text.

Assessment

Tech stack
postgresql, vscode
Domain
databases, devtools
Issue type
Feature
Difficulty
5/5
Estimated time
Over a week
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.