Return-Path: Delivered-To: apmail-perl-modperl-archive@www.apache.org Received: (qmail 94384 invoked from network); 16 Mar 2006 01:15:42 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 16 Mar 2006 01:15:42 -0000 Received: (qmail 23036 invoked by uid 500); 16 Mar 2006 01:15:37 -0000 Delivered-To: apmail-perl-modperl-archive@perl.apache.org Received: (qmail 23021 invoked by uid 500); 16 Mar 2006 01:15:36 -0000 Mailing-List: contact modperl-help@perl.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Delivered-To: mailing list modperl@perl.apache.org Received: (qmail 23010 invoked by uid 99); 16 Mar 2006 01:15:36 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 15 Mar 2006 17:15:36 -0800 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: local policy) Received: from [66.33.198.201] (HELO jareth.dreamhost.com) (66.33.198.201) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 15 Mar 2006 17:15:35 -0800 Received: from [192.168.1.100] (user-10876ld.cable.mindspring.com [64.131.154.173]) by jareth.dreamhost.com (Postfix) with ESMTP id D2351191268 for ; Wed, 15 Mar 2006 17:15:13 -0800 (PST) Mime-Version: 1.0 (Apple Message framework v746.2) In-Reply-To: <44123972.6090901@gmx.de> References: <0C1FE548-66D6-4B8A-BAF1-C28D98F8AD09@2xlp.com> <1142030946.28877.59.camel@localhost.localdomain> <44123972.6090901@gmx.de> Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: <3A3FC465-C8DA-4F1F-AE71-84A043AAA81D@2xlp.com> Content-Transfer-Encoding: 7bit From: Jonathan Vanasco Subject: Re: Migrating from MySQL to PostGres -- Any mod_perl specific things I should be wary of? Date: Wed, 15 Mar 2006 20:15:11 -0500 To: modperl_users List X-Mailer: Apple Mail (2.746.2) X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N crazy. i used to use postgres extensively @work - my CTO was real big on it. we moved over to mysql when he left, because it was easier for me to staff projects based on it, and we didn't need triggers or stored procedures. I had no idea about the invalid data - i just checked some old apps, and I cringed. sorry I was rash on the list. i lost about 3weeks of work and ~10gb of corrupt data because my foreign keys didn't work. a few days into postgres and I'm in heaven though. super strict data validation, error codes that are verbose and semantic, and the OS management tools that are out there are just amazing.