PostgreSQL

Open Source Relational Data Base. http://www.postgresql.org/

Came from Ingres

Tips

Older notes

Not quite as fast as MySQL, and a little more complicated to work with (supposedly), but supports more complex functionality,

http://www.faqs.org/docs/ppbook/book1.htm OReilly Practical PostgreSQL book free online

Simple Mac install - http://postgresapp.com/

MsWindows GUI http://www.pgadmin.org/pgadmin3/index.php

IRC support

Before launching in Command Line do su - postgres

To import when starting

  • create db first with user. CREATE DATABASE {name} WITH OWNER {user_name]
  • psql {databasename} < {data_base_dump.sql}

To quit: \q<enter>

played with Stored Procedure to basically return a bunch of base fields plus calculated params for a single record, but then found that I'd need to spec the schema in the query that called the proc, which seemed horribly coupled, so dropped that approach....

 FUNCTION prod.client_vacation_view(int4) RETURNS record AS...
...SELECT client_id, last_name from clients into output WHERE...
...return output
but then 
select * from client_vacation_view(200) as (client_id int, last_name varchar(128));

JSON support

Python-related links


Edited:    |       |    Search Twitter for discussion