================================================================================
ruby-pg: Ruby interface to PostgreSQL RDBMS
This library is copyrighted by the authors.
Authors:
Thanks to:
Maintainer:
Jeff Davis ruby-pg@j-davis.com
Copying:
You may redistribute this software under the terms of the Ruby license,
included in the file "LICENSE". The Ruby license also allows distribution
under the terms of the GPL, included in the file "COPYING.txt" and the
file "GPL".
Portions of the code are from the PostgreSQL project, and are distributed
under the terms of the BSD license, included in the file "BSD".
This is the extension library to access a PostgreSQL database from Ruby.
This library works with PostgreSQL 7.4 and later.
-
Requirements
Ruby 1.8 or later.
PostgreSQL 7.3 or later installed.
It may work with earlier versions as well, but those are
not regularly tested.
-
How to install ?
Follow the instructions below to compile and install:
ruby extconf.rb
make
su (if necessary)
make install
You may need to specify the directory name for the include files and the
-lpq library by using
--with-pgsql-include=<include file directory>
--with-pgsql-lib=<library directory>
For example:
ruby extconf.rb --with-pgsql-include=/usr/local/pgsql/include
--with-pgsql-lib=/usr/local/pgsql/lib
'pg': The 'pg' module is the newer module, that has been greatly improved, and
is almost a complete rewrite. It is not backwards compatible. Use this module
for newly written code. It should be more stable, less buggy, and has more
features.
'postgres': Older module, maintained for backwards compatibility. It
has known flaws that aren't reasonably fixable without breaking backwards
compatibility. Use this module if you have code that already works, and
you just want the fixes that I've committed to this module (for instance,
this module is compatible with PostgreSQL 8.3).
This gem builds and installs two PostgreSQL database adapters, 'postgres'
and 'pg'.
The standard way to download and install the most current stable
version of the postgres gem (from http://gems.rubyforge.org) is to use
the RubyGem package manager. You may need to supply RubyGem with the
location of the libpq library and the libpq.h and libpq/libpq-fs.h
files, and may need to run as root.
If you installed from source on a Unix system you can locate these
libpq files with:
find -name "libpq-fe.h" -print
With binary distributions, you may need to install additional
PostgreSQL development libraries to get these files.
Then run:
sudo gem install postgres -- --with-pgsql-include-dir=/include --with-pgsql-lib-dir=<location of Postgresql/lib
Example:
on Mac OS X with PostgreSQL in /Library/PostgreSQL8 use
--with-pgsql-include-dir=/Library/PostgreSQL8/include --with-pgsql-lib-
dir=/Library/PostgreSQL8/lib
To use the module with Rails:
refer to it as
adapter: postgresql
in your database:yaml file
To use these modules in Ruby directly (not Rails), refer to the RDoc
documentation.
We are thankful to the people at the ruby-list and ruby-dev mailing lists.
And to the people who developed PostgreSQL.
This library is copyrighted by its authors; Yukihiro Matsumoto, and Eiji
Matsumoto.
Portions copyright Laika, Inc.