Pythonic Database Connector

The Pythonic Database Connector package (aka py-dbcn) is a connector to allow Pythonic interaction with multiple database types.

The main original purpose of this package is to allow for an easier way to read in and migrate data between databases, such as during a database upgrade.

The idea is to create a package that allows quick and easy interfacing to the database of choice, using a simple Pythonic interface. No need to necessarily know the quirks of each database type, as long as you have a general idea of what database logic is required. This package will handle the details from there.

Due to being written in Python, this package allows having a easily-repeatable set of database calls, which can be thoroughly tested and examined via the standard Python library, to ensure maximum database integrity at every step of the way.

Note

Currently, this is only implemented for MySQL and PostgreSQL.

There are plans to at least implement this for SqLite as well.

Contents:

• Quickstart
• Creating Queries
  • Database Querying
  • Table Querying
  • Record Querying
• Configuration

Versions:

• Expected Roadmap
• Version History

Supplementary Documentation

• SqLite Syntax
• MySQL Syntax
• PostgreSQL Syntax

Indices and tables

• Index

• Module Index

• Search Page