Node.js driver for Oracle Database
This is the driver that allows folks using Node.js to tap into Oracle Database – a fun combination.
Since starting at Oracle, I’ve focused more on this project than any other. In fact, most of the posts in this blog involve this driver in one way or another.
Application Container Cloud
The Application Container Cloud is one of the newer services in Oracle Cloud. It provides the ability to provision both Java and Node.js based runtime application containers. The amount of RAM available to the containers can be scaled dynamically on demand. This service is a welcome addition to Oracle Cloud and I look forward to seeing how it develops over time.
- Application Container Cloud Service
- Video from Chris Jones that demonstrates how to connect Node.js to Oracle Database in the cloud
JSON in Oracle Database
The conditions allow users to ensure that data going into a column is valid JSON (strict or lax) and the functions allow data to be parsed out using JSON path expressions.
My favorite of the new functions is JSON_TABLE, which can be used to create relational style views on top of JSON data. This allows people that know SQL to leverage their existing knowledge with JSON data. Additionally, it allows various tools that require SQL and relational constructs to keep working as they always have regardless of how the data is stored.
- Documentation on JSON features in Oracle Database 18.104.22.168
- Video from Mark Drake introducing these JSON capabilities
Graal, Truffle, & Graal.js
SQLcl can be though of as a modern version of SQL*Plus, the command line interface for Oracle Database. Not to take anything away from SQL*Plus, it’s the go to choice for most Oracle DBAs for good reason, but many developers have been looking for a similar tool with more modern features that enhance their development workflow. This is that tool.
SQLcl is written in Java and is based on some of the code in SQL Developer that was added to support SQL*Plus code. So despite the fact that SQLcl is currently only available as an Early Adopter release, it’s actually quite stable and robust.
- SQL Developer Home page (see the Downloads tab)
What makes JET standout is its rich set of UI components, which include a number of data visualizations (charts, maps, etc.) that are fully responsive. JET is built for use in enterprises and includes built-in support for accessibility and internationalization. Because JET takes a modular approach, developers are able to swap out various pieces of the toolkit to better suit their needs.