libdbi-drivers - drivers for libdbi, a database abstraction
layer implemented in C
Copyright (C) 2001-2013, Markus Hoenicka
http://libdbi-drivers.sourceforge.net


INTRODUCTION:
-------------

libdbi (http://libdbi.sourceforge.net) implements a
database-independent abstraction layer in C, similar to the DBI/DBD
layer in Perl. Writing one generic set of code, programmers can
leverage the power of multiple databases and multiple simultaneous
database connections by using this framework.

libdbi-drivers (http://libdbi-drivers.sourceforge.net) supplies the
drivers that the libdbi framework utilizes to talk to the supported
database servers.


INSTALLATION:
-------------

Make sure you have both the libdbi framework installed and the
development libraries and headers of the database engine(s) that you
want to build the driver(s) for. Perform the regular ./configure,
make, make install. See INSTALL for the generic details of each
step. It is important to understand that you have to request the
driver(s) that you want to build on the configure command
line. E.g. to build both the SQLite and the PostgreSQL drivers, use
"./configure --with-sqlite --with-pgsql". See ./configure --help for
more libdbi-drivers configuration options.

If you are building the Win32 port, see README.win32.
If you are building the OSX port, see README.osx.


AVAILABLE DRIVERS:
------------------

* DB2 (experimental)
* Firebird/Interbase (experimental)
* FreeTDS (experimental)
* Ingres (experimental)
* mSQL (experimental)
* MySQL
* Oracle (experimental)
* PostgreSQL
* SQLite
* SQLite3


SUPPORTED PLATFORMS:
--------------------

libdbi-drivers has been written with cross-platform availability in
mind. To date, chances are it is going to run with:

Linux: Debian, RedHat, Slackware, Gentoo
Windows: all versions supported by Cygwin
FreeBSD: 4.3 through 9.1
SunOS: 2.8
Solaris: 7
AIX: 4.2, 4.3 and 5.1
OSX: 10.2-10.4

If you are using libdbi on a platform not listed here, please notify the
mailing list! (see below)


MODIFICATIONS AND REDISTRIBUTION (LGPL):
----------------------------------------

See the GNU Lesser General Public License, available in the
distribution file COPYING or visit http://www.gnu.org for more
details.


DOCUMENTATION:
--------------

All driver subdirectories contain README, AUTHORS, and CHANGELOG files
with information about the particular driver. In addition, each driver
provides a short manual formatted as PDF and HTML.


MAILING LISTS:
--------------

 * libdbi-drivers users/developers: libdbi-drivers-devel@lists.sourceforge.net


CONTACT INFO:
-------------

http://libdbi-drivers.sourceforge.net
Markus Hoenicka <mhoenicka@users.sourceforge.net>
David Parker <david@neongoat.com>
$Id: README,v 1.12 2013/03/11 23:49:41 mhoenicka Exp $

Translation table for character encodings
The first column is what dbi_get_conn_encoding() returns. This is the preferred MIME
name, if available, otherwise another official name
Source for preferred MIME names and other official names:
http://www.iana.org/assignments/character-sets

$Id: README.encodings,v 1.2 2004/01/10 19:52:45 bhazer Exp $

MIME		pgsql		mysql		sqlite		oracle			msql
US-ASCII	SQL_ASCII	ascii				US7ASCII
EUC-JP		EUC_JP		ujis				JA16EUC,JA16EUCYEN
		EUC_CN
EUC-KR		EUC_KR		euc_kr
EUC-KR				euckr
		EUC_TW
UTF-8		UNICODE		utf8		UTF-8		UTF8
UTF-16
		MULE_INTERNAL
ISO-8859-1	LATIN1		latin1		iso8859
ISO-8859-2	LATIN2		latin2				WE8ISO8859P9
ISO-8859-3	LATIN3
ISO-8859-4	LATIN4
ISO-8859-9	LATIN5		latin5
ISO-8859-10	LATIN6
ISO-8859-13	LATIN7		latin7
ISO-8859-14	LATIN8
ISO-8859-15	LATIN9
ISO-8859-16	LATIN10
ISO-8859-5	ISO-8859-5
ISO-8859-6	ISO-8859-6					AR8ISO8859P6
ISO-8859-7	ISO-8859-7	greek
ISO-8859-8	ISO-8859-8	hebrew				IW8ISO8859P8
KOI8-R		KOI8		koi8_ru
KOI8-R				koi8r
KOI8-U				koi8_ukr
KOI8-U				koi8u
windows-1251	WIN		cp1251
IBM866		ALT
windows-1250			win1250
windows-1250			cp1250
windows-1256			cp1256
windows-1257			win1257
windows-1257			cp1257
IBM850				cp850
IBM852				cp852
IBM857								TR8PC857
IBM865				dos
IBM866				cp866
Big5				big5
GB2312				gb2312
Shift_JIS			sjis
ISO646-NO			danish
ISO646-HU			hungarian
GBK				gbk
ISO-10646-UCS-2			ucs2
DEC-MCS				dec8
TIS-620				tis620
hp-roman8			hp8
				czech
				german1
				swe7
				usa7
				estonia
				win1251ukr
				croat
				armscii8
				keybcs2
				macce
				macroman
				binary
				geostd8

libdbi-drivers - drivers for libdbi, the Database
Independent Abstraction Layer for C

Copyright (C) 2001-2003, Markus Hoenicka
http://libdbi-drivers.sourceforge.net


OS X-SPECIFIC INSTALLATION INSTRUCTIONS:
----------------------------------------

(Tested on 10.4.9/PowerPC)

	LIBTOOLIZE=glibtoolize ./autogen.sh
	./configure --disable-docs --with-mysql --with-pgsql --with-sqlite --with-pgsql-dir=/opt/local/pgsql LDFLAGS="-L/sw/lib"
	make
	sudo make install

Adjust configure options and paths according to which databases you are
using, and where their headers and libraries are installed.


QUICKSTART - MYSQL
------------------
If you are using the MySQL.com Community[1] or Enterprise[2] package,
or a source install in the default location:

	sudo ln -s /usr/local/mysql/include /usr/include/mysql
	./configure --with-mysql --with-mysql-dir=/usr/local/mysql --disable-docs
	make
	sudo make install

[1] http://dev.mysql.com/downloads/
[2] https://enterprise.mysql.com/software/enterprise.php


QUICKSTART - POSTGRESQL
-----------------------
There are several options for installing PostgreSQL on OS X, including:
- Marc Liyanage's package at http://www.entropy.ch/software/macosx/postgresql/
- Druware's package at http://postgresqlformac.com/
- Fink package manager, see http://developer.apple.com/internet/opensource/postgres.html

If using the entropy.ch package, configure libdbi-drivers as follows:
	./configure --with-pgsql --with-pgsql-dir=/usr/local/pgsql --disable-docs

If using the postgresqlformac.com package,
	./configure --with-pgsql --with-pgsql-dir=/Library/PostgreSQL8 --disable-docs

In all cases, build and install libdbi-drivers as follows:
	make
	sudo make install


MODIFICATIONS AND REDISTRIBUTION (GPL):
---------------------------------------

See the file COPYING or http://www.gnu.org for more details.


$Id: README.osx,v 1.2 2007/05/01 22:27:28 qu1j0t3 Exp $

libdbi-drivers - drivers for libdbi, the Database
Independent Abstraction Layer for C

Copyright (C) 2001-2013, Markus Hoenicka
http://libdbi-drivers.sourceforge.net


WINDOWS-SPECIFIC INSTALLATION INSTRUCTIONS:
-------------------------------------------

libdbi-drivers can be compiled into DLL files on Win32 with the Cygwin
package, available at http://www.cygwin.com/. libdbi must be properly
installed before attempting to build libdbi-drivers, and you need the
appropriate client libraries of the database engines. The only
database engine packaged with Cygwin is PostgreSQL. However, at least
SQLite, SQLite3 and MySQL build out of the box.

To build a particular driver, run these commands, where:

- XYZ is one of msql, mysql, pgsql, or sqlite for MiniSQL, MySQL,
  PostgreSQL, and SQLite, respectively

- /path/to/lib is (usually) /usr/local/lib/mysql for MySQL and
  /usr/local/msql3/lib for MiniSQL. The LDFLAGS magic is not required
  for building the PostgreSQL and SQLite drivers.

./configure --with-driverXYZ
make
make install
make libXYZ-dll -f Makefile.w32 LDFLAGS="-L/path/to/lib"
make install-libXYZ -f Makefile.w32

If you want to build and install all drivers, use the following commands:
./configure --with-mysql --with-pgsql --with-msql --with-sqlite
make
make install
make -f Makefile.w32 LDFLAGS="-L/usr/local/lib/mysql -L/usr/local/msql3/lib"
make install -f Makefile.w32

The good news is that this works at all. The bad news is that the DLL magic
could be integrated into the standard Makefiles with some extra effort
and a better understanding of the autotools.

CYGWIN DETAILS:
---------------

There are unfortunately no "Cygwin" releases in a sense as there are Debian 2.2
or FreeBSD 4.5. However, libdbi-drivers should work with any Cygwin release
since around Jan 2003.


USAGE:
------

Once libdbi is compiled for Win32 and you have a DLL, you can use that DLL like
any other. The only requirement is that the cygwin runtime DLL is available on
the target machine also, since non-Windows API functions are implemented by
cygwin.


MODIFICATIONS AND REDISTRIBUTION (GPL):
----------------------------------------

See the file COPYING or http://www.gnu.org for more details.


$Id: README.win32,v 1.7 2013/03/11 23:49:41 mhoenicka Exp $