Working with Dates Using the Node.js Driver

By | Uncategorized | No Comments

Node.js is an excellent platform for creating RESTful APIs that store and retrieve data using Oracle Database. node-oracledb is the driver maintained by Oracle that allows Node.js developers to connect to and utilize the database. As data crosses the boundaries between JavaScript and Oracle Database, the driver automatically converts it to native data types on either end. This post explores how that conversion process works for datetime values.
Read More

dates-in-js-json-oracle

Working with Dates in JavaScript, JSON, and Oracle Database

By | Uncategorized | No Comments

When I wrote a series of posts on creating JSON from relational data, I mentioned that dates could be tricky. That was a bit of an understatement. Dates, and the time zone conversions that often go along with them, can be outright daunting!

In this series, I hope to shed some light on the subject of dates in the context of JavaScript, JSON, and Oracle Database. As in the previous series, I’ll base things on a RESTful API scenario. The focus here will be on tracking a date from the browser to the database and then back from the database to the browser.
Read More

An Update on JavaScript and Oracle

By | Uncategorized | No 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

queue

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

data-flow

An Overview of Result Sets in the Node.js Driver

By | Uncategorized | 2 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