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/

• else see http://www.postgresql.org/download/macosx/

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

• http://clarkdave.net/2013/06/what-can-you-do-with-postgresql-and-json/
• http://www.postgresql.org/docs/9.3/static/functions-json.html

Python-related links

• Joel Burton on PostgreSQL, Python, and Zope
• speed comparison from May'2003 - I'm probably going to switch to Po Py, or "dumb down" the interface and just use Pg
  • problems with 8-byte integers?
    • this page also adds test for 'psycopg' which scores almost as well as Po Py and doesn't have that 8-byte problem.
  • this message also supports psycopg http://initd.org/software/initd/psycopg