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
1. 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
1. 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?