By taking the busy work out of using Class::DBI as you see fit, your code
becomes more useful by size. Most of us end up using at least a couple
Class::DBI extensions in our programs, and it's just a pain. Enter the Swiss
Army Knife.
DBD::PgPP is a Pure Perl client interface for the PostgreSQL database.
It implements the PostgreSQL client/server network protocol and doesn't
need an external PostgreSQL client library like "libpq" for it to work.
Consequently, it allows one to connect to a PostgreSQL server from
operating systems to which PostgreSQL has not been ported.
DBIx::Class::Schema::Config is a subclass of DBIx::Class::Schema that
allows the loading of credentials from a file. The actual code itself
would only need to know about the name used in the configuration file.
This aims to make it simpler for operations teams to manage database
credentials.
PEAR MDB is a merge of the PEAR DB and Metabase php database abstraction layers.
It provides a common API for all support RDBMS. The main difference to most
other DB abstraction packages is that MDB goes much further to ensure
portability.
Currently supported RDBMS are MySQL, PostGreSQL, Oracle, Frontbase, Querysim,
Interbase/Firebird, and MSSQL
Percona Toolkit is a collection of advanced command-line tools used by Percona
support staff to perform a variety of MySQL and system tasks that are too
difficult or complex to perform manually, including:
Verify master and replica data consistency
Efficiently archive rows
Find duplicate indexes
Summarize MySQL servers
Analyze queries from logs and tcpdump
Collect vital system information when problems occur
pgtop was inspired by mytop (http://jeremy.zawodny.com/mysql/mytop/),
which in turn was inspired by the system monitoring tool top.
pgtop will connect to a PostgreSQL server and periodically
run queries against the pg_stat* relations and attempt
to summarize the information from them in a useful format.
pg8000 is a Pure-Python interface to the PostgreSQL database
engine. It is one of many PostgreSQL interfaces for the Python
programming language. pg8000 is somewhat distinctive in that
it is written entirely in Python and does not rely on any
external libraries (such as a compiled python module, or
PostgreSQL's libpq library). pg8000 supports the standard
Python DB-API version 2.0.
MySQLDumper is a PHP and Perl based tool for backing up MySQL databases.
You can easily dump your data into a backup file and, if needed, restore it.
It is especially suited for shared hosting webspaces, where you don't have
shell access. MySQLDumper is an open source project and released under the
GPLv2 license.
pylibmc is a client in Python for memcached. It is a wrapper around
TangentOrg's libmemcached library.
The interface is intentionally made as close to python-memcached as possible,
so that applications can drop-in replace it.
pylibmc leverages among other things configurable behaviors, data pickling,
data compression, battle-tested GIL retention, consistent distribution, and
the binary memcached protocol.
The Python SQL Toolkit and Object Relational Mapper
SQLAlchemy is the Python SQL toolkit and Object Relational Mapper that
gives application developers the full power and flexibility of SQL.
It provides a full suite of well known enterprise-level persistence
patterns, designed for efficient and high-performing database access,
adapted into a simple and Pythonic domain language.