Resources

Presentations:

• Using Technology to Support Collaborations is a presentation I gave at the 2001 Public/Private Partnership conference about using software tools and human resource tools to enhance collaboration.

Resources:

PostgreSQL:

An excellent resource for help with PostgreSQL is Justin Clift's techdocs section

• PostgreSQL and Access FAQ. A FAQ document for using this fantastic Open Source database with Access.
• Replacing Slow Loops in PostgreSQL. A tutorial on optimizing Zope and PostgreSQL.
• Referential Integrity Tutorial & Hacking the Referential Integrity tables A tutorial on using Referential Integrity. Specific to PostgreSQL, but helpful in concept for all databases.
• Updating columns in PostgreSQL tables effectively Reference information on making alterations to existing PostgreSQL databases, without recreating the database.
• Things to find out about when moving from MySQL to PostgreSQL Some things I wish I had known about PostgreSQL when I started using it!

Perl

• eSQL. A very simple web publishing system for creating static web pages from database systems. Designed for beginners to use with programs like Microsoft Access.

Zope

• Zope Products. Some straightforward products I've developed for Zope, including the discussion widget, below, and a book-reviewing widget used on Oliver's site.
• Zope HOW-TOs: I have a HOWTO about optimizing Zope and PostgreSQL at My Membership Page.

Microsoft Access

• Sample Access databases. As a database consultant, I've designed dozens of Access databases for clients, including some nifty code for managing duplicates, a full-featured report wizard, and more. All of these databases can be downloaded and re-used, and all of the code is issued under the the General Public License, an Open Source license.
• My handouts for the Access classes that I teach. These are in Powerpoint format, but I'm moving them over to a much more flexible XML-based format. (Open Source friends: you can always open the Powerpoint document in OpenOffice, a great free Microsoft Office-compatible suite.)