Changes for version 1.05 - 2014-06-14
- Revert to using implicit join unless explicitly requested to do so. New per-database configuration-file directive join="outer" will cause left outer joins to be used, as was the default in 1.03.
- Access-point specifiers may take an "uppercase" modifier as well as or instead of "fulltext". When present, terms used in searches against that access point are mapped to upper-case. This can be used to simulate case-blind searching in dumb RDBMSs such as Oracle that don't support it out of the box, so long as that database schema includes an all-uppercase version of the field to be searched.
- Better quoting of search terms in the generated SQL, so that embedded apostrophes don't break things.
- Only apply defaultattrs when no attributes are explicitly provided.
- Add "-n" command-line option (and corresponding DBIServer constructor) to invoke no-op mode, in which the backend database is never connected to, and dummy responses are provided.
- Hashes in the configuration file do not introduce comments if immediately preceded by a backslash, but become simple slashes. This provides a means of embedded hashes in strings.
- Add fulltext support for Oracle, using CONTAINS.
- NOTE INCOMPATIBLE CHANGE: fulltext searching is now used only when attribute 3=3 (position=any position in field) is supplied.
- Add make-pdf.sh to generate zSQLgate-manual.pdf
- New configuraton-file directive: "option NAME = VALUE", can be used so set for example "option "mysql_enable_utf8" = 1"
Documentation
Generic Z39.50-to-Relational Database gateway server
Modules
Generic Z39.50-to-Relational Database gateway module
Configuration file parser for DBIServer
exception thrown by DBIServer module
build GRS-1 records for DBIServer
The zSQLgate Installation Guide
An Introduction to zSQLgate
the zSQLgate licence
build MARC records for DBIServer
in-progress result set objects for DBIServer
Invoking the zSQLgate Server
build SUTRS records for DBIServer
The zSQLgate Configuration File Format
The zSQLgate Tutorial
build XML records for DBIServer
Provides
in lib/Net/Z3950/DBIServer/Config.pm
in lib/Net/Z3950/DBIServer/Config.pm
in lib/Net/Z3950/DBIServer/Config.pm
in lib/Net/Z3950/DBIServer/Config.pm
in lib/Net/Z3950/DBIServer/Config.pm
in lib/Net/Z3950/DBIServer/Config.pm
in lib/Net/Z3950/DBIServer/Config.pm
in lib/Net/Z3950/DBIServer/Config.pm
in lib/Net/Z3950/DBIServer/Config.pm
in lib/Net/Z3950/DBIServer/Config.pm
in lib/Net/Z3950/DBIServer.pm
in lib/Net/Z3950/DBIServer.pm
in lib/Net/Z3950/DBIServer.pm
in lib/Net/Z3950/DBIServer.pm
Examples
- examples/books/README
- examples/books/author.data
- examples/books/book.data
- examples/books/books.nzd
- examples/books/country.data
- examples/books/dc-rdf.xsl
- examples/books/mysql/Makefile
- examples/books/mysql/create-database.sh
- examples/books/mysql/create.sql
- examples/books/oracle/Makefile
- examples/books/oracle/README
- examples/books/oracle/create-database.sh
- examples/books/oracle/create.sql
- examples/books/postgres/Makefile
- examples/books/postgres/create-database.sh
- examples/books/postgres/create.sql
- examples/books/postgres/make-insert.pl
- examples/books/pqf.properties
- examples/books/trivial.nzd
- examples/books/yazserver.xml
- examples/csv/README
- examples/csv/books
- examples/csv/csv.nzd
- examples/init-script
- examples/oracle/README
- examples/oracle/dbish.pl
- examples/oracle/universe
- examples/results/README
- examples/results/organisations.data
- examples/results/postgres/Makefile
- examples/results/postgres/create-database.sh
- examples/results/postgres/create.sql
- examples/results/resource_format.data
- examples/results/resource_type.data
- examples/results/resources.data
- examples/results/results.nzd