SODA for Python

SODA for Python is a Python API that implements Simple Oracle Document Access (SODA). It is part of the Oracle Python driver, python-oracledb (in Thick mode).

You can use SODA for Python to perform create, read (retrieve), update, and delete (CRUD) operations on documents of any kind, and you can use it to query JSON documents.

SODA is a set of NoSQL-style APIs that let you create and store collections of documents (in particular JSON) in Oracle Database, retrieve them, and query them, without needing to know Structured Query Language (SQL) or how the documents are stored in the database.

Regardless of the SODA implementation language you use, the general concepts are the same, and much of the reference material is the same. All such common information is in Introduction to Simple Oracle Document Access (SODA). Here are quick links to some of the conceptual material:

• Overview of SODA

• Overview of Querying By Example (Filtering)

• Overview of Indexing