An Update on JavaScript and Oracle

By | Uncategorized | 2 Comments

Today is a big day for JavaScript and Oracle for 2 reasons:

  1. The Oracle Database driver for Node.js has a new JavaScript layer
  2. Oracle JavaScript Extension Toolkit (JET) is now open source

When I took my job at Oracle as a JavaScript Developer Advocate, I didn’t know exactly what to expect. JavaScript in a database company, really? But as time went on the list of JavaScript based initiatives I stumbled upon just grew and grew. Now the problem is trying to keep up with them all!
Read More

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