Thinking Anew

Keep Your APEX Images Updated

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.

Read More

Running ORDS Against the Autonomous Database - Part 2

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.

Read More

Running ORDS Against the Autonomous Database

Man repairing the engine of a car

The Oracle Autonomous Database (ADB) is Oracle’s currernt 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.

Read More

Happy 25th Anniversary Java

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.

Read More

A Call to Aid

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.

Read More

APEX Challenge Coin 2020 Edition

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!

Read More

Watch Your Weight

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.

Read More

OGB Appreciation Day: Challenge Coin Sponsors

Happy toddler clapping

My #ThanksOGB will be short and sweet!

Most in the community probably don’t know, but I am a sucker for military stories and even more crazy about hard-to-find memorabilia. Earlier this year, I took a gamble and started a little social experiment and minted a small batch of APEX Challenge Coins.

The coins demonstrated our deep appreciation for APEX developers who have impacted our lives. Through the process of distributing them worldwide, I was blessed to have basked in the warmth of givers and the happiness of receivers. Words cannot describe the emotions and joy I felt each time someone opens his or her little mail packet to find a gift of gratitude.

So… for my #ThanksOGB appreciation post this year, I wanted to express again, my heartfelt gratitude to all APEX Challenge Coin sponsors for making this project a success. Thank you for supporting APEX developers!

Making the Move to the Autonomous Database

Packing boxes

In my previous post, I mentioned that I have created my Oracle Cloud Free Tier account and provisioned an Autonomous Database (ADB). Now, I’m ready to move my existing Oracle Application Express (APEX) to this new environment. Next, I’ll describe the steps I took to move (1) workspace, (2) application and (3) data, from the old to new database.

Read More

Autonomous DB - The Developers' Playground

Kids' Playground

As mentioned in a previous post, the Free Tier for Oracle Cloud (OCI) is every Oracle Developer’s dream. For a while now, I have hosted a personal Oracle Application Express (APEX) instance on Linode. It currently runs an older Oracle Database 11gR2 Express Edition (XE), and I would like to upgrade it to version 18c. The key issue I had though, was that the existing virtual machine hosted on Linode, only has one gigabyte of RAM and that does not meet the 18c XE minimum requirement of two. That left me procrastinating for a long time, but perhaps a blessing in disguise. With this new offering, the next steps are pretty obvious.

Read More