PinnedPublished inLevel Up CodingOpen Source Python Thin Driver for Oracle DatabaseA new major Python cx_Oracle driver release is available and comes with a brand new name, python-oracledb. This is very exciting news.May 25, 20221May 25, 20221
node-oracledb 6.7 and ROracle 1.5 releasesMy team has released node-oracledb 6.7 and ROracle 1.5 drivers for Oracle Database. Check out the release blog posts:Nov 19, 2024Nov 19, 2024
Published inOracle DevelopersUsing Pipelining for Efficient Schema CreationSupport for Oracle Database 23ai Pipelining is one of the fun features of python-oracledb. Recently I’ve been using it for schema creation…Nov 13, 2024Nov 13, 2024
Python-oracledb 2.5 brings greater flexibility to Oracle Database appsPython-oracledb 2.5, the extremely popular Oracle Database interface for Python, is now on PyPI.Nov 5, 2024Nov 5, 2024
Using Django Connection PoolingThere are so many applications where database connection pooling makes sense, including web sites which have many users. I’ve written…Oct 30, 2024Oct 30, 2024
Published inOracle DevelopersPipelined database operation performance redux with python-oracledb: very impressiveIn Pipelined database operations with python-oracledb 2.4 I gave a simple benchmark showing the performance benefit of Oracle Database 23ai…Sep 12, 20241Sep 12, 20241
VirtualBox 7.1 supports macOS ARM64 hostsA quick post: the latest VirtualBox adds Apple macOS ARM64 host support !Sep 12, 2024Sep 12, 2024
Published inOracle DevelopersPipelined database operations with python-oracledb 2.4Python-oracledb 2.4 introduces pipelining functionality to improve the performance and scalability of your Python applications for Oracle…Aug 20, 2024Aug 20, 2024
Python-oracledb 2.4 has been releasedPython-oracledb 2.4, the extremely popular Oracle Database interface for Python, is now on PyPI.Aug 20, 2024Aug 20, 2024
Published inOracle DevelopersQuery result caching for fast database applicationsOracle Database’s built-in “Client Result Cache” is an efficient, integrated, managed cache that can dramatically improve query performance…Aug 15, 2024Aug 15, 2024
Published inOracle DevelopersInstalling Oracle Instant Client for Apple macOS ARM64 (M1/M2/M3)In case you missed it, Oracle Instant Client is available for macOS ARM64. See the release announcement post by my colleague Sharad…Aug 1, 2024Aug 1, 2024
PHP OCI8 3.4 is available from PECLI’ve just released PHP OCI8 3.4 on PECL. PHP is still active and going strong — and this is reflected in the download numbers for the…Jul 25, 2024Jul 25, 2024
python-oracledb 2.3 is even smaller on Linuxpython-oracledb 2.3 has been released. My colleague @Veronica Dumitriu has posted the release announcement. There are lots of good…Jul 24, 2024Jul 24, 2024
Published inOracle DevelopersInstallation Cheatsheet for Oracle Instant Client on Oracle LinuxWondering how to install Oracle Instant Client on Oracle Linux from Oracle’s yum repository? This is what you need to know.Jul 12, 2024Jul 12, 2024
Published inOracle DevelopersThe best of Relational and JSON — at the same timeOracle Database 23ai JSON-Relational Duality Views allow data to be stored as rows in tables to provide the benefits of SQL access in a…Jul 11, 2024Jul 11, 2024
Published inOracle DevelopersUsing the %ROWTYPE attribute with python-oracledbWhen using Python to interact with Oracle Database PL/SQL stored procedures, you may encounter PL/SQL code that uses the %ROWTYPE…Jul 6, 2024Jul 6, 2024
Oracle Application Continuity — for continuous availabilityApplications need to be resilient to infrastructure glitches. Oracle Database has powerful features that help your users get their jobs…Jun 27, 2024Jun 27, 2024
Technical Briefs on VECTOR with python-oracledb and node-oracledbFor those that like ‘official’ things, technical briefs Using Oracle Database 23ai Vectors in python-oracledb and Using Oracle Database…Jun 21, 2024Jun 21, 2024
Published inOracle DevelopersImplicit Connection Pooling when connections overload your databaseWhen a long-running application keeps a database connection open for the app lifetime, it is likely that the connection is often idle and…Jun 18, 2024Jun 18, 2024
Published inOracle DevelopersDRCP helps apps that don’t use a Connection PoolApplication connection pooling is a key technology for improving performance and scalability. Another technology, Oracle’s Database…Jun 10, 2024Jun 10, 2024