5 ms·

Thanks, looks very interesting. I have a couple of questions: 1. Will I be able to use this in my IDE (say JetBrains or VSCode) alongside the programming lang

Thanks, looks very interesting. I have a couple of questions: 1. Will I be able to use this in my IDE (say JetBrains or VSCode) alongside the programming language’s LSP? So that this project would only be in effect for the Pg SQL bits? 2. I am a Rust newbie but I’m an experienced developer. Is there any room for someone like me to contribute to the project?

kiwicopple 3y ago
1. yes this is possible, although it depends on your IDE. Here is a relevant discussion for eclipse (which also links to the VSCode implementation): https://github.com/eclipse/che/issues/4609 https://github.com/eclipse/che/issues/4609. Note: i also didn't know how this worked, so I learned something today too. 2. Yes, absolutely. Feel free to reach out to me directly, or just start contributing directly if you want
SpaghettiCthulu 3y ago
> 1. Will I be able to use this in my IDE (say JetBrains or VSCode) alongside the programming language’s LSP? So that this project would only be in effect for the Pg SQL bits? I think that would depend on IDE support. For example, JetBrains IDEs have a feature for this.
kyrra 3y ago
1) looks like intelliJ paid versions support (or will support) LSPs soon. https://blog.jetbrains.com/platform/2023/07/lsp-for-plugin-developers/ https://blog.jetbrains.com/platform/2023/07/lsp-for-plugin-d... > Starting with the 2023.2 release cycle, the LSP API is publicly available as part of the IntelliJ Platform in the following IDEs: IntelliJ IDEA Ultimate, WebStorm, PhpStorm, PyCharm Professional, DataSpell, RubyMine, CLion, Aqua, DataGrip, GoLand, Rider
cube2222 3y ago
I think paid jetbrains IDEs already do this on their own, as they embed datagrip, no? It checks the syntax, gives you autocomplete based on the databases you are connected to, it even supports string language injection, so you'll get SQL autocomplete and checking for strings containing SQL in your code. I'd love to understand what the advantages here are, other than the obvious one of being available for many editors as a language server.
- michaelcampbell 3y ago
  I'm not sure I'm a power user enough to notice a difference but I've had tremendous luck with jetbrains datagrip (standalone and embedded) when dealing with PG syntax. The highlight and formatting work a treat.
  - TkTech 3y ago
    Yes, the jetbrains already have all these features and more (such as reflecting pg functions, tables, columns, schemas, etc). You wouldn't really notice a difference using this, except your general autocompletes would get worse, and very complex sql might get more correct (I break datagrip's parser occasionally)

kiwicopple 3y ago

1. yes this is possible, although it depends on your IDE. Here is a relevant discussion for eclipse (which also links to the VSCode implementation): https://github.com/eclipse/che/issues/4609 https://github.com/eclipse/che/issues/4609. Note: i also didn't know how this worked, so I learned something today too. 2. Yes, absolutely. Feel free to reach out to me directly, or just start contributing directly if you want

SpaghettiCthulu 3y ago

> 1. Will I be able to use this in my IDE (say JetBrains or VSCode) alongside the programming language’s LSP? So that this project would only be in effect for the Pg SQL bits? I think that would depend on IDE support. For example, JetBrains IDEs have a feature for this.

kyrra 3y ago

1) looks like intelliJ paid versions support (or will support) LSPs soon. https://blog.jetbrains.com/platform/2023/07/lsp-for-plugin-developers/ https://blog.jetbrains.com/platform/2023/07/lsp-for-plugin-d... > Starting with the 2023.2 release cycle, the LSP API is publicly available as part of the IntelliJ Platform in the following IDEs: IntelliJ IDEA Ultimate, WebStorm, PhpStorm, PyCharm Professional, DataSpell, RubyMine, CLion, Aqua, DataGrip, GoLand, Rider

cube2222 3y ago

I think paid jetbrains IDEs already do this on their own, as they embed datagrip, no? It checks the syntax, gives you autocomplete based on the databases you are connected to, it even supports string language injection, so you'll get SQL autocomplete and checking for strings containing SQL in your code. I'd love to understand what the advantages here are, other than the obvious one of being available for many editors as a language server.

michaelcampbell 3y ago
I'm not sure I'm a power user enough to notice a difference but I've had tremendous luck with jetbrains datagrip (standalone and embedded) when dealing with PG syntax. The highlight and formatting work a treat.
- TkTech 3y ago
  Yes, the jetbrains already have all these features and more (such as reflecting pg functions, tables, columns, schemas, etc). You wouldn't really notice a difference using this, except your general autocompletes would get worse, and very complex sql might get more correct (I break datagrip's parser occasionally)