LJ Archive

Resources

PostgreSQL: Introduction and Concepts (ISBN: 0-201-70331-9, $44.95 US, 544 pages) by Bruce Momjian (available on-line at www.ca.postgresql.org/docs/awbook.html). This book was reviewed in the August 2001 issue of Linux Journal.

For optimizing hardware for PostgreSQL, see Momjian's Linux Journal (August 2001 issue) article “PostgreSQL Performance Tuning” (available on-line at www.linuxjournal.com/article/4791).

Microsoft Access 2000 Power Programming (ISBN: 0-672-31506-8, $49.99 US, 1,332 pages, CD-ROM) by F. Scott Barker.

PostgreSQL 7.1 Reference Manual: www.ca.postgresql.org/users-lounge/docs/7.1/reference

Postgres FAQ: www.ca.postgresql.org/users-lounge/docs/#7.1

Postgres/Access FAQ: joelburton.com/resources/pgaccess

PostgreSQL Documentation and Data Migration Tools: postgresql.crimelabs.net/users-lounge/docs

Migration Tools: installation and management tools included with the build are pgAdmin, a GUI interface for performing administrative tasks in a PostgreSQL environment; phpPgAdmin, a web-based utility that provides a browser interface for administrative tasks; and the PsqlODBC Windows driver, which enables developers to write Windows-based applications that access the PostgreSQL database via an open database connectivity (ODBC) interface.

Textual Highlight: a new public version of exSQL is available. exSQL is an essential PostgreSQL conversion tool. A new version with improved handling of indexes and foreign keys is available for download at www.geocities.com/musica_6898/postgresaccess_home.html. PostgreSQL uses foreign keys as a way of linking tables and codifying the relationship between them. This version of exSQL, by Michael Calabrese, modifies which types of Access fields can be converted to which field types in PostgreSQL. Among other shortcuts and fixes, this version contains a script that works around a limitation in Access that causes the money type to default to text. The script overrides this default, which can cause a variety of errors at runtime.

LJ Archive