::Planet PostgreSQL::::Planet PostgreSQL:: - http://www.planetpostgresql.org/Greg Sabino Mullane: OpenSQL Camp 2008- August 27, 2008 This looks interesting: a community-organized database conference. Not just the Postgres community, but inclusive of all database communities as well (Yes, other database systems have communities as well, although none are as good as the Postgres one . From Baron's blog post: Key facts: It is of, by and for the community (you). At this event, all open-source databases are created equal. We'll learn together and grow together. It's a combination conference and hackathon. It's free. It is...http://people.planetpostgresql.org/greg/index.php?/archives/141-OpenSQL-Camp-2008.html Pavel Stehule: default parameters for PL functions- August 27, 2008 HelloI completed one task - defaults for PL functions. Using is simple - it is same as Firebird's 2.x defaults.postgres= create or replace function x1(int = 1,int = 2,int= 3) returns int as $$ select $1+$2+$3; $$ language sql;CREATE FUNCTIONpostgres= select x1();x1----6(1 row)postgres= select x1(10);;x1----15(1 row)postgres= select x1(10,20);x1----33(1 row)postgres= select x1(10,20,30);x1----60(1 row)This is first step before named parameters feature - and less...http://okbob.blogspot.com/2008/08/default-parameters-for-pl-functions.html Greg Smith: Linux disk failures: Areca is not so SMART- August 26, 2008 One of the most frequently asked questions on the PostgreSQL Performance list is "what disk controller works best with PostgreSQL" It's a tough question; every product has different things it's good and bad at, and it can be hard to through all that to figure out what makes sense for your application. You need to focus equally on performance and reliability, as disk drives are very prone tohttp://notemagnet.blogspot.com/2008/08/linux-disk-failures-areca-is-not-so.html Pavel Stehule: Using cursors for generating cross tables- August 26, 2008 I am working on procedure support in PostgreSQL more than one year. Missing procedures is one disadvantage of PostgreSQL. Because procedures are not called from SELECT statement, then it couldn't respect some rules like functions. Procedures are mainly used for explicit transaction controlling and for generating mutable results (like dynamic record set or stacked record set). Dynamic record set is interesting feature when we nothing know about result set's columns. It's typical for cross...http://okbob.blogspot.com/2008/08/using-cursors-for-generating-cross.html US PostgreSQL Association: 1023, banking and membership- August 25, 2008 Just a quick update for everyone. I received confirmation last Friday that our excellent attorney's at DWT (http:www.dwt.com) had filed our 1023 with the IRS. I will work on getting that up on the website shortly. Apparently the IRS still requires the 1023 to be filed via dead trees; the document is large and will need to be scanned. read morehttp://www.postgresql.us/node/34 David Fetter: PostgreSQL Weekly News - August 24 2008- August 25, 2008 PostgreSQL Weekly News - August 24 2008 PostgreSQL Product News Archiveopteryx 2.1.1 and 3.0.0 will be out soon. http:aox.org PostgreSQL Jobs for August http:archives.postgresql.orgpgsql-jobs2008-08threads.php PostgreSQL Local PGCon Brasil 2008 registration is open. http:pgcon.postgresql.org.brinscricoes.en.html Stefan Kaltenbrunner is giving a talk about monitoring strategies for postgresql.org at the Nagios conference 2008 September 11-12 in Nuremberg,...http://people.planetpostgresql.org/dfetter/index.php?/archives/188-PostgreSQL-Weekly-News-... Devrim Gndz: Lazy bloggers- August 22, 2008 We have some lazy bloggers in Planet PostgreSQL -- would you like to post something before I blog your nameshttp://people.planetpostgresql.org/devrim/index.php?/archives/119-Lazy-bloggers.html Devrim Gndz: From 3067 hits to 34538 hits- August 22, 2008 It's been about 8 months since I started PostgreSQL RPM repository project. Every month, we got more hits, more hits. When we first started project, we got 3067 hits per day. This month, we have an average of 34538 hits per day. That is amazing. Also, the PostgreSQL Live CD has been downloaded more than 1000 times. I hope this repo helps people to deploy and use PostgreSQL easily.http://people.planetpostgresql.org/devrim/index.php?/archives/118-From-3067-hits-to-34538-... Robert Lor: Setting up Drupal with PostgreSQL on OpenSolaris 2008.05- August 21, 2008 Drupal is quickly gaining popularity among the many Open Source Content Management Systems (CMS) out there. AFAIK, Drupal is mostly used with MySQL on Linux, so I wanted to find out myself how easy (or hard) it is to get it working with PostgreSQL on OpenSolaris. Below were the steps I followed: Install OpenSolaris 2008.05. The installation from the Live CD went very smoothly, much simpler than previous versions of Solaris. Great job to the installer team! If you don't have the CD, you can.http://blogs.sun.com/robertlor/entry/setting_up_drupal_with_postgresql Frank Wiles: Fret Free -- Introduction to Django and the Django Software Foundation- August 20, 2008 LinuxPro Magazine just released my latest article, an introduction to Django and some discussion about the newly created Django Software Foundation. Being a life long Perl user, I didn't think I would enjoy Django at all. I have to admit that it is a VERY polished system. It has great PostgreSQL support, in fact the core developers smartly prefer it over MySQL for their own systems. You can download a PDF copy of the article at, Fret Free -- Django and the Django Software...http://blog.revsys.com/2008/08/fret-free----in.html |