Data handling techniques in Python for Database

on YouTube ↗33m

" summary

Practical how-to on using cx_Oracle 8.2 for real workloads: improved dead-connection detection (check for DPI-1080), session pools with a one-time session callback to set NLS, and wallet-based connections to Autonomous Database. Shows tuning that cuts round-trips by adjusting prefetch/arraysize, a measured test where looping INSERTs take ~3s vs executemany 0.09s, handling noisy batches with batcherrors and offsets, CSV loads in 10,000-row chunks with setinputsizes, and a coming thin driver option.

AI-written summary · about

" chapters (16)

1. 0:00Start
2. 0:27Architecture of the Cx Oracle Module for Python
3. 3:29Jupiter Notebook
4. 3:42Connections
5. 4:30Oracle Instant Client
6. 6:23Syntax
7. 7:37Standard Connections
8. 7:59Pooled Connections
9. 10:46Fixed Size Pool
10. 13:30Autonomous Database
11. 16:03Queries
12. 16:50Fetching Rows
13. 17:59Round Trips
14. 23:21Benchmark
15. 26:05Comma Separated Values
16. 31:26Driver for Python

" related talks

• 42mEfficient Data Handling Techniques in Python for Oracle DatabaseChristopher Jones · PyConZA 2021
• 30mLeverage connection pooling and multiplexing for performance and scalabilitySHARAD CHANDRAN · Oracle CloudWorld 2022
• 33mTips and tricks for the Oracle Database developerJeff Smith · Oracle CloudWorld 2022
• 30mWrite scalable SQL with Oracle Autonomous DatabaseChris Saxon · Oracle CloudWorld 2022
• 59mIntroduction to Python Database ProgrammingMarc-André Lemburg · EuroPython 2011
• 32mExploring the latest open-source Python API for Oracle Database applicationsChristopher Jones · Oracle CloudWorld 2022
• 50mSupercharge your Code to Get Optimal Database PerformanceGerald Venzl · JCON 2020
• 15mUsing Oracle Tech for Digital Inclusion in Rural AreasVasipally Nagireddy · Site Reliability Engineering (SRE) 2025