Piet de Visser
@pdevisser.bsky.social
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"
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"
Good Points.
This needs Attention.
This needs Attention.
Waar is Europa?
Europa en onze digitale toekomst staan niet tussen de ‘prioriteiten’ waar D66 en CDA nu een agenda voor schrijven.
Nee, deze onderwerpen scoren niet lekker in de peilingen, maar het zijn wel de fundamenten van onze toekomst. En daar moet deze formatie alle aandacht voor zijn.
Europa en onze digitale toekomst staan niet tussen de ‘prioriteiten’ waar D66 en CDA nu een agenda voor schrijven.
Nee, deze onderwerpen scoren niet lekker in de peilingen, maar het zijn wel de fundamenten van onze toekomst. En daar moet deze formatie alle aandacht voor zijn.
November 13, 2025 at 2:13 PM
Good Points.
This needs Attention.
This needs Attention.
Reposted by Piet de Visser
Je ziet hier altijd gratis onze cartoons. Je kunt ons steunen door onze boekjes te kopen via onze eigen webshop. Ze zijn net zo duur als in de winkel. Maar bij ons kun je ze laten signeren met een tekeningetje... webshop.catullus.nl
Webshop Catullus – Boeken van Uitgeverij Catullus
webshop.catullus.nl
November 11, 2025 at 9:15 AM
Je ziet hier altijd gratis onze cartoons. Je kunt ons steunen door onze boekjes te kopen via onze eigen webshop. Ze zijn net zo duur als in de winkel. Maar bij ons kun je ze laten signeren met een tekeningetje... webshop.catullus.nl
New table added to Schema ...
No jokes about Devs creating tables.
And having 7 columns with actual names, well, it Is an Improvement over key-integer + payload-varchar2...
No jokes about Devs creating tables.
And having 7 columns with actual names, well, it Is an Improvement over key-integer + payload-varchar2...
November 12, 2025 at 9:39 AM
New table added to Schema ...
No jokes about Devs creating tables.
And having 7 columns with actual names, well, it Is an Improvement over key-integer + payload-varchar2...
No jokes about Devs creating tables.
And having 7 columns with actual names, well, it Is an Improvement over key-integer + payload-varchar2...
Reposted by Piet de Visser
Macros in Oracle #SQL enable you to define expression templates as text
At parse time the database merges these with the parent query, replacing parameters with the actual values passed
Macros come in two types
Scalar - use in SELECT, WHERE, ORDER BY, etc.
Table - use in FROM
At parse time the database merges these with the parent query, replacing parameters with the actual values passed
Macros come in two types
Scalar - use in SELECT, WHERE, ORDER BY, etc.
Table - use in FROM
November 10, 2025 at 12:02 PM
Macros in Oracle #SQL enable you to define expression templates as text
At parse time the database merges these with the parent query, replacing parameters with the actual values passed
Macros come in two types
Scalar - use in SELECT, WHERE, ORDER BY, etc.
Table - use in FROM
At parse time the database merges these with the parent query, replacing parameters with the actual values passed
Macros come in two types
Scalar - use in SELECT, WHERE, ORDER BY, etc.
Table - use in FROM
Useful
And potentially Addictive...
And potentially Addictive...
Click, click and voila! You're connecting from your own machine!
November 10, 2025 at 4:30 PM
Useful
And potentially Addictive...
And potentially Addictive...
how to find (some of the) typos..
just push your text to t' internet.
just push your text to t' internet.
November 9, 2025 at 3:09 PM
how to find (some of the) typos..
just push your text to t' internet.
just push your text to t' internet.
Could not resist playing with UUIDs in my Oracle database...
Oracle 26ai can provide UUID-V4.
Soon UUID-V7 ?
simpleoracledba.blogspot.com/2025/11/orac...
Just Playful code....
Dont Use this in Anger..
If you give them a finger they take the whole arm...
Oracle 26ai can provide UUID-V4.
Soon UUID-V7 ?
simpleoracledba.blogspot.com/2025/11/orac...
Just Playful code....
Dont Use this in Anger..
If you give them a finger they take the whole arm...
simpleoracledba.blogspot.com
November 9, 2025 at 3:09 PM
Could not resist playing with UUIDs in my Oracle database...
Oracle 26ai can provide UUID-V4.
Soon UUID-V7 ?
simpleoracledba.blogspot.com/2025/11/orac...
Just Playful code....
Dont Use this in Anger..
If you give them a finger they take the whole arm...
Oracle 26ai can provide UUID-V4.
Soon UUID-V7 ?
simpleoracledba.blogspot.com/2025/11/orac...
Just Playful code....
Dont Use this in Anger..
If you give them a finger they take the whole arm...
When a DBA adds you to their team...
...and in the next 4hrs you receive 180+ mails (from cronjobs...)
Some Things Never Change...
#DBAsRunTheWorld (I have that sticker somewhere.. Thx to @mikedietrichde.com )
...and in the next 4hrs you receive 180+ mails (from cronjobs...)
Some Things Never Change...
#DBAsRunTheWorld (I have that sticker somewhere.. Thx to @mikedietrichde.com )
November 4, 2025 at 12:15 PM
When a DBA adds you to their team...
...and in the next 4hrs you receive 180+ mails (from cronjobs...)
Some Things Never Change...
#DBAsRunTheWorld (I have that sticker somewhere.. Thx to @mikedietrichde.com )
...and in the next 4hrs you receive 180+ mails (from cronjobs...)
Some Things Never Change...
#DBAsRunTheWorld (I have that sticker somewhere.. Thx to @mikedietrichde.com )
Serious ??
The vacuum-cleaner spying + pwd-sniffing on your home-network ??
codetiger.github.io/blog/the-day...
The vacuum-cleaner spying + pwd-sniffing on your home-network ??
codetiger.github.io/blog/the-day...
The Day My Smart Vacuum Turned Against Me
Would you allow a stranger to drive a camera-equipped computer around your living room? You might have already done so without even realizing it.
The Beginning: A Curious Experiment
It all started ...
codetiger.github.io
November 3, 2025 at 7:16 PM
Serious ??
The vacuum-cleaner spying + pwd-sniffing on your home-network ??
codetiger.github.io/blog/the-day...
The vacuum-cleaner spying + pwd-sniffing on your home-network ??
codetiger.github.io/blog/the-day...
Grinning at this...
November 1, 2025 at 2:47 PM
Grinning at this...
Great: Oracle v26ai has the capability to generate UUID-V4.
Nice, and interesting to play with.
But I am also expecting at least UUID-V7 in the near future, Right ?
/cc @oracleasktom.bsky.social and @oracleace.bsky.social
simpleoracledba.blogspot.com/2025/11/orac...
Nice, and interesting to play with.
But I am also expecting at least UUID-V7 in the near future, Right ?
/cc @oracleasktom.bsky.social and @oracleace.bsky.social
simpleoracledba.blogspot.com/2025/11/orac...
Oracle 26ai - UUID v4 available, and looking at v7, Interesting!
TL;DR: in Oracle 26ai, there is the new function UUID(), which implements the UUID-V4. Someone also mentioned UUID-V7. I started experimenti...
simpleoracledba.blogspot.com
November 1, 2025 at 2:47 PM
Great: Oracle v26ai has the capability to generate UUID-V4.
Nice, and interesting to play with.
But I am also expecting at least UUID-V7 in the near future, Right ?
/cc @oracleasktom.bsky.social and @oracleace.bsky.social
simpleoracledba.blogspot.com/2025/11/orac...
Nice, and interesting to play with.
But I am also expecting at least UUID-V7 in the near future, Right ?
/cc @oracleasktom.bsky.social and @oracleace.bsky.social
simpleoracledba.blogspot.com/2025/11/orac...
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!
Shout out to @richard.fichtner.dev for the great idea!
October 22, 2025 at 3:53 PM
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!
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
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
October 22, 2025 at 7:17 AM
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
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
October 22, 2025 at 8:59 AM
"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...
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)
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...
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
October 16, 2025 at 2:56 PM
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)
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)
Thx Tim (@oraclebase.bsky.social).
That is a very read-worthy list.
And a sign that "the community" is still very much Alive.
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
oracle-base.com/blog/2025/10...
@oracleace @OracleAPEX #orclapex @OracleDatabase
October 16, 2025 at 12:30 PM
Thx Tim (@oraclebase.bsky.social).
That is a very read-worthy list.
And a sign that "the community" is still very much Alive.
That is a very read-worthy list.
And a sign that "the community" is still very much Alive.
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.
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
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
October 15, 2025 at 1:39 PM
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.
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.
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
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
Bescherm onze persvrijheid en steun radicaal onafhankelijke journalistiek.
Sluit je aan 👉 www.ftm.nl/word-lid
October 15, 2025 at 9:26 AM
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
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
Apart from all the buzz around the "release" of 26ai, Today is also #joelkallmanday ,
Coordinated by @oraclebase.bsky.social, our community blogs in with that hashtag to remember Joel ...
pdvfirstblog.blogspot.com/2025/10/simp...
Coordinated by @oraclebase.bsky.social, our community blogs in with that hashtag to remember Joel ...
pdvfirstblog.blogspot.com/2025/10/simp...
Simplicity, Troubleshooting, #JoelKallmanday
TL;DR: You don't have to be a genius to solve problems. And there is no shame in not-knowing or not understanding all the geeky details. Ma...
pdvfirstblog.blogspot.com
October 15, 2025 at 7:19 AM
Apart from all the buzz around the "release" of 26ai, Today is also #joelkallmanday ,
Coordinated by @oraclebase.bsky.social, our community blogs in with that hashtag to remember Joel ...
pdvfirstblog.blogspot.com/2025/10/simp...
Coordinated by @oraclebase.bsky.social, our community blogs in with that hashtag to remember Joel ...
pdvfirstblog.blogspot.com/2025/10/simp...
Italian!
October 12, 2025 at 5:05 PM
Italian!
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!
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
October 7, 2025 at 11:03 AM
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!
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!
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.
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.
October 1, 2025 at 7:04 PM
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.
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.
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 30, 2025 at 8:28 AM
Got it to work, Properly.
(including the elusive "hidden" parameter)
simpleoracledba.blogspot.com/2025/09/orac...
With Thanks to ...
@martinberx.bsky.social (blog + tips)
@connormcd.bsky.social (office hrs)
@gvenzl.bsky.social (images)
For hints, answers and container-images.
(including the elusive "hidden" parameter)
simpleoracledba.blogspot.com/2025/09/orac...
With Thanks to ...
@martinberx.bsky.social (blog + tips)
@connormcd.bsky.social (office hrs)
@gvenzl.bsky.social (images)
For hints, answers and container-images.
Oracle23ai, python, and v$history for your developers...
TL;DR: We got the v$sql_history feature configured for use in development. Python programs can now report on the SQL statements done Exactly...
simpleoracledba.blogspot.com
September 28, 2025 at 9:12 PM
Got it to work, Properly.
(including the elusive "hidden" parameter)
simpleoracledba.blogspot.com/2025/09/orac...
With Thanks to ...
@martinberx.bsky.social (blog + tips)
@connormcd.bsky.social (office hrs)
@gvenzl.bsky.social (images)
For hints, answers and container-images.
(including the elusive "hidden" parameter)
simpleoracledba.blogspot.com/2025/09/orac...
With Thanks to ...
@martinberx.bsky.social (blog + tips)
@connormcd.bsky.social (office hrs)
@gvenzl.bsky.social (images)
For hints, answers and container-images.
September 28, 2025 at 4:25 PM