[HACKERS] Re: Interested in writing a PostgreSQL article? - Mailing list pgsql-hackers

From Andrzej Mazurkiewicz
Subject [HACKERS] Re: Interested in writing a PostgreSQL article?
Date
Msg-id 13288F4408ADD11186FF0060B06A431303648C64@MSGWAW1
Whole thread Raw
List pgsql-hackers
James,
I would be interested in writing tutorial (a couple of parts) on basic
system design using postgres:
- specification,
- entity-relationship diagram + data flow diagram + state transition diagram
or slightly modified object diagram (CY) + state transition diagram  using
Dome522 free case,
- refinements,
- grants and access,
- basic business rules in postgres (functions, triggers, constrains ..)
- preparing data definition (database) SQL scripts;
- preparing basic processing scripts in SQL,
- preparing basic perl/tcl processing scripts,
- preparing simple interface for importing data (data cleaning process),
- preparing of basic user interface (for example CGI script).

I see that in repeatible process starting from simplest case of 3 - 4
objects (tables) being refined to more sofisticated scheme including
successive constructs.

Of course it is a rough idea now. If you are interested I will prepare
detailed table of contents.

Regards,
Andrzej Mazurkiewicz

andrzej@mazurkiewicz.org

www.mazurkiewicz.org



pgsql-hackers by date:

Previous
From: "Joaquin Eduardo Monje"
Date:
Subject: ask sybase - postgres
Next
From: wieck@debis.com (Jan Wieck)
Date:
Subject: NOT {NULL|DEFERRABLE} (was: bug in 7.0)