Piet de Visser
banner
pdevisser.bsky.social
Piet de Visser
@pdevisser.bsky.social
580 followers 310 following 310 posts
Database-guy, Typo-maker, Voyager. phd in I told you so, knighthood in... Airport Queues ? Get a motorcycle ! Movie Quotes: "You are a Meaningful and Valued member of ... " "Activate the Omega 13"
Posts Media Videos Starter Packs
Reposted by Piet de Visser
One cool thing we have since this year’s AI World - #Dev Tips cards for #OracleDatabase

Shout out to @richard.fichtner.dev for the great idea!
Reposted by Piet de Visser
Who doesn't want to be part of the 16th edition of APEX World?
Showcase your expertise in APEX to the community! We are seeking presentations for all skill levels, from novices to seasoned professionals, and everything in between.

👉 Visit buff.ly/dJc3ogC to submit your abstract!

Open until Dec 1
Reposted by Piet de Visser
"Op 29 oktober mogen we stemmen. Laten we daarbij niet alleen kijken naar verkooppraatjes over betaalbare boodschappen en loze leuzen, maar ook naar het fundament waarop alles rust: een vrije pers, een sterke rechtsstaat en de vrijheid om vragen te stellen." nvj.nl/actueel/gaan...
Gaan wij de Verenigde Staten achterna?
nvj.nl
When using in python (set the module-property on a connection) it will take effect on the next call.

In oracle=pythondb, it piggybacks on actual calls, e.g. when Real work is done and does not cause an additional RT.

Kinda Curious for other drivers.

nb: Not Obsessed by RTs. Not Obsessed. Not.
Yes, Please.
Set. That. Info.

In python it is as simple as assigning a str:
ora_connection.module = 'this is the culprit'

It doesnt even cause an additional round-trip, the setting is piggybacked on the next real call, just so you know.

(did I mention I dont like round-trips... I guess I did)
Java devs, please instrument your code 🧠
Have you ever struggled tracing SQL back to the app? Use setClientInfo(...) to add meaningful metadata to your JDBC queries. It makes tracing and perf debugging way easier.
New blog post with real code & tips:
🔗 martincarstenbach.com/2025/10/16/j...
Java devs, please instrument your code 🥺
While preparing a talk for Java developers I revisited the topic of code instrumentation. Within the database, for example when writing PL/SQL or MLE/JavaScript code, you would use DBMS_APPLICATION…
martincarstenbach.com
Also: a Reminder that a good list of blog-bookmarks can be Interesting to have.

You can Learn unexpected things from browsing those blogs...
Thx Tim (@oraclebase.bsky.social).
That is a very read-worthy list.

And a sign that "the community" is still very much Alive.
Joel Kallman Day 2025 : It’s a Wrap! (#JoelKallmanDay)

oracle-base.com/blog/2025/10...

@oracleace @OracleAPEX #orclapex @OracleDatabase
Recommended!
Even if you only go to conferences for the food and the drinks...

I had a lot of good learning, a lot of good connections, and quite a lot of Fun from being in this program.
🚀 We’re excited to announce a brand-new entry path to the Oracle ACE Program: ACE Apprentice—launching at Oracle AI World! ♠️

The ACE Apprentice level is designed to kickstart your journey as an Oracle advocate and unlock your potential within the global community. 🔒 🔑 💻

👉 ace.oracle.com/apprentice
"nog" is het operatieve woord...
Beste @ftm.nl ,

ik waardeer jullie Hogelijk.
Ga. Zo. Door.

Maar ik wil Niet Nog een App op mijn telefoons (inloggen, notifiations, tracing...).

Please, maak content (text en podcasts) ook via het ouderwetse www met een (anonieme, no-javascript, ad-blocked... ) beschikbaar.

#followthemoney
Dure en intimiderende rechtszaken zetten onafhankelijke journalistiek nog steeds onder druk. Ook Follow the Money krijgt regelmatig dreigbrieven. Maar wij laten ons niet de mond snoeren.

Bescherm onze persvrijheid en steun radicaal onafhankelijke journalistiek.

Sluit je aan 👉 www.ftm.nl/word-lid
Reposted by Piet de Visser
Processing one row at a time leads to lots of round-trips to the #database

This is SLOOOOOOOW

It's faster to batch records and send many in one call

How much faster?

@pdevisser.bsky.social tested with Python and batching inserted 150x more rows!
oracle23ai and python - eliminate RoundTrips.
TL;DR: Searching for RoundTrips to eliminate between python and Oracle. In this case, we "collect" the individual inserts to do them in a fe...
buff.ly
Good Memories.

I was read to.
I did some reading to my kids...
Not sure if it worked in our case,
but I can definitely Recommend this.
Makes me quite curious.
Remember these stickers...
(the Croatian variety is "Meni Radi" )
got a concept ready...

#JoelKallmanDay

@oracleace @OracleDatabase
Joel Kallman Day 2025 : Announcement

oracle-base.com/blog/2025/09...

#JoelKallmanDay

@oracleace @OracleAPEX #orclapex @OracleDatabase
And allow me to ask:

Can/Will v$sql_history replace sql_trace in the future ?
You did send an invoice, I suppose?
Reposted by Piet de Visser
Joel Kallman Day 2025 : Announcement

oracle-base.com/blog/2025/09...

#JoelKallmanDay

@oracleace @OracleAPEX #orclapex @OracleDatabase
Hint: More is not always better.

Think: Less is More...

(insert quote from Goethe:
In der Beschränkung zeigt sich erst der Scrum-Master....)
Phoenix Projects come and go,
But the Mythical Man Month will always be so.

(couldnt resist... a small tribute to F.P Brooks)

#IT
#projects
#Development
#Operations
#DEVOPS