Recent Posts by Christopher Jones

Things change fast and it's time for an update on running Node.js in Docker. Let's dive right in. Here's a Dockerfile that pulls the lightweight Oracle Linux "slim" image, installs the latest Node.js runtime, and installs the Oracle Client libraries needed for the node-oracledb module. Note no Docker store login or manual downloads are required: FROM oraclelinux:7-slim RUN yum -y install oracle-release-el7 oracle-nodejs-release-el7 && \ yum-config-manager --disable...

Oracle Instant Client 12.2 for macOS can now be downloaded for free from OTN. This release is for 64 bit only. It supports: MAC OS X 10.13, High Sierra MAC OS X 10.12, Sierra MAC OS X 10.11, El-Capitan Install instructions are at the end of the download page. Instant Client contains libraries and tools allowing applications to connect to a local or remote Oracle Database for development and production deployment. And if you haven't caught up with the news, Instant Client 12.2 now...

Oracle Instant Client 19.3 for z/Linux is on OTN here.  I had a few comments here about 19.3.

Oracle Instant Client 19.3 for Microsoft Windows (x64) 64-bit is available from OTN. Oracle Instant Client comprises tools, libraries and SDKs for building and connecting applications to Oracle Database. I had a few comments here about 19.3 that you may want to check. Windows Compilers and SDKs The following components are supported with the compilers based on Microsoft Visual C++ 2017 Update 6 or later and Intel C++ 17.0 Update 8, and Microsoft Visual C++ 2017 Update 6 or later...

A quick announcement: Oracle Instant Client 19.3 is now available on OTN for: AIX (PPC64) AIX (PPC32) HP-UX Itanium (64-bit) HP-UX Itanium (32-bit) Oracle Instant Client comprises tools, libraries and SDKs for building and connecting applications to Oracle Database. I had a few comments here about 19.3.

ROracle 1.3-2, the DBI-compliant driver for R and Oracle Database, has been released. R is a powerful statistical language. ROracle can be used with Oracle Database to perform sophisticated analysis. Many users are also using it as part of Oracle R Enterprise, ROracle 1.3-2 source code, documentation, and binaries (built for R-3.6.0 on Linux and Windows) are available for ROracle on OTN. This patch update isn't on CRAN due to an ongoing issue with CRAN infrastructure. Don't...

This is a GraphQL demo that stores data in an Oracle Database SODA collection. GraphQL is a query language for services. Oracle Database SODA is a NoSQL-like API for storing documents in Oracle Database. The demo follows on from my previous "Demo: GraphQL with Oracle Database and node-oracledb" which shows the same demonstration using relational tables and SQL queries. Read that post to learn about GraphQL and GraphQL queries. Also see the associated SODA presentation Getting...

Good news - Oracle Instant Client 19.3 is available for Linux on OTN and yum. A Docker file is also available on GitHub. Oracle Instant Client comprises tools, libraries and SDKs for building and connecting applications to Oracle Database. It comes in a number of packages: 'Basic' and 'Basic Light' packages provide a cornerstone, and additional packages can be installed to get extra functionality. Typical uses of Instant Client are for Oracle Database APIs like Python cx_Or...

    cx_Oracle 7.1, the extremely popular Oracle Database interface for Python, is now Production on PyPI.   Another great release of cx_Oracle is available from PyPI, this time with a focus on session pooling. There were also a number of incremental improvements and fixes, all detailed in the release notes. Session Pooling When applications use a lot of connections for short periods, Oracle recommends using a session pool for efficiency. The session pool is a pool of connections...