> I need to learn how to access databases (Oracle, SQL Server, Postgres) from
> unix (solaris 2.8). I have tried to do some research on amazon but can seem
> to find any books on the subject. I want to code to a very generic library
> and not be tied to anything (definitely not oracle).
There is no standard way to access the DB server process(es)
from a client process (= application), because the means of
communication (mechanism, protocol, encoding, ...) are specific
to the DBMS.
The closest you can get may be ODBC, but IMHO this is no good
approach because ODBC (like all M$ designs) pretends to _know_
what _you_ want, and hence does not pass your requests unchanged.
You still need to link your routines with the specific ODBC lib.
The standard to access an SQL DBMS is to use "embedded SQL"
(as defined by X/Open, ANSI/ISO, ...) and then to pass this code
through a preprocessor, compile the resulting code (which is
product-specific) and link it with the respective runtime libraries.
> Any suggestions for resources for database programming in unix?
"Adabas D" ( http://www.adabas.com/sqlindex.html ) is available
as a "personal edition" (limited for 3 users, 1 CPU, 100 MB data space)
free of charge for Linux (and Win32);
you might ask your local Software AG branch whether they can provide
a "personal edition" for Solaris (or other Unix variant: AIX, HP-UX,
Tru64, ...) as well (or buy a license from them ...)
Joerg Bruehe, SQL Datenbanksysteme GmbH, Berlin, Germany
(speaking only for himself)