Dr John A StevensonJul 10, 2024

ETL Helper is a Python ETL (Extract, Transform, Load) library to simplify data transfer into and out of databases.
It makes it easier to run #SQL queries via #Python.

This month we released Version 1. 🥳

One of the biggest changes is a proper documentation site. Check it out:

https://britishgeologicalsurvey.github.io/etlhelper/

#etlhelper #oracle #postgresql #sqlite #database #gis #opensource 1/3

Welcome to ETL Helper’s documentation! — ETL Helper 1.0.0 documentation

Show threadBruno Girin
@volcan01010 nice! Can users add custom support for other databases? I've got a use case where I'd like to do that but from a MongoDB collection rather than a SQL table.
Jul 10, 2024 at 12:08pmWeb
Show threadDr John A StevensonJul 10, 2024

@brunogirin
ETLHelper is based on Python's DBAPI2 specification that defines how a database driver should work: https://www.python.org/dev/peps/pep-0249/

It is possible to add support for any other DBAPI2 compliant database. Unfortunately, it looks like PyMongo has a different API.

PEP 249 – Python Database API Specification v2.0 | peps.python.org

This API has been defined to encourage similarity between the Python modules that are used to access databases. By doing this, we hope to achieve a consistency leading to more easily understood modules, code that is generally more portable across datab...

Python Enhancement Proposals (PEPs)