Skip to main content

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

· One min read
Adrian Png

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!

· 7 min read
Adrian Png

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.

· 6 min read
Adrian Png

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.

· 3 min read
Adrian Png

A helping hand

Too good to be true? No, it's true!!!

After hearing the rumours for a few years now, Mr Larry Ellison finally announced the availablility of a Free Tier for the Oracle Cloud. The gift bundle includes two small compute instances and two Autonomous Databases. These offerings are a tiny fraction of what the Oracle Cloud provides, but are sufficient for Oracle Developers to maintain their own 24x7 development environments and possibly even production applications for small businesses and non-profit organisations.

Like everyone else in the Oracle Application Express (APEX) community, I wasted no time in getting my account provisioned and am currently working towards moving workspaces and applications from my old personal APEX instance, hosted on Linode.

· 2 min read
Adrian Png

Happy siblings

In a blink of an eye, it has been more than four years since I set up the ORCLAPEX-YVR Meetup Group. This is a Meetup group in the beautiful city of Vancouver, British Columbia, that serves as a platform for promoting interest and supporting local Oracle Application Express (APEX) professionals and enthusiasts.

For those unaware, as organisers, we pay a biannual organiser's fee. Thanks to ODTUG's, these fees are kindly sponsored by #GetInolved initiative.

Thank you ODTUG!

Recently, I had an epiphany...

· 5 min read
Adrian Png

Reach the Cloud with a Helping Hand

With only three days remaining for my 30-day trial, I will finally close these series by discussing my experiences dealing with various levels of support from Oracle. Having used the Oracle Cloud (OCI) both in my day job and as a technology evangelist, I have had the opportunity to engage Oracle support at various levels: sales, customer and technical.

· 6 min read
Adrian Png

All sorts of functions

Oracle Function was announced late last year (2018), with limited availability to select Oracle Cloud customers. The platform is built on Fn and is Oracle's solution for developers wanting to deploy services using a Serverless Framework.

As succinctly explained by Kaslin Fields, a Fn function is a small embodiment of code that listens and speaks to HTTP streams. Ideally, each Fn function serves one, and only one purpose. It can be implemented in wide variety of programming languages and they are listed here (see the list of runtime options available).

· 4 min read
Adrian Png

Autonomous TT

In case you missed it (which is almost impossible), the Oracle Autonomous Database (AutonomousDB) is Oracle's hottest offering on the Oracle Cloud and it now comes fitted with what is arguably the best feature of the Oracle Database: Oracle Application Express (APEX). I have a few more days to go with this trial, so why not take one out for a spin?

· 4 min read
Adrian Png

Moving a House, New Zealand Style

To everyone following my 30 Days on the Oracle Cloud experience, I apologise that I was not able to keep up with the series previously, due to work commitments. I have enrolled in yet another trial, so I am hoping to continue where I left off and share my thirty day adventure with an Oracle Cloud trial. I'm on Day 14 now, and for this post, I'll examine an important issue that many of us face, even in our personal life - moving houses!

· 8 min read
Adrian Png

The Oracle Downtown Seattle Office Building

I was glad to be back in Seattle to attend the 2019 edition of ODTUG's famed Kscope conference. This is the second time the event is held this close to home (read my previous recount of the same conference five years ago)! And like every Kscope before, the conference always provides unique experiences, bountiful knowledge and new people to meet! Here's a quick summary and highlights of my week.

· 6 min read
Adrian Png

Photo by Gerd Altmann

Since Oracle Application Express (APEX) version 18.1, application developers are able to easily integrate OAuth2-based authentication using many popular identity providers including Google, Facebook and Microsoft. Morten Braten, Anton Nielsen and I have previously written on this subject.

Starting May 2019, Microsoft is changing how developers manage their OAuth2 application registrations.