Oracle Node.js Database Driver

I’ve been eagerly awaiting the first release of the Official Oracle Node.js Driver and Christopher Jones (@ghrd) just tweeted this –


So I hopped over to the Github repository to take a look and try it out…

…I’m very impressed so far…

Back in 2014, I presented at KScope on “Oracle APEX + Node.JS – A Primer” where I showed many demos on just how you can integrate Node.JS into your APEX applications. For example I showed –

  • Office Integration – produce Word, Excel, Powerpoint documents
  • Consume and Publish REST Webservices from the database
  • Using Node to automatically export your APEX application and supporting objects
  • Integrating GRUNT into your APEX workflow
  • TextToSpeech from an APEX application (so you could have your APEX application talk to you!). This one was a fun one to do, even though it might not have many practical applications it’s kind of cool to do something that hasn’t really been done before.

Many more…

I first came across Node.JS a few years ago and became interested in ways to use it to extend APEX applications, I encourage you to take a look at it.

p.s. I’ve been asked by a lot of people to share the demos I presented and I’ll be doing exactly that in a series of upcoming blog posts. Except this time I’ll use the Oracle Node Database driver!

SQLDeveloper and SSH Tunnels

I saw @krisrice post this

I’ve been using SQLDeveloper for a long time now and have always setup my SSH Tunnels separately (using tools like Meerkat). So I thought I’d take a look at how easy it is to use SSH Tunnels natively with SQLDeveloper.

Turns out it’s incredible simple to configure, simply go to your database connection properties


Notice here that my connection is to localhost (since I’ll be using an SSH tunnel to connect to the remote machine), you could alternatively use a bastion host.

Click on the Advanced button and then select the SSH tab

All you need to do is specify the hostname you want to connect to along with the username. You could specify a password when you connect, but I’m using a keyfile so that I can essentially have passwordless login.

That’s it! Now when I try to connect to the remote connection, the SSH Tunnel kicks in and I don’t need to worry about setting up an SSH Tunnel externally to SQLDeveloper. Another nice side-effect of this is if I export the connection, I can share it with someone else and don’t need to worry about telling them to setup an SSH Tunnel as that information is also embedded in the connection export file (although obviously they’d need either the password or the Key File).

Perhaps not a marquee new feature in SQLDeveloper but a very welcome one!

My Oracle Openworld APEX Sessions

Oracle Openworld 2014 is just around the corner (it’s still not too late to register) and I’m going to be presenting a couple of sessions –

  • Oracle Application Express + Node.JS: A Primer [UGF5222] – Sunday, Sep 28, 2:30 PM – 3:15 PM – Moscone South – 300
  • Testing Oracle Application Express: Removing the Boring from Testing [CON5219] – Thursday, Oct 2, 2:30 PM – 3:15PM – Moscone South – 303

I presented these sessions at KScope14 and got great feedback from both sessions (I’m very proud to say I got a Top Speaker Award for the Testing session).

Hope to see you there!

APEX Evangelists Network Welcomes Paul Broughton

As I recently blogged, APEX Evangelists is undergoing a transformation (stay tuned for what that means for me).

We are very happy to announce that Paul Broughton (Twitter – @paulbroughton) has joined the AE Network!

For those of you who don’t know Paul, he started working for APEX Evangelists back in July 2009 (wow time flies!) and has been involved in many client facing projects (and very recently was presented with an award from a very happy client!).

Paul has grown as an APEX Developer and has been a valuable member of the team year on year and I’m sure he’ll continue to do so.

Congratulations Paul and welcome to the AE Network!

The evolution of APEX Evangelists

Every year we at APEX Evangelists come together to discuss the past and the future of the company.
In the past 7 years a lot has changed; the APEX market changed, the community changed, we personally changed, …

We really like APEX, we are all passionate about it, we love to have technical discussions with each other and come together to share our thoughts, but we also like our independence and make our own trade-offs company wise.
So we decided to go a different route with “APEX Evangelists”. And that’s why we’re now in the midst of transforming APEX Evangelists from a company to a network.
A network of APEX experts. A network without any financial incentive behind it. A network of independent people that are passionate about APEX. A network of recognised experts in the Oracle community. A network with members that can rely on each other and trust each other.

You can also become part of this network, but only by invitation and acceptance by the other members.
We love to compare us with the Oaktable network, which is a network of experts for the Oracle database. We hope that “APEX Evangelists network” will be the same for Oracle Application Express.
The first addition to the APEX Evangelists network is Martin Giffy D’Souza and we hope to grow the network further in the next months.

The new website of APEX Evangelists is live which reflects the network now, you find it at

If you wondering what else the future will bring me, stay tuned or drop me an email at

ODTUG APEX Plug-In Competition

As Martin has already announced, there is a very exciting APEX Plugin Competition hosted by ODTUG.

Here’s the official announcement (taken from the ODTUG page):

ODTUG is holding its first ever world wide APEX Plug-ins competition! This is your opportunity to write an APEX plug-in and have it viewed by the entire international APEX community and maybe crowned 2012 ODTUG APEX Plug-in Developer of the Year! Even better, there are some really great prizes with the grand prize being a free pass to Kscope13 or a Jawbone Jambox!

This is an opportunity for you to not only win some cool prizes but also to show just what is possible with APEX plugins (and don’t worry if you’re a beginner in APEX, there is a separate Experts category to make sure that everyone is judged as equally as possible).