PL/SQL analysis in IntelliJ

Hi,

I am keen to understand whether there are any plans to add support for PL/SQL analysis within SonarLint for IntelliJ.

My team are considering moving to IntelliJ as a single IDE for Java / JavaScript / PL/SQL development and already use SonarQube within other areas of our enterprise. As IntelliJ have been adding more PL/SQL related capabilities (PL/SQL debugging on the database, support for the utPL/SQL v3 unit test framework, etc.) it is becoming a more attractive IDE for PL/SQL development over other database specific IDEs.

As part of moving to IntelliJ, it would obviously be beneficial to be able to analyse the PL/SQL code earlier in the development cycle and to be able to perform static code analysis across all the code for a particular code delivery within the IDE.

Thanks,

Mark

Hi,

This is not in our roadmap currently, but we are constantly updating it based on various criteria, including user inputs. Thanks to this thread, we will be able to collect number of votes, and adjust. Still, I don’t think you should expect any move on this topic before next year.

1 Like

This feature would be great

1 Like

+1
@Julien_HENRY: Is there any movement on this topic?

1 Like

Hi @nils1k and welcome to the SonarSource community!
We do not have major news to share for time being, our priorities are in constant evolution and we may consider add PL/SQL to SonarLint for IntelliJ if we see a strong demand for it. And in order to take your need into consideration correctly, could you give us some more information about how such addition to our pluging will benefit your projects? For example, do you code both in the Java and PL/SQL using IntelliJ? are you using IntelliJ Ultimate as your primary IDE for PL/SQL development? and are you using SonarQube or SonarCloud already to scan your PL/SQL code?

Hi Marco, and thank you.
In our case, we have quite a few repos where we have a mix of both Java code and flyway migration scripts in the shape of PL/SQL code. Which IDE that’s being used for developing the migration scripts varies, but the majority uses either IntelliJ or Oracle SQL Developer. We’re already using SonarQube for scanning the the codebase, i.e. both for the Java code and the PL/SQL code. Hence, it would be very useful for us to have support for PL/SQL analysis in Sonarlint - either for IntelliJ or SQL Developer, or both.

1 Like