Philipp Salvisberg
@salvis.com
Focused on database-centric development. Chat is open.
https://www.salvis.com/blog/about
https://www.salvis.com/blog/about
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...
If you are using version 0.15.0 of the dbLinter VS Code extension, please update to version 0.15.1. Thx!
This update fixes a problem where the wrong configuration name was being used for anonymous users. Other users are not affected.
This update fixes a problem where the wrong configuration name was being used for anonymous users. Other users are not affected.
September 16, 2025 at 11:40 AM
If you are using version 0.15.0 of the dbLinter VS Code extension, please update to version 0.15.1. Thx!
This update fixes a problem where the wrong configuration name was being used for anonymous users. Other users are not affected.
This update fixes a problem where the wrong configuration name was being used for anonymous users. Other users are not affected.
Reposted by Philipp Salvisberg
Transactional Outbox: Simplified with Oracle Database
Event streaming is extremely popular in modern application architectures, providing high-throughput, real-time data flow in microservices architectures. However, ensuring data consistency in distributed systems is challenging — Traditional…
Event streaming is extremely popular in modern application architectures, providing high-throughput, real-time data flow in microservices architectures. However, ensuring data consistency in distributed systems is challenging — Traditional…
Transactional Outbox: Simplified with Oracle Database
Event streaming is extremely popular in modern application architectures, providing high-throughput, real-time data flow in microservices architectures. However, ensuring data consistency in distributed systems is challenging — Traditional two-phase commit (2PC) implementations can be costly and slow, making them impractical for high-throughput environments. In this article, we’ll solve data consistency challenges in event streaming systems using Oracle Database Transactional Event Queues…
andersswanson.dev
September 12, 2025 at 4:38 PM
Transactional Outbox: Simplified with Oracle Database
Event streaming is extremely popular in modern application architectures, providing high-throughput, real-time data flow in microservices architectures. However, ensuring data consistency in distributed systems is challenging — Traditional…
Event streaming is extremely popular in modern application architectures, providing high-throughput, real-time data flow in microservices architectures. However, ensuring data consistency in distributed systems is challenging — Traditional…
Reposted by Philipp Salvisberg
Learn how to run a containerised Oracle Database 23ai natively on MacOS with Apple Containers #oracle #database #23ai #containers #macOS
How to Run Oracle Database 23ai natively on MacOS with Apple Containers
Background I have written many blog posts detailing how to run containerised Oracle database workloads using Docker, Podman and Kubernetes on a Mac. But we now have another new exciting, simpler and potentially faster option. At WWDC 2025, Apple announced its containerisation framework platform. Apple’s Containerisation framework runs each Linux container inside its own lightweight virtual machine (VM), providing hardware-level isolation instead of relying on traditional namespace-based container runtimes, such as…
ronekins.com
September 12, 2025 at 4:55 PM
Learn how to run a containerised Oracle Database 23ai natively on MacOS with Apple Containers #oracle #database #23ai #containers #macOS
Reposted by Philipp Salvisberg
I guess it will be about linters and coding standards :) @salvis.com at #POUG2025 @sym42.bsky.social
September 5, 2025 at 12:49 PM
I guess it will be about linters and coding standards :) @salvis.com at #POUG2025 @sym42.bsky.social
Reposted by Philipp Salvisberg
Get faster PL/SQL in #SQL with
alter session set sql_transpiler = on
=> database will convert eligible functions to SQL
Read my latest post for details on
What can be transpiled
Transpiler vs scalar macros
Functional differences
Impact of function-based indexes
blogs.oracle.com/sql/post/fas...
alter session set sql_transpiler = on
=> database will convert eligible functions to SQL
Read my latest post for details on
What can be transpiled
Transpiler vs scalar macros
Functional differences
Impact of function-based indexes
blogs.oracle.com/sql/post/fas...
blogs.oracle.com
August 27, 2025 at 2:31 PM
Get faster PL/SQL in #SQL with
alter session set sql_transpiler = on
=> database will convert eligible functions to SQL
Read my latest post for details on
What can be transpiled
Transpiler vs scalar macros
Functional differences
Impact of function-based indexes
blogs.oracle.com/sql/post/fas...
alter session set sql_transpiler = on
=> database will convert eligible functions to SQL
Read my latest post for details on
What can be transpiled
Transpiler vs scalar macros
Functional differences
Impact of function-based indexes
blogs.oracle.com/sql/post/fas...
Reposted by Philipp Salvisberg
New video: leverage AI coding assistants to generate unit tests for #oracle #PLSQL.
- how to structure your project
- optimize AI context with a copilot-instructions.md
- let the AI agent compile and test with SQL Dev #MCP server
youtu.be/O9fhl1Gr0UU #orclAPEX
- how to structure your project
- optimize AI context with a copilot-instructions.md
- let the AI agent compile and test with SQL Dev #MCP server
youtu.be/O9fhl1Gr0UU #orclAPEX
Generate valuable PL/SQL unit tests with AI
YouTube video by United Codes
youtu.be
August 20, 2025 at 10:49 AM
New video: leverage AI coding assistants to generate unit tests for #oracle #PLSQL.
- how to structure your project
- optimize AI context with a copilot-instructions.md
- let the AI agent compile and test with SQL Dev #MCP server
youtu.be/O9fhl1Gr0UU #orclAPEX
- how to structure your project
- optimize AI context with a copilot-instructions.md
- let the AI agent compile and test with SQL Dev #MCP server
youtu.be/O9fhl1Gr0UU #orclAPEX
In the next version of dbLinter, you will be able to report issues with related locations. Here's a sneak peek in VS Code and SonarQube (via generic formatted issue reports).
Fewer reported issues. Cleaner editor and issue repositories. 😎
Fewer reported issues. Cleaner editor and issue repositories. 😎
August 19, 2025 at 2:07 PM
In the next version of dbLinter, you will be able to report issues with related locations. Here's a sneak peek in VS Code and SonarQube (via generic formatted issue reports).
Fewer reported issues. Cleaner editor and issue repositories. 😎
Fewer reported issues. Cleaner editor and issue repositories. 😎
Reposted by Philipp Salvisberg
A new PL/SQL unwrapper for 9i and lower - www.petefinnigan.com/weblog/archi... - #oracleace #sym_42 #oracle #plsql #unwrap #reverse #engineering #security
August 7, 2025 at 11:31 AM
A new PL/SQL unwrapper for 9i and lower - www.petefinnigan.com/weblog/archi... - #oracleace #sym_42 #oracle #plsql #unwrap #reverse #engineering #security