dbLinter for VS Code

• New: Support for Oracle AI Database 26ai 23.26.1 incl. CREATE ASSERTION and CREATE PROPERTY GRAPH.
• New: Support for PostgreSQL 18.1.
• New: Requires validators compatible with IslandSQL 0.21.0.
• Download dblinter-1.3.0.vsix
• Install via Visual Studio Marketplace
• Install via Open VSX Registry

dbLinter CLI

• New: Support for Oracle AI Database 26ai 23.26.1 incl. CREATE ASSERTION and CREATE PROPERTY GRAPH.
• New: Support for PostgreSQL 18.1.
• New: Requires validators compatible with IslandSQL 0.21.0.
• Download dblinter-1.3.0.zip

dbLinter SonarQube Plugin

• New: Support for Oracle AI Database 26ai 23.26.1 incl. CREATE ASSERTION and CREATE PROPERTY GRAPH.
• New: Support for PostgreSQL 18.1.
• New: Requires validators compatible with IslandSQL 0.21.0.
• Download dblinter-sonarqube-1.3.0.jar

dbLinter for VS Code

• New: Minimum client version enforcement.
• Changed: Unified versions of all client artefacts.
• Fixed: Scope of @dblinter ignore marker in SQL statement is wrongly extended to EOF.
• Download dblinter-1.2.0.vsix
• Install via Visual Studio Marketplace
• Install via Open VSX Registry

dbLinter CLI

• New: Minimum client version enforcement.
• Changed: Unified versions of all client artefacts.
• Changed: Only show the error message The CLI feature is not enabled for the current access token. if the open-session call provides no error message.
• Fixed: Scope of @dblinter ignore marker in SQL statement is wrongly extended to EOF.
• Download dblinter-1.2.0.zip

dbLinter SonarQube Plugin

• Initial version of SonarQube Plugin for self-managed editions.
  • SonarQube Community Build 9.9 and newer
  • SonarQube Developer Edition 9.9 and newer
  • SonarQube Enterprise Edition 9.9 and newer
  • SonarQube Data Center Edition 9.9 and newer
• Features:
  • Server-Side (when installing/updating the plugin and using the SonarQube Web UI)
    • Registers all dbLinter rules in the default profile.
    • General and project-specific settings (e.g. dbLinter tenant and configuration to use).
  • Client-Side (when running sonar-scanner)
    • Apply configuration in the dbLinter repository for each analysis.
    • Issue registration based on violations of enabled rules and their parameters.
    • Metrics as primary plugin:
      • Lines of Code.
      • Number of Comment Lines.
      • Number of Statements.
      • Number of Functions.
      • Cyclomatic complexity.
      • Code highlighting support through registration of keywords, symbols, strings, numbers, preprocessor directives and comments.
      • Copy & paste detection support through registration of relevant (visible) tokens.
      • Test coverage support through registration of executable lines
  • Runs as a secondary plugin along either the SonarQube PL/SQL plugin or the ZPA plugin.
• Download dblinter-sonarqube-1.2.0.jar

• New: Analyse code blocks in Markdown (.md, .markdown) and APEXLang (.apx, .apex) files.
• New: Use the patch version along with the major and minor versions to determine the applicability of SQL-based tests.
• New: Support for environment variables prefixed with DBLINTER_ in SCREAMING_SNAKE_CASE for CLI options in camelCase.
• Fixed: Missing help text for test command.

• Fixed: 0-based lines used in reports for Checkstyle, GitHub and GitLab.

• Changed: Show rules in dblinter.app, simplifying configuration changes.
• Changed: Default Repo URL to https://api.dblinter.app/ (production).
• Changed: Removed obsolete preview-related settings.

• New: Support for Oracle AI Database 26ai (23.26.0).
• Fixed: end keyword in package body is identified as an item of type label when the package body does not end on a slash.

• New: Support for PostgreSQL 18.0.
• New: Requires validators compatible with version 0.19.0 (IslandSQL 0.19.0).
• Fixed: Syntax error when using nested selection directives.

• New: Requires validators compatible with version 0.18.2 (IslandSQL 0.18.2).

• New: Applicability of SQL-based tests is fully evaluated on the client side (breaking change).
• New: Rules are disabled if they are not compatible with the configured database connection.
• New: Reporting a G-1930 issue when the parsing time threshold is exceeded.
• New: Reporting a G-1940 issue when the checking time threshold is exceeded.
• Changed: No centrally managed connection required to override SQL dialect.
• Changed: The check command consistently displays the number of files, regardless of the degree of parallelism.
• Changed: The test command consistently displays the number of tests, regardless of the degree of parallelism.
• Changed: Suppress empty sections in the vscode report of the check command.
• Changed: Suppress empty sections in the vscode report of the test command.

• New: test command to produce JUnit XML Report.
• New: Additional output formats for the check command:
  • SARIF Log
  • Checkstyle Audit Report
  • GitHub Actions Workflow Command Annotations
  • GitLab Code Quality Report