Connection Request Queuing with the Node.js Driver

By | Uncategorized | 6 Comments

I recently made an assumption about how requests for connections were handled by the Node.js driver. You know what they say about assumptions, right? 😀 In the Node.js driver, developers can create connection pools. A connection pool has settings, such as the minimum and maximum number of connections, and methods that allow you to get connections and release them.
Read More

An Overview of Result Sets in the Node.js Driver

By | Uncategorized | 9 Comments

I’m happy to announce that version 0.7.0 of the Oracle Database driver for Node.js was released earlier this week! Checkout Chris Jones’ post for a rundown on the various changes in that release. In this post, I’ll be diving into my favorite new feature: the ResultSet class.

Result sets are great for huge queries or when you don’t know how many rows will be returned. And how often do you really know how many rows will be returned from a query? Probably not very often, which is why I highly recommend using result sets as the default means through which you execute queries with the Node.js driver.
Read More

Relational to JSON in Oracle Database

By | Uncategorized | 14 Comments

More and more often these days, front-end developers want their data in JSON format. And why not? JSON is a simple data-interchange format that’s lightweight and easy to use. Plus, many languages now provide a means of parsing and converting JSON data into native object types. However, not all data is best persisted in JSON format. For many applications, the relational model will be the best way to store data. But can’t we have the best of both worlds? Of course!
Read More

Authentication with Node.js, JWTs, and Oracle Database

By | Uncategorized | 12 Comments

Authentication isn’t exactly hard, it’s just that there are a lot of moving pieces to consider. Should you provide local authentication or 3rd party authentication via identity providers such as Google and Facebook? Can you reuse an existing credential store like Active Directory? What libraries should you use to help you encrypt passwords and manage logins? Should you use cookie based authentication with sessions or use the emerging JSON Web Token (JWT) standard instead. Are there libraries for JWTs? Which is the best? Okay fine, authentication is hard. But it’s also necessary.
Read More

A Look Back at COLLABORATE15

By | Uncategorized | No Comments

I spent last week in Las Vegas for COLLABORATE15. Having never been to Vegas before, my wife and I decided to go a little early to enjoy the city. That turned out to be a really good idea (if you don’t count the money I lost) because once the conference got underway I never really made it back out to the strip… COLLABORATE keeps one busy!
Read More

Postman test

To JavaScript, or Not to JavaScript, That is the Question

By | Uncategorized | One Comment

I should probably start this post off by stating that I LOVE JAVASCRIPT! But I will also confess that I am NOT a monoglot! I’ve studied various programming languages over the years to varying degrees. Most languages (as well as tiers, libraries, frameworks, and platforms) have sweet spots where they excel. Often times it can be tempting to use one language over another because that’s the one you know best. However, this type of thinking can eventually lead to performance, scalability, maintenance, and a number of other issues. In this post we’ll explore an example of how a little knowledge of PL/SQL can help keep your JavaScript/Node.js code neat and clean while providing some nice performance benefits!
Read More