Masking sensitive fields in APEX

Data masking with APEX Background A common customer requirement is to mask sensitive or personally identifiable data from APEX reports. Oracle has a ‘Data Masking and Subsetting’ product that performs this task. However, for smaller APEX projects, the full blown data masking product might be overkill as it needs familiarity with the product and configuration. This may be time consuming and expensive. However, we are able to use the PL/SQL package DBMS_REDACT to achieve the same result. ...

September 26, 2022

Hugo blog now hosted on Netlify

This blog uses Hugo and was previously hosted on Amazon S3 storage. The traffic and hence the costs were minimal (zero). After recently having to completely re-install Arch Linux after an idiotic mistake, I realised that Hugo was out of date, my Hugo theme was out of date and I’d forgotten precisely how the deployment to S3 actually worked. I was toying with taking my ball home in a mindless fit of pique, migrating 1,000 posts to Eleventy and I also looked at the Publii static site CMS with interest. ...

September 23, 2022

Agile development with Oracle APEX

Tim Hall recently made a wonderful suggestion that the Oracle community remember the much missed Joel Kallman on 11 October 2021. My contribution doesn’t demonstrate APEX technical wizardry. Instead it’s a short story from a real-life customer project implemented using APEX. Just to avoid any potential law suits, this post isn’t about Agile development either - more how APEX can be used to quickly respond to changing customer requirements. One particular post from Joel stuck with me about his attitude to customer service which can be encapsulated in a single line: ...

October 11, 2021

BetFair should really be called BetUnfair

I’m not really a betting man. Mainly because I’m a scientist. On Grand National day, we normally nominate two or three horses each and someone wanders to place our bets at the bookies round the corner. My daughter normally wins. Also, we might cut up the runners from the Daily Mail supplement and do a lucky dip sweepstake. I also used to routinely bet on the final score and first scorer in the FA Cup Final to add some interest (if United weren’t involved). ...

March 10, 2021

intelligent people doing stupid things

Saturday 18 July A beautiful, sunny Saturday morning but instead of sitting in a field in Hook Norton, drinking real ale, laughing, chatting rubbish and analysing the football season with my mates, instead we enjoyed a long overdue visit from my wife’s hairdresser. She is self-employed and a mobile hairdresser. We opened up the garage door and prepared chairs, black bin liners (to avoid using her capes) and an extension cable for her hairdryer and clippers. ...

July 20, 2020

the curious case of the 'More' tag

I am not sure I like this increasing but irritating use of the ‘More’ or ‘Sensitive Content’ tag on Mastodon. From a cursory glance, I can’t even see how to add it from the Web interface. I’m not sure whether it’s enforced by the Mastodon instance or actively selected by the user. I presume it’s the latter. Microblogging to supposed to be short, snappy and spontaneous. I understand why sensitive media content might merit another key click (to protect the children) but if you’re posting about politics, I’d really rather see all the content in one fell swoop and then I would feel free to choose to ignore it. ...

June 11, 2020

in praise of MiniDLNA

Five years ago, I purchased a Roberts Digital radio for the kitchen. Mainly to listen to the radio but also this device could play music from Spotify, a USB stick or act as a UPNP client. As I already had the Plex Media Server set up which had a DLNA option, this looked attractive. The setup worked pretty well apart from one minor glitch. And, like a dripping water tap, or the endless, harrowing screams of a baby played on a tight loop in an American interrogation facility, any minor technical glitch can’t simply be ignored. ...

June 4, 2020

rendezvous with strange man in mask

I anxiously coaxed my wife out of the door to her work trying not to raise her suspicions. My stomach was fluttering as I had an important early morning meeting. To fully prepare, first, I chose my mask. I had two options; a flesh coloured creation that resembled a one bosom bra or a more sinister black model. I tried the pale pink mask but as it, err, masked my nose, mouth and chin, it made me resemble a burns victim who had endured time consuming and expensive reconstructive surgery which had either failed or was still ongoing. ...

May 21, 2020

Netflix lockdown list

There’s nothing worse than yet another lockdown Netflix list. Sons Of Anarchy Heard about this series from Linux Outlaws many years ago. Jax Teller is a very handsome man. I am convinced he is the bastard son of Kurt Cobain and Brad Pitt. A decent series about biker gangs in California that inevitably features gratuitous violence and goes through peaks and troughs (the season when they went to Ireland was very weak). ...

May 19, 2020

remembering Ian Curtis

Today is the 18 May 2020 and marks the 40th anniversary of when Ian Curtis took his own life so I was pleased to see that Bernard Sumner and Stephen Morris are remembering the event - ‘Moving through Silence’ I grew up in South Manchester and it’s hard to describe how important music and football were during my formative years. I never saw Joy Division play live but some of my schoolmates did (‘He did this weird dance’). However, I have visited Curtis’ memorial in Macclesfield cemetery. ...

May 18, 2020