Recent Posts by Blaine Carter

Create an Oracle Autonomous Transaction Processing instance with the Python SDK for Oracle Cloud Infrastructure. By Blaine Carter July/August 2019 You’ve been working with Oracle Autonomous Transaction Processing, using the web dashboard, and now you’re ready to automate the process. This article demonstrates how to create a new Oracle Autonomous Transaction Processing instance in your Python application, using the Python SDK for Oracle Cloud Infrastructure. (You can refer to...

Connect to Oracle Autonomous Transaction Processing with multiple programming languages. By Blaine Carter May/June 2019 By now you’ve probably heard about Oracle Autonomous Transaction Processing. If not, follow the link for more information. One major feature of Oracle Autonomous Transaction Processing is enhanced security. For example, Oracle Autonomous Transaction Processing uses machine learning and automation to improve its own security, but it also takes advantage of an...

Use Python for PL/SQL operations in Oracle Database. By Blaine Carter November/December 2018 After you’ve gotten the hang of performing basic create, retrieve, update, delete (CRUD) operations with the cx_Oracle driver for Python, you’re ready to start tapping into some of the real power of Oracle Database. Python is an excellent language for most things you want your application to do, but when you’re processing data, it just goes faster if you do the work where the data is. This...

Here’s how to use Python for CRUD operations in Oracle Database. By Blaine Carter July/August 2018 Python is a powerful open source language, and the cx_Oracle driver gives your Python application access to the full power of Oracle Database. This article series takes a look at how to perform create, retrieve, update, and delete (CRUD) operations in Python with the cx_Oracle driver. Part 1 of this series included setup information and examples for create: the C in CRUD. Part 2...

Here’s how to use Python for CRUD operations in Oracle Database. By Blaine Carter July/August 2018 Python is a powerful open source language, and the cx_Oracle driver gives your Python application access to the full power of Oracle Database. In this article series, I’m going to take a look at how to perform CRUD (create, retrieve, update, and delete) operations in Python with the cx_Oracle driver. Part 1 of this series included setup information and examples for create: the C in C...

Here’s how to use Python for CRUD operations in Oracle Database. By Blaine Carter May/June 2018 Python is a powerful open source language, and the cx_Oracle driver gives your Python application access to the full power of Oracle Database. In this article series, I’m going to take a look at how to perform CRUD (create, retrieve, update, and delete) operations in Python with the cx_Oracle driver. Part 1 of this series included setup information and examples for create: the C in CRUD...

Here’s how to use Python for CRUD operations in Oracle Database. By Blaine Carter February 15, 2018 Python is a powerful open source language, and the CX_ORACLE driver gives your Python application access to the full power of Oracle Database. In this article series, I’m going to take a look at how to perform CRUD (create, retrieve, update, delete) operations in Python using the cx_Oracle driver. This initial article will include setup instructions for the series as well as...

Use open source tools to handle database change management. By Blaine Carter May/June 2017 Oracle Database offers a powerful foundation on which to build and manage applications. And because applications are constantly changing, the underlying databases supporting those applications must also change. How do you manage these changing databases? The obvious answer is or should be, “Just check the SQL scripts into my version control system.” That works pretty well, right up until...