Skip to main content

· 3 min read
Adrian Png

Crystal ball insights into tomorrow?

Is this a lasting treasure, or just a moment's pleasure?

~ Will You Love Me Tomorrow. The Shirelles.

As a technologist, we are constantly bombarded with buzzwords and terms like blockchain, IoT, AI, machine learning, quantum computing, and so much more! I love buzzwords, and wholeheartedly enjoy deciphering the future of technology and work. Hence, for the last few years, I have been a proud member of the committee that peruses and selects abstracts for the Kscope Emerging Technology (ET) track. For next year's Kscope22, I am honoured to be leading the team that will help select a series of sessions that are visionary, and hopefully, give us guidance on what to expect in the years ahead.

· 6 min read
Adrian Png

Ssshhh! Do not tell anyone!

For a long time now, I have been eagerly awaiting for out-of-the-box RSA encryption support with pure PL/SQL. Not so much for to sharing secrets, but rather, the ability to sign messages and verify signatures. I might have missed the announcements, but it looks like my wait is over support with asymmetric key operations added in 21c, and (perhaps backported) in 19c as-of release 19.9.

· 9 min read
Adrian Png

Neurons

During a recent Kscope21 session, "Predict Customer Churn Using Oracle Autonomous Database, Machine Learning, and APEX", I had shared that it has always been my personal desire to create web applications that are not only purposeful, but also have an element of "intelligence". With new features recently introduced in the Oracle Machine Learning product offering, it is now relatively easy to introduce ML as a component of your Oracle Application Express (APEX) applications. This is the first of several posts that I am writing as a follow up to the presentations I did at this year's (virtual) conference.

· 8 min read
Adrian Png

Embedded ARM chip

In September 2020, Oracle first announced that it was working with Ampere Computing to provide ARM-based chips for its Compute instance offering on the Oracle Cloud Infrastructure. They have delivered!

ARM chips are found in many low-powered devices like smartphones, single-board computers, and IoT devices. So, if you are an Oracle Application Express (APEX) developer, you might be wondering, "What's in it for me?" Well, remember we talked about running a customer-managed Oracle REST Data Services (ORDS) instance for an Oracle Autonomous Database?

· 6 min read
Adrian Png

Figuring out sentiments.

The Oracle Cloud Infrastructure (OCI) is a great platform in many ways. However, as much as I love it, I have long griped about the lack of out-of-the-box support for AI services that many of Oracle's competitors have. Well, as of May 6, 2021, I am glad to see that things are starting to turn around with the launch of the OCI Language service.

· 2 min read
Adrian Png

Keep Security Up to Date

In my previous blog post on Running ORDS Against the Autonomous Database - Part 2, we had looked at how to add an existing Let's Encrypt (LE) SSL certificate to an Oracle Cloud Infrastructure (OCI) Load Balancer. You'd typically wwant to host your websites or Oracle Application Express applications over a secure transport layer, especially when sensitive data is communicated between the browser and server.

· 2 min read
Adrian Png

Spider Web

As Uncle Ben would say, "Remember, with great power, comes great responsibility." With the release of Oracle REST Data Services (ORDS) version 19.4.6, many of us were eager to deploy a customer-managed ORDS solution in order to support vanity URLs with Oracle Application Express (APEX), myself included. It has worked well for me until a few days ago, I noticed that my Oracle JET charts weren't loading any more.

· 7 min read
Adrian Png

Old pipes and valves

In my previous post, we looked at installing and configuring Oracle REST Data Services (ORDS) and have it work with Oracle Application Express (APEX) that comes preinstalled with every Oracle Autonomous Database (ADB). Like APEX, ORDS is also included as a feature of the ADB. However, there are certain situations where you might like to manage your own instance of ORDS.

· 8 min read
Adrian Png

Man repairing the engine of a car

The Oracle Autonomous Database (ADB) is Oracle's current flagship database product and rightly so! Each instance comes with self-tuning, self-patching and several Oracle Database Options that customer would otherwise have to purchase separate licenses for. Database developers will also be pleased to know that there are a suite of tools at your disposal including Oracle Application Express (APEX), Oracle REST Data Services (ORDS) and Oracle Machine Learning Notebooks.

The minimum instance you can create will have 1 CPU and 1 TB of storage and with so much features, doesn't come cheap. Here's the good news though, Oracle provides everyone two Always Free ADBs through the Oracle Cloud Free Tier offering. Yes, that's a great deal for anyone wanting to host a simple web application on the Internet. It is however, not without limits.

· 2 min read
Adrian Png

Java Challenge Coin

My personal journey with programming started more than two decades ago. Back then, the one language that I was very passionate and determined to master was Java. Early in my career, I would find any opportunity to attend a Sun Microsystems event like the Sun Tech Days, where I had the opportunity to learn about the constantly evolving platform that went from desktop, to enterprise and then on mobile devices. I can still remember watching the cool things you could do with Lego Mindstorms and an embedded Java runtime, and the vision that JXTA was going to revolutionise the Internet of Things with its state-of-the-art, peer-to-peer technology.

· 4 min read
Adrian Png

Singapore National Day Parade - March Past

Every Singaporean Son grows up to respond to a codeword alongside an image of a soldier on guard.

When your codeword is flashed on the screen, you wrap up whatever you are doing, head home, pack, bid your goodbyes and then report to camp. Hence, when I heard this call to help, instinct kicked in and I had to respond.

· 4 min read
Adrian Png

Happy New Year!

Probably too late for New Year greetings, but not if you also celebrate the Lunar New Year that's coming really soon. For readers who, like me, celebrate this festival, I'd like to take the opportunity to wish you 新年快乐,万事如意!

It's now been almost a year since the APEX Challenge Coin was released, and I must say, it's made 2019 a year to remember!

· 5 min read
Adrian Png

Horizontal Old Weights

A reader left an interesting comment/question in my previous post on Making the Move to the Autonomous Database:

"Would You explain how can i check my on-premise DB to satisfy ADB size limitation 20G? What is the size 20G of?"

This is an excellent question to ask before embarking on any Autonomous Database (ADB) migration plans and so I dug a bit deeper.