mysqlidxchk (MySQL Index Checker) checks MySQL databases/tables for
unused indexes. Given one or more slow, general, or "raw" log files,
mysqlidxchk reports which indexes in the database schema are not used
by the queries in the log files.
This perl library contains functions for dealing with databases. It's
mainly used as the foundation for all the other Relations modules. It
may be useful for people that deal with databases in Perl as well.
Relations has functions for creating SQL clauses (like where, from etc.)
from hashes, arrays and strings. It also has functions for converting
strings to arrays or hashes, if they're not hashes or arrays already. It
even has an argument parser, which is used quite heavily by the other
Relations modules.
postgresql-relay can be used to as a single point of origin for all
your databases. Instead of having to remember (or modify in case
of changes) all the names of your databases, on which machines and
on which ports they are running, you only need to remember one
machine and the name of the database. The postgresql-relay will
then forward the connection to the proper database on the proper
port of the proper server. No more changes in the hundreds of clients
and scripts!
Tangram is an object-relational mapper. It makes objects persist in relational
databases, and provides powerful facilities for retrieving and filtering them.
Tangram fully supports object-oriented programming, including polymorphism,
multiple inheritance and collections. It does so in an orthogonal fashion,
that is, it doesn't require your classes to implement support functions nor
inherit from a utility class.
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.
A script to take daily, weekly and monthly backups of your MySQL
databases using mysqldump.
Features:
- Backup multiple databases
- Single backup file or to a separate file for each DB
- Compress backup files
- Backup remote servers
- E-mail logs
This is an API for using Perl5 to access PostgreSQL databases.
This software is part of the standard PostgreSQL distribution.
GeoAlchemy is an extension of SQLAlchemy. It provides support for Geospatial
data types at the ORM layer using SQLAlchemy. It aims to support spatial
operations and relations specified by the Open Geospatial Consortium (OGC).
OpenDBX is an extremely lightweight but extensible C library for
accessing databases with a single API. It provides a clean and simple
interface across all supported databases that leads to an elegant
code design automatically. Currently MySQL, PostgreSQL, SQLite
(v2 & 3), MSSQL and Sybase are supported and backends for more native
database APIs can be written easily. If you want your application to
support different databases with little effort, this is definitively
the right thing for you!
License: LGPL
db allows manipulation of btree(3) and hash(3) (db(3)) databases.
See NetBSD Problem Report #39254
(http://www.netbsd.org/cgi-bin/query-pr-single.pl?number=39254) for
the issues with the version 1.15 and higher.