Skip to main content

a simple connection manager for connecting to various rdbms (mostly legacy)

Project description

a connection manager for python for connecting to various databases.

supported databases:

  • oracle

  • netsuite

  • mssql

  • mysql

  • vertica

  • redshift

  • postgres

  • db2 i-series

overview

concentric is based off of waddle for secrets management, which means it is strongly coupled to aws kms for its key management.

quick start

  1. create a waddle configuration file:

    oracle:
      host: localhost
      user: scott
      password: tiger
      sid: xe
  2. waddle in the password for security:

    waddle add-secret -f /path/to/config.yml oracle.password
  3. use it:

    from concentric.managers import CachingConnectionManager as ccm
    
    conn = ccm.connect('oracle')
    with conn.cursor() as cursor:
        cursor.execute('select sysdate as dt from dual')
        results = cursor.fetchall()

contributing

Sample configuration files:

  1. db2

  2. hp3000

  3. mysql

  4. netsuite

  5. oracle

  6. postgres

  7. redshift

  8. snowflake

  9. sql server

  10. vertica

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

concentric-0.6.tar.gz (11.9 kB view hashes)

Uploaded Source

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page