Sign in

Piet de Visser

@pdevisser.bsky.social
625 followers 351 following 431 posts

Database-guy, Typo-maker, Voyager. phd in I told you so, knighthood in... A french friend designated me "un Baroudeur" Airport Queues ? Get a motorcycle ! Movie Quotes: "You are a Meaningful and Valued member of ... " "Activate the Omega 13"

PostsRepliesMedia
Piet de Visser @pdevisser.bsky.social · 25/09/2026
Good Idea by @oraclebase.bsky.social oracle-base.com/blog/2026/09...
oracle-base.com
Joel Kallman Day 2026 : Announcement | The ORACLE-BASE Blog
Since 2016 we’ve had an Oracle community day where we push out content on the same day to try and get a bit of a community buzz. The name has changed over the years, but in 2021 it was renamed to the ...
011
Piet de Visser @pdevisser.bsky.social · 10/09/2026
Books, documentaries, movies.. I seem to spend a lot of time "fact checking", location-checking, or just plain curious any-checking, for items.. internet is Great for that.
002
Piet de Visser @pdevisser.bsky.social · 08/09/2026
Yep.
000
Piet de Visser @pdevisser.bsky.social · 08/09/2026
Keeping this for reflexion.
010
Piet de Visser @pdevisser.bsky.social · 08/09/2026
Team told to use coding agents....
static.klipy.com
Old people tapping
ALT: Old people tapping
010
Piet de Visser @pdevisser.bsky.social · 07/09/2026
I just pulled the plug on an empty fridge. Making noises like it is 1999... modelyear.
021
Piet de Visser @pdevisser.bsky.social · 07/09/2026
Days since last sabotage of hotel fridge: 0. (Reset counter, and... Fridge was empty...)
010
Piet de Visser @pdevisser.bsky.social · 07/09/2026
Ok, the coffee is Western priced.... But phone signal is 4/5 and whole station superClean, esp washrooms. And happy-smiling real-ppl behind the counter.
020
Piet de Visser @pdevisser.bsky.social · 07/09/2026
Fuel stations in "older europe" Please Take Note. In a station deep in rural Poland, I can charge at any table (and Yes, the sockets are actually under power)
100
Piet de Visser @pdevisser.bsky.social · 31/08/2026
Getting closer to Poland.... #poug (and this German "Landhotel" can get an +/- OK mention for wifi)
020
Piet de Visser @pdevisser.bsky.social · 31/08/2026
These students have to pass serious entry-criteria. Any country that has a large influx of talented and entrepreneurial foreign students should be proud, and facilitate those young folks. These students can turn into LifeLong Ambassadors and contribute to the country, economically and culturally.
010
Piet de Visser @pdevisser.bsky.social · 24/08/2026
Could not resist... The One Script to create a database. Hobby project got out of hand. Was Great Fun. I did re-learn a few things, also check the minor improvements. simpleoracledba.blogspot.com/2026/08/draf... Normal Work will resume shortly. #oracle26ai #database #scripting #linux #SQL #sh
simpleoracledba.blogspot.com
Creating an Oracle 26ai database from a Single Script - Cool.
TL;DR: The One Script you will Ever Need to create an Oracle 26ai Database . And for you to configure, should you want to. After a remark fr...
010
Piet de Visser @pdevisser.bsky.social · 20/08/2026
Respect to the Baltics who took their Independence. (and a Very Respectful Tip to the Hat to the late Major-General Dudayev of the Sovjet Air Force, who allowed it to happen without bloodshed)
120
Piet de Visser @pdevisser.bsky.social · 19/08/2026
And let me add: Always Explain the Idea, the Concept. The script will follow from that. Never start with reading code, start with Understanding the Idea behind the code... Data is More Important than Code.
000
Piet de Visser @pdevisser.bsky.social · 19/08/2026
DBA, admin, Scripting. When you set out to combine, improve, maybe simplify a set of scripts... And you end up with a Rather Looong new script which then also needs some explaining to colleagues... #Simplify #includeComments #NeverHARDCODE (Parameters are Good, Defaults are Easier...)
100
Piet de Visser @pdevisser.bsky.social · 15/08/2026
And those who do not Design (and do not Think about) their datamodel are doomed to tweak and wrestle with their systems forever (the source of eternal work-hours, but often not very satisfying....)
100
Piet de Visser @pdevisser.bsky.social · 15/08/2026
I'd allow my code be AI-generated (and review it...) but I would keep Strict Control over my Data. (e.g. a data-model in an RDBMS with proper constraints!)
100
Piet de Visser @pdevisser.bsky.social · 15/08/2026
Thought: Design your Data! Datamodel and actual Data(-content) are More Important than "code" or (AI-) code-reviews... A well designed Data-model in a well Protected (RDBMS, Constraints!) will outlive "code" by several generations. And modifying "code" is a lot easier than "migrating data".
140
Piet de Visser @pdevisser.bsky.social · 11/08/2026
Type 7... www.youtube.com/watch?v=eNk9...
youtube.com
Your Motorcycle Says More About You Than You Think (7 Types Explained by Psychology)
YouTube video by Throttle Psychology
010
Piet de Visser @pdevisser.bsky.social · 09/08/2026
1/5 score. Your product is probably ok. But your nagging app made me quit.
010
Piet de Visser @pdevisser.bsky.social · 09/08/2026
And follow these instructions to disable your ad-blocker. (I disengage... )
010
Piet de Visser @pdevisser.bsky.social · 08/08/2026
This was actually quite Fun to tweak with. Nice Memory. Idea came while listening to @chrisrsaxon.bsky.social. It got outlined on train-trip, then had to polish text and demo-scripts several days to get it "readable". Ended up with 3 blog-posts... Is it worthy of a ppt+demo session ?
030
Reposted by Piet de Visser
Connor McDonald on Database and SQL @connormcd.bsky.social · 05/08/2026
Time to level up your GUID usage. connor-mcdonald.com/2026/08/05/m...
connor-mcdonald.com
More Gooey-ness from GUIDs
I wrote a post a few years back (well, actually it was 2018!) but I’ll paraphrase briefly. There are two common schools of thought when it comes to automatic generation of values for a surrog…
073
Piet de Visser @pdevisser.bsky.social · 27/07/2026
There are those organizations that Know they have been hacked... And there are those that dont know, yet.
020
Piet de Visser @pdevisser.bsky.social · 22/07/2026
Interesting.
100
Piet de Visser @pdevisser.bsky.social · 20/07/2026
Colleague with coffeemug, doing some shoulder-surfing while I rapidly logon to various screens... "Hmm.. you are obsessed with that Polish Conference eh ? me: huh? him: your password, it is accidentally visible... Fr0mN!2POUG2026 #POUG2026
010
Piet de Visser @pdevisser.bsky.social · 17/07/2026
This title... so many use-cases
050
Piet de Visser @pdevisser.bsky.social · 13/07/2026
In case anyone needs another motivation to go to #HOUG. Motovun is right there as well. www.facebook.com/reel/1299794...
facebook.com
000
Piet de Visser @pdevisser.bsky.social · 12/07/2026
And the less program, the less testing is needed, and the less Risk of PROD going berserk over some junior-promted-requirement.
000
Piet de Visser @pdevisser.bsky.social · 12/07/2026
(with relaxed thinking cap on) Code-generation is now so easy.. Any idiot can produce scripts or programs that do (approximately!) what he wants them to do. But who remembers: An extra Hour of Design, saves an Day of Programming. And a extra Day of Programming saves a Week of Testing?
100
Piet de Visser @pdevisser.bsky.social · 10/07/2026
Agree n ia a much better name for the loop-variable.
110
Piet de Visser @pdevisser.bsky.social · 09/07/2026
Guy next to me is working on Train-the-Trainer-for-the-Train-the-Trainer-Training.... Recursive datamodel anyone ?
000
Piet de Visser @pdevisser.bsky.social · 08/07/2026
I went a bit OTT with my minimalistic-scripts to create a database. simpleoracledba.blogspot.com/2026/07/draf... But it was Fun to tweak the scripts. I have a few more ideas, notes, suggestions. Maybe Later. First: I have a motorcycle to Ride.
simpleoracledba.blogspot.com
Creating an Oracle 26ai database - Parameters and parameter-files.
TL;DR: The minimum amount of parameters for the init.ora when creating an Oracle 26ai database from scripts. Simple is better: I'll provide ...
021
Piet de Visser @pdevisser.bsky.social · 30/06/2026
Solution: Put the SQL into an SQL-file and run That. cat<<EOF>show_echo.sql set echo on select 'Now you finally see the echo' as txt , 'Even multiline.' as txt2 , 'QED.' as txt3 from dual ; EOF sqlplus scott/tiger@orclpdb1 <<EOF @show_echo EOF Try it, and admire The multiline Echo
000
Piet de Visser @pdevisser.bsky.social · 30/06/2026
This .. Came back when I tried to demo something - Again. Put this in do_it.sh: sqlplus scott/tiger@orclpdb1<<EOF select 'no echo yet' as txt from dual ; set echo on select 'still no echo' as txt from dual; EOF Not the echo you expect ! Happens to me time + again...
140
Piet de Visser @pdevisser.bsky.social · 29/06/2026
Warm day, sitting in evening-shade. Just had a rabbit hopping up to me. At abt 2m it realized "oops, a human" and turned around....
030
Piet de Visser @pdevisser.bsky.social · 29/06/2026
After discussing with a colleague today. You only Really Learn a topic when you try to explain it to someone. (or when you try to write an exhaustive blog about it.. Fact-Check Everything, Verify, and Do Not Trust what you think you Know)
000
Piet de Visser @pdevisser.bsky.social · 27/06/2026
is this an #ACE reference ?
000
Piet de Visser @pdevisser.bsky.social · 27/06/2026
Sitting in a metal barn, just underneath that big red Thunderstorm area W of Middelburg. Noise ! But the wind and rain are very welcome after the heatwave-days we just had.
040
Piet de Visser @pdevisser.bsky.social · 25/06/2026
Still experimenting with "create database" scrips. Sometimes feels like LEGO., but I'm getting somewhere. /cc @oracleace.bsky.social #oracle26ai #scripting #cli simpleoracledba.blogspot.com/2026/06/orac...
simpleoracledba.blogspot.com
Oracle 26ai Create Scripts: Catalog and Components
TL;DR: The DBCA showed me how to add catalog, catproc, and various components. We are Getting Somewhere. I'll try to make those scripts more...
130
Piet de Visser @pdevisser.bsky.social · 17/06/2026
How to discover typos in a text...? Press the send-button. Or Publish it.
000
Piet de Visser @pdevisser.bsky.social · 17/06/2026
Still trying to create a database from scripts... simpleoracledba.blogspot.com/2026/06/expe... @oracleace.bsky.social #Oracle26ai #DBCA #CLI Mainly just having fun, but I did (re)learn a few things. Not finished yet.
simpleoracledba.blogspot.com
Experimenting with DBCA-scripts of Oracle 26ai: Create Database.
TL;DR: I've got generated scripts from DBCA (see previous blogs) , and I experiment with them. First I morf the initial Create-statement an...
120
Piet de Visser @pdevisser.bsky.social · 12/06/2026
And those are the ones we Know about....
000
Reposted by Piet de Visser
Anne Applebaum @anneapplebaum.wsocial.eu · 12/06/2026
Amazing: KPMG wrote a report describing the successful use of AI by businesses. But the case studies turned out to be AI hallucinations. giftarticle.ft.com/giftarticle/...
giftarticle.ft.com
KPMG report contained AI hallucinations on benefits of . . . AI
Bogus case studies on UBS and transit systems exaggerated adoption of the technology
952318923
Piet de Visser @pdevisser.bsky.social · 11/06/2026
Had Good Fun examining and tweaking the (DBCA-generated) scripts to create a database... #oracle26ai #DBCA #CLI /cc @oracleace.bsky.social Curious: Anyone still using those script? Any preference for scripts over Templates ? simpleoracledba.blogspot.com/2026/06/orac...
simpleoracledba.blogspot.com
Oracle 26ai DBCA scripts that (help you to) create a database
TL;DR: Still on my quest to Create an Oracle 26ai Database From Scripts. I'll examine some of the resulting scripts from DBCA. Image: Critic...
030
Piet de Visser @pdevisser.bsky.social · 09/06/2026
Oracle 26ai: The "Assistant" is still alive and clicking. Before you ask some random LLM, visit this legacy-assistant. It has been there since the dawn of time, check out that X11 UI... #Oracle26ai simpleoracledba.blogspot.com/2026/06/crea...
simpleoracledba.blogspot.com
Creating a Database: Ask DBCA to help you...
TL;DR: The scripts generated by DBCA work, although some tweaks and caveats apply. But in the end: Yes. They Work! image: Startup of the DBC...
010
Piet de Visser @pdevisser.bsky.social · 08/06/2026
And dont you just love the fact that AI can generate your clip-art ?
000
Piet de Visser @pdevisser.bsky.social · 08/06/2026
Good fun with Scripts. Very Simple Scripts... Mixed results so far, but Interesting, and Fun. #Oracle26ai simpleoracledba.blogspot.com/2026/06/crea...
simpleoracledba.blogspot.com
Create an Oracle 26ai database, from minimalistic script (maybe dont)
TL;DR: My Minimalistic script to create a database Worked, sortof (link to previous blog) . Now let me Examine the first results and make so...
100
Piet de Visser @pdevisser.bsky.social · 04/06/2026
I'm playing with scripts again... Old hobby project of mine: Create a Database with just scripts. This time using #Oracle26ai. simpleoracledba.blogspot.com/2026/06/crea... (are there any script-jockeys left out there who still do this?)
simpleoracledba.blogspot.com
Creating an Oracle 26ai Database from Scratch using scripts
TL;DR: I want Scripts. Hence I am going to try and create an Oracle 26ai database purely using scripts. Specifically not recovering any temp...
020
Piet de Visser @pdevisser.bsky.social · 31/05/2026
I think there are more contenders: Czech Republic, Most of the Balkan countries, Norway... I'm shure the ppl there also have an opinion on their local beers.
010