concentric 0.7

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

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