Thinking Anew

Research-Ready

Photo by Louis Reed

In a flash, it has been almost three years since I left the Centre for Heart Lung Innovation, so it’s no surprise that a recent tweet caught my eye and tugged the memory chord. I was introduced to Oracle Application Express (APEX) on August 26, 2010. A year (and a major release) later, I had the opportunity to demonstrate it’s capabilities with proof that it could help improve productivity in our research centre. As a sidenote, back then, attendees receive DVDs full of developer software goodies. APEX however, didn’t need much, just check out the hands-on lab requirements below.

Read More

A Kscope to Remember

Where Dreams CAME True

That’s right! Here’s the customary post-Kscope article. This year though, is one Kscope to remember! Along with other Oracle Application Express (APEX) community members, I had the surprise honour of joining the ranks of the Oracle ACE Program. And so I wanted to start off by first thanking newly-minted Oracle ACE Director Opal Alapat. Last year, I had deep suspicions that she was responsible for my ODTUG Volunteer Award. Then came the ACE Associate nomination.

Opal, if you are reading this: THANK YOU!

Read More

APEX Social Sign-In Without a Wallet

Social Media

Updated June 4, 2018

  • Added settings for social sign-in with Microsoft OAuth2.

The much anticipated Oracle Application Express version 18.1 was announced on May 24, 2018. Since early this year Monty Latiolais has been posting a monthly series of blog posts on Power Ranking Oracle APEX 18.1 New Features. My personal favourite is Social Login, but unfortunately it never made it to the top, even though it should!

Read More

Just a Drop of Oracle APEX

Photo by Johnny Brown

In a previous article, I had demonstrated how one could use Vagrant to deploy an OXAR virtual machine directly to Linode.

With Digital Ocean (DO) lowering their prices to match Linode’s, I thought it would help the community if I created a similar set of instructions to deploy OXAR on DO. I took this a step further and have provided a branch on the Github repository with a modified Vagrantfile.

Read More

Write High Quality JavaScript Code for Oracle Application Express

Old Handwritten Book by Kiwihug

It’s funny how JavaScript’s 20th birthday was not as spectacular as it’s shorter-named bretheren. When I first learned JavaScript in the late 1990’s, I wasn’t too excited as I was about Java, for two reasons most web developers know about JavaScript: weakly typed and non-standard browser implementation. The latter has been addressed by ECMA, but does that mean our code can now be more predictable and consistent?

Read More

Two Days of Node.js

Main Ballroom Before the Big Event Starts

The beautiful City of Vancouver (in British Columbia) played host to the North American Node.js Interactive 2017 conference earlier this month. That close to my backyard, it was simply inexcusable not to attend! I wasted no time in getting the support of my employer and am glad I did. Here’s a little summary of my experience and what I learned at the two-day conference to share.

Read More

Oracle APEX and REST Without the Pain

Photo by Hisham Abo-hamad on Unsplash

Earlier this year (2017), I had the privilege to share with the community, some of the work and experiences I gained helping to build some of the blocks that form the foundation of apex.world. In my presentations, I had shared some of the challenges I had integrating RESTful web services with Oracle Application Express (APEX). A crippling issue involved the use of Oracle Database Express Edition (Oracle XE) and communicating with web services over a secured protocol. The by-product of that experience led to the development of a simple Node.js application, which I named Suez.

Read More

Real Uptime Monitoring of Oracle APEX Instances

All Systems Go!

Running a production application on an Oracle APEX instance? Then read on!

Making sure your application is up and running 24/7 doesn’t need to be a daunting task, plus it may not even cost you a dime! UptimeRobot provides 50 free monitors that can poll your servers using the smallest interval of 5 minutes. You can easily monitor websites and receive multi-channel notifications of downtime. No excuse!

Read More