Database Design & Application Server Design - Mailing list pgsql-general

From Lane Beneke
Subject Database Design & Application Server Design
Date
Msg-id 000101c3a3d4$f4cdd430$bd2aa8c0@SMC130
Whole thread Raw
Responses Re: Database Design & Application Server Design  (Richard Huxton <dev@archonet.com>)
List pgsql-general
All,

New to the list and a relative newbie to PostgreSQL.  Please forgive stupid
questions.

Designing an application server for a work order processing (et al)
database.  I have a good handle on sequences, referencial integrity, views,
& the basics.  What books/documentation would you recommend to learn more
about...

 - database design for security
 - database design for performance
 - database design for ease of maintenance
 - triggers and functions

Also, the application will require some complex forms, and printing
graphical reports (currently served from an Access 2000 database.)  What
tools/interfaces/servers would you recommend for the application server?

Is there a tool you would recommend for generating graphical reports to
html?

TIA.

Lane Beneke; IT Manager
Stephenson Millwork Company, Inc.


pgsql-general by date:

Previous
From: Michael Glaesemann
Date:
Subject: Re: Using SUBSELECT in CHECK expressions
Next
From: "Simon Stiefel"
Date:
Subject: Question on database structure