Hi, I'm pleased to announce the release of ETL Helper v1.
""" ETL Helper makes it easy to run SQL queries via Python and return the results. It takes care of cursor management, importing drivers and formatting connection strings, while providing memory-efficient functions to read, write and transform data. This reduces the amount of boilerplate code required to manipulate data within relational databases with Python. """ Version 1 includes a documentation website: https://britishgeologicalsurvey.github.io/etlhelper/ See the release notes for breaking and non-breaking changes: https://github.com/BritishGeologicalSurvey/etlhelper/releases/tag/v1.0.0 Highlights for version 1 include: + replace cx_Oracle with python-oracledb driver + dictionaries as the default row factory + closer alignment with DBAPI methods + type hints Cheers, John p.s. any feedback on the library from members of this group would be most welcome. John A Stevenson PhD MSci FGS Senior Software Developer e jos...@bgs.ac.uk<mailto:jos...@bgs.ac.uk> w www.bgs.ac.uk<http://www.bgs.ac.uk/> o orcid.org/0000-0002-2245-1334<https://orcid.org/0000-0002-2245-1334> British Geological Survey | The Lyell Centre | Research Avenue South | Edinburgh EH14 4AP | UK [cid:image001.png@01DAD2CF.A61B6F50] This email and any attachments are intended solely for the use of the named recipients. If you are not the intended recipient you must not use, disclose, copy or distribute this email or any of its attachments and should notify the sender immediately and delete this email from your system. UK Research and Innovation (UKRI) has taken every reasonable precaution to minimise risk of this email or any attachments containing viruses or malware but the recipient should carry out its own virus and malware checks before opening the attachments. UKRI does not accept any liability for any losses or damages which the recipient may sustain due to presence of any viruses.
_______________________________________________ DB-SIG maillist - DB-SIG@python.org https://mail.python.org/mailman/listinfo/db-sig
