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
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
We added a new JavaScript layer in the last release of the Node.js driver for Oracle Database. It added just one feature (connection request queueing) and didn’t include any API changes. However, there are currently two features being worked on that could bring such changes: ResultSet Streaming and Optional Promise Support.
Read More
Today is a big day for JavaScript and Oracle for 2 reasons:
- The Oracle Database driver for Node.js has a new JavaScript layer
- 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
Want to start working with Node.js and Oracle Database in a local sandbox? It’s easier than you might think. Thanks to some prebuilt VMs provided by Oracle, you can have such an environment up and running in less than 20 minutes – excluding download times, of course! 🙂
Read More
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
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
Node.js is a platform for building JavaScript based applications that has become very popular over the last few years. To best support this rapidly growing community, Oracle developed a new driver for Node.js which was released in January of this year as a preview release. Written in C and utilizing the Oracle Instant Client libraries, the Node.js driver is both performant and feature rich.
Read More
Oracle REST Data Services (ORDS) was first released back in 2010 as the APEX Listener. REST support for JSON actually wasn’t added until version 1.1 in 2011. Then in 2014, the product was renamed to Oracle REST Data Services to emphasize the commitment to REST.
Read More
APEX_JSON is a new PL/SQL API included with Oracle Application Express (APEX) 5.0 that provides utilities for parsing and generating JSON. While APEX_JSON was primarily intended to be used by APEX developers, there are some hooks that can allow it to be used as a standalone PL/SQL package.
Read More
RECENT COMMENTS