Philipp Salvisberg
@salvis.com
Focused on database-centric development. Chat is open.
https://www.salvis.com/blog/about
https://www.salvis.com/blog/about
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.“
Reposted by Philipp Salvisberg
Previously on @thatjeffsmith... SQL Developer extension for VS Code 25.3: Charts & Diagrams
SQL Developer extension for VS Code 25.3: Charts & Diagrams
Previously on @thatjeffsmith... SQL Developer extension for VS Code 25.3: Charts & Diagrams
www.thatjeffsmith.com
October 6, 2025 at 5:44 PM
Previously on @thatjeffsmith... SQL Developer extension for VS Code 25.3: Charts & Diagrams
I've just finished writing my blog post. And you?
Joel Kallman Day 2025 : Announcement
oracle-base.com/blog/2025/09...
#JoelKallmanDay
@oracleace @OracleAPEX #orclapex @OracleDatabase
oracle-base.com/blog/2025/09...
#JoelKallmanDay
@oracleace @OracleAPEX #orclapex @OracleDatabase
September 29, 2025 at 11:35 AM
I've just finished writing my blog post. And you?
Subtly downgrade a band:
Beagles
Beagles
Subtly downgrade a band:
Veggie Loaf
Veggie Loaf
Subtly downgrade a band:
Tin Zeppelin
Tin Zeppelin
September 28, 2025 at 5:45 AM
Subtly downgrade a band:
Beagles
Beagles
Reposted by Philipp Salvisberg
New blog post, my longest one ever. A full guide on how to use AI as a PL/SQL developer.
- No 23ai or Python required
- Advanced techniques like tools, structured output, reasoning, and file analysis
- Usage demos
hartenfeller.dev/blog/real-ai...
#oracle #ai #orclAPEX
- No 23ai or Python required
- Advanced techniques like tools, structured output, reasoning, and file analysis
- Usage demos
hartenfeller.dev/blog/real-ai...
#oracle #ai #orclAPEX
Build Real AI Solutions with Oracle PL/SQL (No 23ai Required)
Learn how data engineers can leverage AI for Oracle automation using PL/SQL. Discover structured output, file analysis, reasoning, and tool calling with the open-source UC AI SDK.
hartenfeller.dev
September 17, 2025 at 11:29 AM
New blog post, my longest one ever. A full guide on how to use AI as a PL/SQL developer.
- No 23ai or Python required
- Advanced techniques like tools, structured output, reasoning, and file analysis
- Usage demos
hartenfeller.dev/blog/real-ai...
#oracle #ai #orclAPEX
- No 23ai or Python required
- Advanced techniques like tools, structured output, reasoning, and file analysis
- Usage demos
hartenfeller.dev/blog/real-ai...
#oracle #ai #orclAPEX
Reposted by Philipp Salvisberg
GraalVM 25 is here, with lots of updates for native compilation, GraalPy, GraalJS, and WebAssembly.
Faster and better than ever!🐰🚀
Download: www.graalvm.org/downloads/
Release notes: www.graalvm.org/release-note...
Faster and better than ever!🐰🚀
Download: www.graalvm.org/downloads/
Release notes: www.graalvm.org/release-note...
September 16, 2025 at 3:38 PM
GraalVM 25 is here, with lots of updates for native compilation, GraalPy, GraalJS, and WebAssembly.
Faster and better than ever!🐰🚀
Download: www.graalvm.org/downloads/
Release notes: www.graalvm.org/release-note...
Faster and better than ever!🐰🚀
Download: www.graalvm.org/downloads/
Release notes: www.graalvm.org/release-note...