Skip to main content

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
  1. waddle in the password for security

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

from concentric.managers import setup_concentric
from concentric.managers import CachingConnectionManager as ccm

setup_concentric('/path/to/waddle_config.yml', '/path/to/another_config.yml')
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

Download files

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

Source Distribution

concentric-1.5.tar.gz (14.5 kB view details)

Uploaded Source

File details

Details for the file concentric-1.5.tar.gz.

File metadata

  • Download URL: concentric-1.5.tar.gz
  • Upload date:
  • Size: 14.5 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/7.0.0 CPython/3.11.14

File hashes

Hashes for concentric-1.5.tar.gz
Algorithm Hash digest
SHA256 8d35e9555c0e3209195d5658416316b0ea43848beeea898361fc78d776401d46
MD5 c5c151024ae38f4398331052741981f3
BLAKE2b-256 dd1c29d32b30d187cb853eb7bf14c1a23c5beb4dea51feacae66aa4edb0d69de

See more details on using hashes here.

Release history Release notifications | RSS feed

This release

1.5 This release

1 file

1.4

1 file

1.3

1 file

1.2

1 file

1.1

1 file

1.0

1 file

0.14

1 file

0.13

1 file

0.12

1 file

0.11

1 file

0.10

1 file

0.9

1 file

0.8

1 file

0.7

1 file

0.6

1 file

0.5

1 file

0.4

1 file

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page