2026-08-23
blank
2026-08-23
Categories

The Checkbox That Disables TLS

Introduction The dbLinter clients include a new setting named Allow Insecure TLS. It is disabled by default. As a result, all REST API calls verify the TLS certificate and hostname. The setting allows dbLinter to work in organisations that inspect TLS traffic using tools such as Zscaler. In larger organisations, arranging an […]
Do you like it?
0 Read more
2026-06-29
blank
2026-06-29
Categories

Detecting Security Vulnerabilities With the APEXlang Parser

Introduction A parser for the APEXlang grammar enables the development of tools beyond the scope of the APEXlang compiler included in SQLcl, SQL Developer for VS Code, and ORDS. These tools can perform static code analysis, convert code, generate documentation, and visualise different aspects of an APEX application. A linter, for example, […]
Do you like it?
0 Read more
2026-01-02
blank
2026-01-02
Categories

Fighting Bad PL/SQL & SQL with VS Code

The success of a project or product depends largely on the quality of the code. But how can I improve security, maintainability or performance? More importantly, how can I prevent code with quality defects from entering production? In addition to testing, code analysis plays a central role. These days, code can be […]
Do you like it?
Read more
2025-07-12
Outer Joining With ANSI SQL-89 and SQL-92
2025-07-12
Categories

Outer Joining With ANSI SQL-89 and SQL-92

Introduction I recently implemented a quick fix for the rule G-3130 to transform queries to ANSI SQL-92 syntax. One of the challenges was to handle Oracle’s outer-join syntax (+). In ANSI SQL-89, join and filter criteria are part of the WHERE clause. It’s not easy to distinguish them. In this blog post, […]
Do you like it?
Read more
2025-03-18
dbLinter logo
2025-03-18
Categories

dbLinter Rules Repository

Introduction Today I proudly announce that the Joint Venture between United Codes and Grisselbav released the initial version of the dbLinter Rules Repository website. This is the first publicly available component of the dbLinter tool suite. What is dbLinter? dbLinter is a suite for checking and improving the quality of database applications. […]
Do you like it?
Read more
2024-07-29
IslandSQL Final Episode 10: Parsing PL/pgSQL
2024-07-29
Categories

IslandSQL Final Episode 10: Parsing PL/pgSQL

Introduction IslandSQL is a parser for SQL files targeting OracleDB or PostgreSQL. The parser is available on Maven Central and can process SQL*Plus, SQLcl or psql statements besides SQL statements. However, the focus is on statements with static DML statements and code in PL/SQL and PL/pgSQL. For static code analysis, for example. […]
Do you like it?
Read more
2024-06-27
IslandSQL Episode 9: GraphQL, JSON and Flexible Schemas With Duality Views
2024-06-27
Categories

IslandSQL Episode 9: GraphQL, JSON and Flexible Schemas With Duality Views

Introduction In the last episode, we looked at some new features in Oracle Database 23.4. The IslandSQL grammar now covers all statements that can contain static DML statements and code in PL/SQL and PL/pgSQL. While implementing the ANTLR grammar for the create JSON relational duality view statement I stumbled over GraphQL in […]
Do you like it?
Read more
2024-06-15
IslandSQL Episode 8: What's New in Oracle Database 23.4?
2024-06-15
Categories

IslandSQL Episode 8: What’s New in Oracle Database 23.4?

Introduction In the last episode, we looked at some features in PostgreSQL which I miss in the Oracle Database. The IslandSQL grammar now covers PL/SQL and the related DDL statements. The implementation was more complex than expected, mainly because of the incompatibilities between PostgreSQL and the Oracle Database. I will probably deal […]
Do you like it?
Read more
2024-03-23
IslandSQL Episode 7: DML Statements in PostgreSQL 16 and What I Miss in Oracle Database 23c
2024-03-23
Categories

IslandSQL Episode 7: DML Statements in PostgreSQL 16 and What I Miss in Oracle Database 23c

Introduction In the last episode, we covered DML statements in SQL*Plus/SQLcl scripts for the Oracle Database 23c. The IslandSQL grammar can now also handle PostgreSQL 16 DML statements in psql scripts. In this blog post, we will look at some features in PostgreSQL 16 which I miss in the Oracle Database 23c. […]
Do you like it?
Read more
2024-01-30
IslandSQL Episode 6 - DML Statements in Oracle Database 23c
2024-01-30
Categories

IslandSQL Episode 6: DML Statements in Oracle Database 23c

Introduction The IslandSQL grammar now covers all DML statements. This means call, delete, explain plan, insert, lock table, merge, select and update. In this episode, we will focus on new features in the Oracle Database 23c that can be used in insert, update, delete and merge statements. For the select statement see […]
Do you like it?
Read more