Collaboration with microsofts reworked vscode pgsql extension helpful?

[Donnerstagnacht]

It is not a real feature request but since this repo has no discussion section, I add as an issue:

Microsoft released/reworked its vscode postgres extension

Anouncement

code

In their announcement, they mention as a first bullet point in the section what sets their project apart from other postgres tooling projects and why people should use their project:

Enhanced Productivity: Features like context-aware IntelliSense and SQL formatting save time and minimize errors.

I think that IntelliSense is the strength of this project (postgrestools-vscode). However, both extensions offer a few IntelliSense features that the other does not support yet.

For example, their extension offers

1. Suggestions for sql keywords
2. Basic suggestions inside postgres function bodies (columns, tables)
   => but both only in a query context opened from their extension tab, e.g. not for general sql files.

These two features are still missing here as far as I know (even work is in progress).

On the other hand, this extension offers IntelliSense they do not support

1. Linting
2. Function parameter names
3. ...

My conclusion would be, that combining both feature sets might cover 90%+ of the most common IntelliSense, productivity and linting features.

Probably, a collaboration with a Microsoft backed project could also increase the resources or the visibility of this project.

So I was wondering if you believe that there is an overlap in features and if some collaboration would be useful/helpful? For example, if this project could learn from their keyword support and suggestion strategy or overtake their features. Or if the postgres language server could be included in their project? And if yes, if you think reaching out to them would be good idea?

[diraneyya]

I am one of the folks who are incredibly frustrated with Microsoft. Namely, the planned deprecation of Azure Data Studio has not been accompanied by a steady effort to allow VS Code to replace it (as planned). The VS Code extension does not work well and I am personally still relying on Azure Data Studio for my dev work.

I really would like it if more collaboration would happen in this space so that we all can have reliable tools that do the bare minimum when doing dev work with PostgreSQL. It is a vital technology and sorely needed for embedding-based matching.