Philipp Salvisberg
@salvis.com
Focused on database-centric development. Chat is open.
https://www.salvis.com/blog/about
https://www.salvis.com/blog/about
I've updated my local APEX development environment to Oracle AI Database 26c. @hartenfeller.dev makes it easy! Thanks!
uc-local-apex-dev now supports Oracle 26ai, including a guided migration path if you're coming from 23ai. No data loss. hartenfeller.dev/blog/upgrade...
#orclAPEX #oracle #26ai
#orclAPEX #oracle #26ai
Upgrading uc-local-apex-dev from 23ai to 26ai without data loss
uc-local-apex-dev lets you run Oracle APEX and Database 26ai locally with minimal setup. Upgrade from 23ai without data loss.
hartenfeller.dev
January 9, 2026 at 7:48 AM
I've updated my local APEX development environment to Oracle AI Database 26c. @hartenfeller.dev makes it easy! Thanks!
Reposted by Philipp Salvisberg
I did a lot of thinking about the npm supply chain attacks over my break. I wrote up my thoughts, along with some proposed solutions, in my latest post:
https://humanwhocodes.co...
https://humanwhocodes.co...
January 6, 2026 at 3:32 PM
I did a lot of thinking about the npm supply chain attacks over my break. I wrote up my thoughts, along with some proposed solutions, in my latest post:
https://humanwhocodes.co...
https://humanwhocodes.co...
Reposted by Philipp Salvisberg
Timely for the 🎄 Christmas break, I've put together a more detailed 🛠️ "under the hood" post about extended VARCHARs (VARCHAR2 (32k)) and their often misunderstood 🔢 storage behavior.
Oracle Database 32k VARCHAR2 storage
Not too long ago, I responded to an email list regarding the storage of Oracle Database's extended VARCHAR2 data types, which allow you to store up to 32 KB of data. Because the LOB layer is used to store the data, it is often misunderstood that extended VARCHAR2s are nothing but tiny CLOBs and fall under the same semantic rules as…
www.geraldonit.com
January 6, 2026 at 2:00 PM
Timely for the 🎄 Christmas break, I've put together a more detailed 🛠️ "under the hood" post about extended VARCHARs (VARCHAR2 (32k)) and their often misunderstood 🔢 storage behavior.
I see the dbLinter rules as a large buffet. You choose what you like and what is healthy. But not too much at once. In any case, some rules should be enforced in every project. Do you agree with my top 14?
www.salvis.com/blog/2026/01...
www.salvis.com/blog/2026/01...
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 de...
www.salvis.com
January 2, 2026 at 9:35 PM
I see the dbLinter rules as a large buffet. You choose what you like and what is healthy. But not too much at once. In any case, some rules should be enforced in every project. Do you agree with my top 14?
www.salvis.com/blog/2026/01...
www.salvis.com/blog/2026/01...
Closed a long-running action item from August 2023.
The “Coming Soon” page on the Grisselbav website is gone. Replaced with real content.
Meet the Grisselbav team virtually at www.grisselbav.com.
Happy New Year!
The “Coming Soon” page on the Grisselbav website is gone. Replaced with real content.
Meet the Grisselbav team virtually at www.grisselbav.com.
Happy New Year!
Database Code Quality & Engineering Practices | Grisselbav
We help teams establish reliable and repeatable engineering practices around their databases, without unnecessary complexity.
www.grisselbav.com
December 31, 2025 at 2:18 PM
Closed a long-running action item from August 2023.
The “Coming Soon” page on the Grisselbav website is gone. Replaced with real content.
Meet the Grisselbav team virtually at www.grisselbav.com.
Happy New Year!
The “Coming Soon” page on the Grisselbav website is gone. Replaced with real content.
Meet the Grisselbav team virtually at www.grisselbav.com.
Happy New Year!
Would you like dbLinter to include a formatter? The more 'thumbs up' we get for the GitHub issue (github.com/Grisselbav/d...), the sooner it will happen.
New Rule: Always format database code consistently · Issue #45 · Grisselbav/dbLinter
The Problem ATM code style rules are not covered in the rule set of dbLinter. See also No Code Style. This is sad, since well-formatted code is easier to read and consistently formatted code is eas...
github.com
December 12, 2025 at 10:56 AM
Would you like dbLinter to include a formatter? The more 'thumbs up' we get for the GitHub issue (github.com/Grisselbav/d...), the sooner it will happen.
Do you write and deploy SQL or PL/SQL code for the Oracle Database? Do you care about software quality? If so, you should try dbLinter. It is available in the VS Code Marketplace and the Open VSX Registry.
December 12, 2025 at 8:15 AM
Do you write and deploy SQL or PL/SQL code for the Oracle Database? Do you care about software quality? If so, you should try dbLinter. It is available in the VS Code Marketplace and the Open VSX Registry.
Reposted by Philipp Salvisberg
December 4, 2025 at 10:05 AM
Reposted by Philipp Salvisberg
It's coming, Oracle AI Database 26ai for on premises commodity hardware announcement
blogs.oracle.com/database/ora...
blogs.oracle.com/database/ora...
blogs.oracle.com
December 3, 2025 at 4:30 PM
It's coming, Oracle AI Database 26ai for on premises commodity hardware announcement
blogs.oracle.com/database/ora...
blogs.oracle.com/database/ora...
Reposted by Philipp Salvisberg
APEX Connect 2026 - Call for Papers noch bis morgen!!!
Gebt Euren Abstract den letzten Schliff, und dann ab damit: apex.doag.org/de/home/
Wir freuen uns drauf! 😍
#APEXconn26 #orclAPEX #SQL #PLSQL #solutions #community
Gebt Euren Abstract den letzten Schliff, und dann ab damit: apex.doag.org/de/home/
Wir freuen uns drauf! 😍
#APEXconn26 #orclAPEX #SQL #PLSQL #solutions #community
December 1, 2025 at 11:42 AM
APEX Connect 2026 - Call for Papers noch bis morgen!!!
Gebt Euren Abstract den letzten Schliff, und dann ab damit: apex.doag.org/de/home/
Wir freuen uns drauf! 😍
#APEXconn26 #orclAPEX #SQL #PLSQL #solutions #community
Gebt Euren Abstract den letzten Schliff, und dann ab damit: apex.doag.org/de/home/
Wir freuen uns drauf! 😍
#APEXconn26 #orclAPEX #SQL #PLSQL #solutions #community
Too many commits can kill you! (And everyone else) by @ora600pl.bsky.social at DOAG2025. The summary is the first screen (no slides of course).
November 20, 2025 at 1:00 PM
Too many commits can kill you! (And everyone else) by @ora600pl.bsky.social at DOAG2025. The summary is the first screen (no slides of course).
If you love your data then you have to love this feature. Presented by @toonkoppelaars.bsky.social who joined Oracle to make that happen. #DOAG2025
November 19, 2025 at 8:00 AM
If you love your data then you have to love this feature. Presented by @toonkoppelaars.bsky.social who joined Oracle to make that happen. #DOAG2025
Reposted by Philipp Salvisberg
November 18, 2025 at 11:25 AM
Some Oracle ACE Program swag waited for me after returning from two amazing days at the ATP Finals in Turin. Useful stuff for #DOAG2025 next week! Thanks @oracleace.bsky.social!
November 11, 2025 at 5:49 PM
Some Oracle ACE Program swag waited for me after returning from two amazing days at the ATP Finals in Turin. Useful stuff for #DOAG2025 next week! Thanks @oracleace.bsky.social!
Reposted by Philipp Salvisberg
SYSDATE in Oracle AI Database is evaluated once per
Statement in #SQL
Call in PL/SQL
Wrap SYSDATE in a DETERMINISTIC function to trick the compiler into evaluating it once/statement
But beware: this can lead to unwanted behaviour
@salvis.com explores
Statement in #SQL
Call in PL/SQL
Wrap SYSDATE in a DETERMINISTIC function to trick the compiler into evaluating it once/statement
But beware: this can lead to unwanted behaviour
@salvis.com explores
Is SYSDATE Deterministic? #JoelKallmanDay - Philipp Salvisberg's Blog
Is SYSDATE deterministic in Oracle Database? Explore definitions, test cases, and pitfalls when using SYSDATE vs deterministic functions.
buff.ly
October 28, 2025 at 12:03 PM
SYSDATE in Oracle AI Database is evaluated once per
Statement in #SQL
Call in PL/SQL
Wrap SYSDATE in a DETERMINISTIC function to trick the compiler into evaluating it once/statement
But beware: this can lead to unwanted behaviour
@salvis.com explores
Statement in #SQL
Call in PL/SQL
Wrap SYSDATE in a DETERMINISTIC function to trick the compiler into evaluating it once/statement
But beware: this can lead to unwanted behaviour
@salvis.com explores
Reposted by Philipp Salvisberg
SQL trace on Autonomous database
connor-mcdonald.com/2025/10/27/s...
connor-mcdonald.com/2025/10/27/s...
SQL trace on Autonomous
I’ve blogged before about activating SQL trace on autonomous database, but here’s a little addenda that you might appreciate. Lets assume I’ve done the setup as described in the b…
connor-mcdonald.com
October 27, 2025 at 7:55 AM
SQL trace on Autonomous database
connor-mcdonald.com/2025/10/27/s...
connor-mcdonald.com/2025/10/27/s...
Reposted by Philipp Salvisberg
I felt like writing a blog post —a little write-up on why fixing failed #database deployments is challenging.
Spoiler: The part about undo-scripts might feel like a rant, probably because it is. 🙃
medium.com/@jasminfluri...
Spoiler: The part about undo-scripts might feel like a rant, probably because it is. 🙃
medium.com/@jasminfluri...
Database Rollbacks in CI/CD: Strategies and Pitfalls
Database rollbacks would be incredibly valuable and essential if we want quick fixes for failed deployments. But they are rarely feasible.
medium.com
October 22, 2025 at 7:44 PM
I felt like writing a blog post —a little write-up on why fixing failed #database deployments is challenging.
Spoiler: The part about undo-scripts might feel like a rant, probably because it is. 🙃
medium.com/@jasminfluri...
Spoiler: The part about undo-scripts might feel like a rant, probably because it is. 🙃
medium.com/@jasminfluri...
Tennis before the first session on day 3 of HrOUG with team „Awesome“ and „OMG“. It was great fun. Thanks! #HrOUG25 #HrOUG2025
October 17, 2025 at 7:17 AM
Tennis before the first session on day 3 of HrOUG with team „Awesome“ and „OMG“. It was great fun. Thanks! #HrOUG25 #HrOUG2025
This is how a latch contention looks in real life. The @ora600pl.bsky.social way at #HrOUG2025
October 16, 2025 at 2:08 PM
This is how a latch contention looks in real life. The @ora600pl.bsky.social way at #HrOUG2025
Lot if interest in deep diving into performance of views by @danischnider.bsky.social at #HrOUG2025
October 16, 2025 at 9:57 AM
Lot if interest in deep diving into performance of views by @danischnider.bsky.social at #HrOUG2025
Reposted by Philipp Salvisberg
For #JoelKallmanDay I am sharing a free plug-in for reactive Markdown preview. It auto refreshes, supports tables, alerts, etc., and comes with three themes. #orclAPEX
hartenfeller.dev/blog/apex-re...
hartenfeller.dev/blog/apex-re...
Oracle APEX Reactive Markdown Plug-in #JoelKallmanDay
Display rich Markdown in Oracle APEX that reacts to changes of referenced page items.
hartenfeller.dev
October 15, 2025 at 5:03 AM
For #JoelKallmanDay I am sharing a free plug-in for reactive Markdown preview. It auto refreshes, supports tables, alerts, etc., and comes with three themes. #orclAPEX
hartenfeller.dev/blog/apex-re...
hartenfeller.dev/blog/apex-re...
Is SYSDATE Deterministic? #JoelKallmanDay
No, SYSDATE is not deterministic. However, it behaves very similarly to a deterministic function within an Oracle Database SQL statement.
www.salvis.com/blog/2025/10...
No, SYSDATE is not deterministic. However, it behaves very similarly to a deterministic function within an Oracle Database SQL statement.
www.salvis.com/blog/2025/10...
Is SYSDATE Deterministic? #JoelKallmanDay
TL;DR No, SYSDATE is not deterministic. However, it behaves very similarly to a deterministic function within an Oracle Database SQL statement. Background On a customer site, we used faketime on the O...
www.salvis.com
October 15, 2025 at 1:59 AM
Is SYSDATE Deterministic? #JoelKallmanDay
No, SYSDATE is not deterministic. However, it behaves very similarly to a deterministic function within an Oracle Database SQL statement.
www.salvis.com/blog/2025/10...
No, SYSDATE is not deterministic. However, it behaves very similarly to a deterministic function within an Oracle Database SQL statement.
www.salvis.com/blog/2025/10...
Do you use MERGE statements in your PL/SQL code? Then I recommend not using Oracle SQL Developer for VSCode version 25.3.0 or SQLcl 25.3.0.
See forums.oracle.com/ords/apexds/...
See forums.oracle.com/ords/apexds/...
forums.oracle.com
October 10, 2025 at 3:32 PM
Do you use MERGE statements in your PL/SQL code? Then I recommend not using Oracle SQL Developer for VSCode version 25.3.0 or SQLcl 25.3.0.
See forums.oracle.com/ords/apexds/...
See forums.oracle.com/ords/apexds/...
„The successful 5% of AI agents? They all have one thing in common: human-in-the-loop design.“
Great read: What Makes 5% of AI Agents Actually Work in Production?
www.motivenotes.ai/p/what-makes...
www.motivenotes.ai/p/what-makes...
October 9, 2025 at 7:30 PM
„The successful 5% of AI agents? They all have one thing in common: human-in-the-loop design.“