Exploring the latest open-source Python API for Oracle Database applications

on YouTube ↗32m

" summary

python-oracledb adds a Thin mode default that removes the need for Oracle Client libraries so pip install yields a usable driver (~15 MB install on macOS versus ~242 MB for Instant Client), supports Apple Silicon and small containers, and reports meaningful runtime wins (benchmarks show lower latency and a quoted 60% CPU benefit in some cases). Most frameworks work with the new namespace; Thick mode (extra features like AQ, App Continuity) requires calling init_oracle_client and installing Instant Client.

AI-written summary · about

" chapters (9)

1. 0:00Intro
2. 0:37The popular language ecosystems
3. 8:33Atomic performance tests
4. 16:13Upgrading cx Oracle code
5. 20:04Thin connection parameters replace Thick Client settings
6. 21:21Thin mode: Mutual TLS with Oracle Autonomous Database
7. 22:39Thin mode: Connection pooling and DRCP
8. 26:20Thin mode Globalization: Locale type handler
9. 29:51Summary

" related talks

• 33mData handling techniques in Python for DatabaseChristopher Jones · Oracle DatabaseWorld 2021
• 42mEfficient Data Handling Techniques in Python for Oracle DatabaseChristopher Jones · PyConZA 2021
• 20mPython + Oracle = Prosperity & PerformanceTodd Trichler · EuroPython 2011
• 20mPython + Oracle = Prosperity & PerformanceTodd Trichler · EuroPython 2011
• 31mODBC takes an Arrow to the knee: ADBCMatthew Topol · Øredev 2024
• 08mOracle Database@AzureKaran Batta, Madhan Arumugam Ramakrishnan · Oracle CloudWorld 2023
• 23mFull Stack Development Using Oracle 23aiDoug Drechsel · React Summit 2024
• 29mDatabase: What's new, what's nextJenny Tsai-Smith · Oracle DatabaseWorld 2021