Main Topic: Postgres for Programmers

Based on the recent discussions about Postgres development on the MUG discuss mailing list, we've been thinking that a MUG meeting devoted to discussing Postgres for Programmers might be really interesting.

Here's what we'd like to do:

1. Show the following Database administration tasks:
   • Create a user that is allowed to access Postgres
   • Create a database
   • Create a table

2. Database Programming
   • Show how to do the following:
     • Connect to a Postgres database
     • Construct and execute a SELECT query that retrieves one row
     • Construct and execute a SELECT query that retrieves multiple rows
     • Construct and execute an INSERT query and insert some rows into the table
     • Construct and execute an UPDATE query that updates existing data
     • Error handling
   • Using the following languages:
     • Perl
     • Python
     • PHP

3. Discuss and demonstrate the following topics
   • Views
   • Triggers
   • Stored Procedures

If you have some other language that you think we need to show, please speak up. But, keep in mind that we really only have about 2 hours to spend on this, and we can't cover EVERY language out there.

Now, the hard part.... We need some volunteers to help out with this presentation. I've done enough Postgres programming that I could handle the database admin stuff, and I could also show some Perl and PHP examples. BUT, I'd really rather get some participation from other people on this. We definitely need some volunteers to handle the Python part, and the Views/Triggers/Stored Procedures part.

So, can we get some volunteers?

PostgresForProgrammers

If you have topics for future meetings you would like us to cover please email the board, thanks.

Where:

The MUG meetings are held at:

Farmington Community Library - Main Branch
32737 W. 12 Mile Rd.
Farmington Hills, MI 48334-3302

Click here for a map of the area.

When:

the meetings are on the 2nd Tuesday of each month.

6:00pm	Doors open, registration
6:30pm	Meeting starts, Mug business
6:45pm	Main presentation
8:15pm	2nd Presentation
8:45pm	Meeting adjourns
9:00pm	Dinner at a local establishment