

Philipp Salvisberg
Focused on database-centric development.
Winterthur, Switzerland
Actions
Philipp Salvisberg is the owner of Grisselbav GmbH and an Oracle ACE Pro. He has been focusing on Oracle database-based solutions since 1988. At that time with Oracle Database version 5. Since then, he has been helping customers design, build and optimize their database-centric solutions, teaching application development topics or speaking at conferences. Software quality and automation are of great importance in this context.
Philipp has a soft spot for doing as much as possible in a single SQL statement and is interested in pretty much everything to use the database as efficiently as possible. He likes to design model-driven software solutions using domain-specific languages while getting the most out of the underlying technologies.
Links
Area of Expertise
Topics
Fighting Bad PL/SQL & SQL with VS Code
Improving code is like losing weight. First, you need to know what is good and what is bad. You need metrics and appropriate measurement tools to express your goals and achievements. Then you get results as a series of small steps in the right direction.
In PL/SQL and SQL, code complexity can be expressed in lines of code, number of statements, as McCabe's cyclomatic complexity, Halstead's volume, or the maintainability index. Reducing complexity is one way of improving code quality.
However, in this talk I will focus on coding guidelines for PL/SQL and SQL and discuss my favourite guidelines. These guidelines are actually rules and must be followed. Therefore, there is (almost) no room for different interpretations. So, if we violate any of these rules, it means our code is broken. I will show you how you can use the dbLinter extension for Visual Studio Code to find these bugs in your code and fix them manually or even automatically.
By the end of this session, you'll know how to check your code in Visual Studio Code and efficiently eliminate bad code.
HrOUG 2024 Sessionize Event

Philipp Salvisberg
Focused on database-centric development.
Winterthur, Switzerland
Links
Actions
Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.
Jump to top