Philipp Salvisberg
@salvis.com
📤 514
📥 156
📝 151
Focused on database-centric development. Chat is open.
https://www.salvis.com/blog/about
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).
5 days ago
0
2
0
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
6 days ago
0
17
3
reposted by
Philipp Salvisberg
Connor McDonald on Database and SQL
7 days ago
Couple here
connor-mcdonald.com/2016/03/23/t...
asktom.oracle.com/Misc/how-to-...
0
3
1
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
!
14 days ago
1
11
2
reposted by
Philipp Salvisberg
SQLDaily
28 days ago
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
loading . . .
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.
https://buff.ly/5lNWz7D
0
3
1
reposted by
Philipp Salvisberg
Connor McDonald on Database and SQL
29 days ago
SQL trace on Autonomous database
connor-mcdonald.com/2025/10/27/s...
loading . . .
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…
https://connor-mcdonald.com/2025/10/27/sql-trace-on-autonomous/
0
7
3
reposted by
Philipp Salvisberg
Jasmin Fluri
about 1 month ago
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...
loading . . .
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.
https://medium.com/@jasminfluri/database-rollbacks-in-ci-cd-strategies-and-pitfalls-f0ffd4d4741a
1
11
2
Tennis before the first session on day 3 of HrOUG with team „Awesome“ and „OMG“. It was great fun. Thanks!
#HrOUG25
#HrOUG2025
about 1 month ago
0
5
2
This is how a latch contention looks in real life. The
@ora600pl.bsky.social
way at
#HrOUG2025
about 1 month ago
0
9
3
Lot if interest in deep diving into performance of views by
@danischnider.bsky.social
at
#HrOUG2025
about 1 month ago
0
5
2
Having fun at the tennis court
#hroug25
about 1 month ago
1
4
1
reposted by
Philipp Salvisberg
Philipp Hartenfeller
about 1 month ago
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...
loading . . .
Oracle APEX Reactive Markdown Plug-in #JoelKallmanDay
Display rich Markdown in Oracle APEX that reacts to changes of referenced page items.
https://hartenfeller.dev/blog/apex-reactive-markdown-plugin
1
14
6
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...
loading . . .
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...
https://www.salvis.com/blog/2025/10/15/is-sysdate-deterministic-joelkallmanday
about 1 month ago
0
9
5
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/...
loading . . .
https://forums.oracle.com/ords/apexds/post/bug-cannot-install-stored-object-containing-a-merge-stateme-9418
about 2 months ago
0
1
0
„The successful 5% of AI agents? They all have one thing in common: human-in-the-loop design.“
add a skeleton here at some point
about 2 months ago
0
1
0
reposted by
Philipp Salvisberg
Jeff Smith
about 2 months ago
Previously on @thatjeffsmith... SQL Developer extension for VS Code 25.3: Charts & Diagrams
loading . . .
SQL Developer extension for VS Code 25.3: Charts & Diagrams
Previously on @thatjeffsmith... SQL Developer extension for VS Code 25.3: Charts & Diagrams
https://www.thatjeffsmith.com/archive/2025/10/sql-developer-extension-for-vs-code-25-3-charts-diagrams/?utm_source=bluesky&utm_medium=social&utm_campaign=ReviveOldPost
0
2
1
I've just finished writing my blog post. And you?
add a skeleton here at some point
about 2 months ago
0
4
0
Subtly downgrade a band: Beagles
add a skeleton here at some point
about 2 months ago
0
2
0
reposted by
Philipp Salvisberg
Philipp Hartenfeller
2 months ago
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
loading . . .
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.
https://hartenfeller.dev/blog/real-ai-solutions-oracle-plsql
0
12
3
reposted by
Philipp Salvisberg
GraalVM
2 months ago
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...
3
55
31
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.
2 months ago
0
1
1
reposted by
Philipp Salvisberg
Anders Swanson
2 months ago
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…
loading . . .
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…
https://andersswanson.dev/2025/09/12/transactional-outbox-simplified-with-oracle-database/
0
6
2
reposted by
Philipp Salvisberg
Ron Ekins
2 months ago
Learn how to run a containerised Oracle Database 23ai natively on MacOS with Apple Containers
#oracle
#database
#23ai
#containers
#macOS
loading . . .
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…
https://ronekins.com/2025/09/12/how-to-run-oracle-database-23ai-natively-on-macos-with-apple-containers/
0
5
2
reposted by
Philipp Salvisberg
Priit Piipuu
3 months ago
I guess it will be about linters and coding standards :)
@salvis.com
at
#POUG2025
@sym42.bsky.social
1
9
1
reposted by
Philipp Salvisberg
Chris Saxon
3 months ago
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...
loading . . .
https://blogs.oracle.com/sql/post/faster-plsql-in-sql-with-the-automatic-sql-transpiler
0
12
7
reposted by
Philipp Salvisberg
Philipp Hartenfeller
3 months ago
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
loading . . .
Generate valuable PL/SQL unit tests with AI
YouTube video by United Codes
https://youtu.be/O9fhl1Gr0UU
1
9
3
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. 😎
3 months ago
0
0
0
reposted by
Philipp Salvisberg
Pete Finnigan
4 months ago
A new PL/SQL unwrapper for 9i and lower -
www.petefinnigan.com/weblog/archi...
-
#oracleace
#sym_42
#oracle
#plsql
#unwrap
#reverse
#engineering
#security
0
7
1
reposted by
Philipp Salvisberg
Dani Schnider
4 months ago
With Oracle database 23.9, we can finally use GROUP BY ALL in our SQL queries, as you can read in my latest blog post:
danischnider.wordpress.com/2025/08/05/o...
loading . . .
Oracle 23.9 supports GROUP BY ALL
Aggregating data is now easier than ever before with the newest version of Oracle database 23ai. Oracle version 23.9 supports the GROUP BY ALL syntax.
https://danischnider.wordpress.com/2025/08/05/oracle-23-9-supports-group-by-all/
0
7
3
reposted by
Philipp Salvisberg
Gerald Venzl
4 months ago
Just updated my gvenzl/oracle-free images to
#Oracle
#Database
23.9
#Free
loading . . .
Oracle Database 23.9 Free multi-platform images now available on gvenzl/oracle-free
Oracle Database 23.9 Free multi-platform images are now available on container registries docker.io/gvenzl/oracle-free and ghcr.io/gvenzl/oracle-free. With this release, 23.7 images have now gone into Unsupported. See the support matrix for more information.
https://www.geraldonit.com/oracle-database-23-9-free-multi-platform-images-now-available-on-gvenzl-oracle-free/?utm_source=bluesky&utm_medium=jetpack_social
2
18
5
reposted by
Philipp Salvisberg
Philipp Hartenfeller
4 months ago
I love having a local
#orclAPEX
with
#23ai
installation as it makes me more efficient and also taught me so much:
hartenfeller.dev/blog/you-sho...
loading . . .
You should try having a local database with APEX
A local Oracle APEX environment eliminates friction through safe experimentation, administrative access, and instant performance.
https://hartenfeller.dev/blog/you-should-have-local-apex
0
7
2
reposted by
Philipp Salvisberg
Polish Oracle User Group
4 months ago
Brace yourselves - Sabine Heimsath is bringing the best of the worst to
#POUG2025
. Expect laughs. Expect facepalms. Expect to whisper "I’ve seen worse"… or "I wrote that." 😅 9 tickets available AND THEN WE'RE DONE:
poug2025.konfeo.com
0
2
1
Ah yes, INTEGER is a subtype of NUMBER(38, 0) in PL/SQL. Defining a precision and scale for an INTEGER is an example of 'just because you can, doesn't mean you should'. 🤓
4 months ago
0
2
0
reposted by
Philipp Salvisberg
Polish Oracle User Group
4 months ago
Messy PL/SQL? Sloppy SQL? @Philipp Salvisberg shows you how to clean it up with style — and VS Code. 🔥 Code smarter, not harder.
#POUG2025
poug.org/en/edycja/po...
0
3
3
Some
#dbLinter
rules are easier to implement than others. You can try out dbLinter for VS Code, Cursor, Windsurf or Theia IDE. Watch the video by
@hartenfeller.dev
www.youtube.com/watch?v=V-eP...
to get started. New checks are constantly being added—no client update required.
4 months ago
0
3
1
reposted by
Philipp Salvisberg
Brendan Tierney
4 months ago
Can
#AI
really code? Study maps the roadblocks to autonomous software engineering
news.mit.edu/2025/can-ai-...
loading . . .
Can AI really code? Study maps the roadblocks to autonomous software engineering
Researchers led by computer scientists at MIT have mapped the challenges of AI in software development, and outlined a research agenda to move the field forward.
https://news.mit.edu/2025/can-ai-really-code-study-maps-roadblocks-to-autonomous-software-engineering-0716
0
2
2
reposted by
Philipp Salvisberg
Philipp Hartenfeller
4 months ago
New blog post: ✅ What is the
#SQLcl
#MCP
server ✅ How does it work under the hood ✅ Security concerns ✅ Tools vs. MCP
hartenfeller.dev/blog/demysti...
#oracle
#orclAPEX
loading . . .
Demystifying the SQLcl MCP Server
A deep dive into Oracle's SQLcl MCP Server: understanding its capabilities, testing its tools, and examining the security implications for database access through AI.
https://hartenfeller.dev/blog/demystifying-sqlcl-mcp-server
1
11
5
reposted by
Philipp Salvisberg
Chris Saxon
4 months ago
Oracle Database 23.9 is out, once again, this RU has several
#SQL
features you're sure to enjoy Here's a summary of a few
3
14
9
Wow! My Oracle Database 23ai PDB in the Ashburn OCI has been updated to version 23.9. I'm now waiting for relevant documentation to be released for this version, such as this:
docs.oracle.com/en/database/...
.
4 months ago
2
5
0
Do your outer join queries produce more rows than expected? In this blog post, I show a strange result when using filter predicates in the join clause. dbLinter can help you sort your join and filter criteria and spot issues like this.
www.salvis.com/blog/2025/07...
loading . . .
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...
https://www.salvis.com/blog/2025/07/12/outer-joining-with-ansi-sql-89-and-sql-92/
5 months ago
0
8
8
reposted by
Philipp Salvisberg
Jeff Smith
5 months ago
New post: SQL Notebooks in our SQLDev extension for VS Code.
www.thatjeffsmith.com/archive/2025...
loading . . .
SQL Notebooks in Oracle SQL Developer for VS Code
Introducing SQL Notebooks, a new way to work with Oracle Database SQL and PL/SQL scripts in the SQL Developer Extension for VS Code.
https://www.thatjeffsmith.com/archive/2025/07/sql-notebooks-in-oracle-sql-developer-for-vs-code/
1
11
5
Do you have SQL or PL/SQL code? Check your code quality against more than 150 rules. Configure your rule set. Apply quick fixes for chosen issues or even all fixable issues in a file.
@hartenfeller.dev
shows how to get started with dbLinter.
add a skeleton here at some point
5 months ago
0
5
2
reposted by
Philipp Salvisberg
Polish Oracle User Group
5 months ago
Whether you're curious, skeptical, or already experimenting, you don’t want to miss this one. 👇 At
#POUG2025
,
@gianniceresa.bsky.social
explores how Python + AI agents can do more than just generate answers: they can act, decide, and solve real tasks autonomously.
poug.org/edycja/poug-...
0
3
2
Want to use Oracle SQL Developer in VSCodium, Cursor, Windsurf or Theia? In this blog post, I explain how to do it.
www.salvis.com/blog/2025/07...
loading . . .
Installing SQL Developer in IDEs Implementing the VS Code Extension API
Introduction The Oracle SQL Developer team is working on bringing the essential functionality built over the last 20 years in the classic SQL Developer IDE—a JDeveloper extension running as a standalo...
https://www.salvis.com/blog/2025/07/05/installing-sql-developer-in-ides-implementing-the-vs-code-extension-api/
5 months ago
0
6
4
reposted by
Philipp Salvisberg
Connor McDonald on Database and SQL
6 months ago
New video! In the age of internet applications, is PL/SQL no longer required?
youtu.be/6T3U3D23Z60
loading . . .
Is PL/SQL dying?
YouTube video by SQL and Database explained!
https://youtu.be/6T3U3D23Z60
0
9
7
reposted by
Philipp Salvisberg
Dan McGhan
6 months ago
Relying on Liquibase rollback? That might be your riskiest move. 💥 Find out why it fails—and how to do it right with Oracle Flashback, Data Pump, and EBR. 👉
danmcghan.hashnode.dev/the-problems...
#orclAPEX
#OracleDB
#sqlcl
#DevOps
loading . . .
https://danmcghan.hashnode.dev/the-problems-with-liquibase-rollback-and-what-to-do-instead
0
7
3
reposted by
Philipp Salvisberg
Tanel Poder
6 months ago
Postgres IDE in VS Code announced by Microsoft:
techcommunity.microsoft.com/blog/adforpo...
loading . . .
Announcing a new IDE for PostgreSQL in VS Code from Microsoft | Microsoft Community Hub
We are excited to announce the public preview of the brand-new PostgreSQL extension for Visual Studio Code (VS Code), designed to simplify PostgreSQL...
https://techcommunity.microsoft.com/blog/adforpostgresql/announcing-a-new-ide-for-postgresql-in-vs-code-from-microsoft/4414648
0
3
2
reposted by
Philipp Salvisberg
Gwen Shapira
6 months ago
🚨 New blog alert: Postgres 18 beta 1 was released last week, and includes native support for UUIDv7. Great opportunity to explain why UUIDv7 is a great fit for your database keys, and show you how to use them in PG18.
www.thenile.dev/blog/uuidv7
1
13
4
reposted by
Philipp Salvisberg
Dani Schnider
6 months ago
The story continues:
dblinter-rules.united-codes.com
loading . . .
Home
https://dblinter-rules.united-codes.com
0
5
1
reposted by
Philipp Salvisberg
DOAG e.V.
6 months ago
Die letzten offiziellen Minuten der
#apexconn25
laufen, um 15:45 wird die 11.
#orclapex
Fachkonferenz Geschichte sein. Wer ein Kombiticket für die
#DOAGDB25
hat, kann noch eine weitere Stunde dranhängen. Wir sagen schon mal tschüss und herzlichen Dank — bis bald 🫶
0
13
5
Load more
feeds!
log in