Piet de Visser's Avatar

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"

585 Followers  |  318 Following  |  345 Posts  |  Joined: 27.07.2023  |  1.8904

Latest posts by pdevisser.bsky.social on Bluesky

You probably need both.

07.02.2026 06:40 β€” πŸ‘ 2    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0

When done badly, Scrum and DevOps lead to Q+D solutions.
Sometimes you need to step back and β€œdesign” your solution.

Imagine an order-shipping system with no β€œproducts” and no β€œcustomers”, and all data flattened, and endlessly repeated, into orderlines.

These things happen...

05.02.2026 18:59 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0

Eensch.
Maar een Staatssec is ook mooi.
Nu proberen die Staatssec van goede informatie te voorzien zodat hij/zij af en toe tanden kan laten zien.
Vooral Cybersec, Onafhankelijkheid, en Resilience lijken mij belangrijk.

05.02.2026 17:46 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0

Agree.

04.02.2026 18:33 β€” πŸ‘ 1    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0
Post image

hey, Can Never Resist a new Toy.
I got it (downloaded, X11-installed...)
Then tested it (trivially....)

Sometime I feel like holding a shiny new tool, looking for a use-case.
Will try more when time...

Nice job by @toonkoppelaars.bsky.social and @chrisrsaxon.bsky.social

31.01.2026 19:19 β€” πŸ‘ 1    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0
Post image

In solidarity with today's ICE OUT OF MINNESOTA blackout, MinnMax is donating $1 to the Immigrant Law Center of Minnesota for every share of this Bluesky post for the next hour.

23.01.2026 16:01 β€” πŸ‘ 16244    πŸ” 20397    πŸ’¬ 216    πŸ“Œ 348

Mee EΔ—ns

20.01.2026 19:41 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0

Thx for the reply.
I know I can add templates. Good tip for BIGFILE.
But what I really wanted was "no template", generate the complete database from (sql-)scripts, starting with CREATE DATABASE, and use all the relevant scripts in $OH/rdbms/admin and others.
(and I know this will take time...)

06.01.2026 12:06 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0

Yep. the Amazing #Stroopwafel

another hyped dutch export product.

(delicious nevertheless - always carry some when visiting friends. extra points if packaging is from in-house brand like Hema, Jumbo or AH supermarket)

Eet Smakelijk DWPete !

30.12.2025 12:09 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 1    πŸ“Œ 0

calling anyone in #Oracle sphere...

cc
@oracleace.bsky.social
@oracleasktom.bsky.social

29.12.2025 10:37 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 1    πŸ“Œ 0

#Oracle #v26ai
Anyone intereted in the β€œCREATE DATABASE” purely from Scripts instead of recovering from Template ?
The option seems removed in the currently available 26ai (free, using dbca) version.
Will the (soon) GA release allow to generate scripts ?

(anyone still creating their own?)

29.12.2025 10:35 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 1    πŸ“Œ 0
Post image

Electra King

28.12.2025 19:43 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0

... and how she has to help-fix every phone, tablet and printer in the hometown when she returns for Xmas.

28.12.2025 12:43 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0

Eh.. I do that as well: microwave cups. But a firmware-equipped cup might react badly to microwave.

22.12.2025 06:33 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0

Xmas for "bad" parents?

22.12.2025 06:29 β€” πŸ‘ 2    πŸ” 0    πŸ’¬ 1    πŸ“Œ 0
Preview
744K views Β· 16K reactions | What Using The Internet Is Like In 2025 | Ryan George What Using The Internet Is Like In 2025

This ...

www.facebook.com/reel/8762852...

20.12.2025 08:16 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0
Video thumbnail

I hate how much I enjoyed this

BIG NERD DESIGN ENERGY 🫦

13.12.2025 17:47 β€” πŸ‘ 6037    πŸ” 1945    πŸ’¬ 105    πŸ“Œ 195

hehehe.
Goede Vraag....

10.12.2025 17:15 β€” πŸ‘ 1    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0

True.
(Or, it was like that waay back when i needed crutches in sgp , hel, ams, lhr.. crippled passengers get excellent service)

09.12.2025 17:10 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0
Preview
a close up of a man wearing sunglasses and saying morning . ALT: a close up of a man wearing sunglasses and saying morning .
08.12.2025 05:27 β€” πŸ‘ 2    πŸ” 0    πŸ’¬ 2    πŸ“Œ 0
Preview
a man with a beard sits in front of a laptop ALT: a man with a beard sits in front of a laptop
08.12.2025 05:25 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0

Good Points.
This needs Attention.

13.11.2025 14:13 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0
Post image

Gets better at every iteration...

12.11.2025 10:13 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0
Post image

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...

12.11.2025 09:39 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 1    πŸ“Œ 0
SQL Macros
Can factor out common SQL expressions and statements into reusable, parameterized constructs
Scalar expressions, used in SELECT, WHERE, GROUP BY and HAVING clauses
Table expressions, used in FROM clauses  to encapsulate calculations and business logic
Scalar macro example

SQL Macros Can factor out common SQL expressions and statements into reusable, parameterized constructs Scalar expressions, used in SELECT, WHERE, GROUP BY and HAVING clauses Table expressions, used in FROM clauses to encapsulate calculations and business logic Scalar macro example

SQL Macros
Can factor out common SQL expressions and statements into reusable, parameterized constructs
Scalar expressions, used in SELECT, WHERE, GROUP BY and HAVING clauses
Table expressions, used in FROM clauses  to encapsulate calculations and business logic
Table macro example

SQL Macros Can factor out common SQL expressions and statements into reusable, parameterized constructs Scalar expressions, used in SELECT, WHERE, GROUP BY and HAVING clauses Table expressions, used in FROM clauses to encapsulate calculations and business logic Table macro example

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

10.11.2025 12:02 β€” πŸ‘ 5    πŸ” 2    πŸ’¬ 0    πŸ“Œ 0

Useful
And potentially Addictive...

10.11.2025 16:30 β€” πŸ‘ 1    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0

how to find (some of the) typos..

just push your text to t' internet.

09.11.2025 15:09 β€” πŸ‘ 1    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0

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...

09.11.2025 15:09 β€” πŸ‘ 1    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0

Allow me a joke #DBAsRunCronjobs, and cronjobs run the World (and the mail-volume)

05.11.2025 10:15 β€” πŸ‘ 2    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0

@pdevisser is following 20 prominent accounts