Open Source Relational Data Base.

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

http://www.postgresql.org/

http://www.faqs.org/docs/ppbook/book1.htm OReilly [Practical Postgre S Q L] book free online

Ms Windows GUI http://www.pgadmin.org/pgadmin3/index.php

IRC support

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));

PyThon-related links

• [Joel Burton] on Postgre S Q L, PyThon, and ZoPe

• speed comparison from May'2003 - I'm probably going to switch to [PoPy], 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 [PoPy] and doesn't have that 8-byte problem.

  • this message also supports psycopg http://initd.org/software/initd/psycopg

User Options Recent Changes Help Page