Re: [greenstone-devel] appropriateness for a land database

From John R. McPherson
DateSat, 3 Apr 2004 12:50:45 +1200
Subject Re: [greenstone-devel] appropriateness for a land database
In-Reply-To (71E37EF6B7DCC1499CEA0316A256832801057854-loki-wc-globexplorer-net)
On Fri, Apr 02, 2004 at 03:30:05PM -0800, Gregory S. Williamson wrote:

> Postgres was likely to be our database of choice as it works well w/
> MMS (and I am heartened to see in another response to your mail that
> the GSDL perl DB interface works with postgres) so I can't much
> advice on SQL server (although I have seen MMS posts that indicate
> that it can be made to work with MMS).

The DBPlug works by processing a file named *.dbi in the collection's
import directory, and reads that as a config file.

There should be an example .dbi config file in
greenstone/etc/packages/example.dbi

which you can copy and modify for your particular details. It has
lots of comments, but only in English at the moment, I'm afraid.

It might require a bit of perl knowledge and a bit of SQL knowledge to
successfully use the plugin.

Perl's DBI interface means you can use (roughly) the same perl code
to access databases of various types. You also need to load a specific
perl module for your particular backend. For example, for postgres, I
needed to add
use DBD::Pg;
to the file.

Perl's documentation for "DBI" lists the following back-end drivers:
ad_ DBD::AnyData
ado_ DBD::ADO
best_ DBD::BestWins
csv_ DBD::CSV
db2_ DBD::DB2
f_ DBD::File
file_ DBD::TextFile
ib_ DBD::InterBase
ing_ DBD::Ingres
ix_ DBD::Informix
msql_ DBD::mSQL
mysql_ DBD::mysql
odbc_ DBD::ODBC
ora_ DBD::Oracle
pg_ DBD::Pg
proxy_ DBD::Proxy
rdb_ DBD::RDB
sapdb_ DBD::SAP_DB
solid_ DBD::Solid
syb_ DBD::Sybase
tdat_ DBD::Teradata
tuber_ DBD::Tuber
uni_ DBD::Unify
xbase_ DBD::XBase


Hope this helps

John McPherson