X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 2B46752AD7 for ; Fri, 8 Jul 2005 13:08:31 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 91877-03 for ; Fri, 8 Jul 2005 16:08:22 +0000 (GMT) Received: from mir3-fs.mir3.com (www.mir3.com [216.74.11.46]) by svr1.postgresql.org (Postfix) with ESMTP id 9823B52AF6 for ; Fri, 8 Jul 2005 13:08:14 -0300 (ADT) Received: from archimedes.mirlogic.com ([172.16.2.68]) by mir3-fs.mir3.com with Microsoft SMTPSVC(5.0.2195.6713); Fri, 8 Jul 2005 09:11:03 -0700 Subject: Re: Need help to decide Mysql vs Postgres From: Mark Lewis To: weigelt@metux.de Cc: pgsql-performance@postgresql.org In-Reply-To: <20050708144336.GC6368@nibiru.borg.metux.de> References: <001c01c56acb$bc9ba730$797ba8c0@jfradkin> <20050708144336.GC6368@nibiru.borg.metux.de> Content-Type: text/plain Organization: MIR3, Inc. Date: Fri, 08 Jul 2005 09:08:10 -0700 Message-Id: <1120838891.3326.79.camel@archimedes.mirlogic.com> Mime-Version: 1.0 X-Mailer: Evolution 2.0.2 (2.0.2-16) Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 08 Jul 2005 16:11:03.0109 (UTC) FILETIME=[A3506750:01C583D7] X-Virus-Scanned: by amavisd-new at hub.org X-Archive-Number: 200507/87 X-Sequence-Number: 13328 On Fri, 2005-07-08 at 16:43 +0200, Enrico Weigelt wrote: > * PFC wrote: > > > > For Python it's the reverse : the MySQL driver is slow and dumb, > > and the postgres driver (psycopg 2) is super fast, handles all quoting, > > and knows about type conversions, it will automatically convert a > > Python List into a postgres Array and do the right thing with quoting, > > and it works both ways (ie you select a TEXT[] you get a list of > > strings all parsed for you). It knows about all the postgres types (yes > > even numeric <=> python Decimal) and you can even add your own types. > > That's really cool, plus the developer is a friendly guy. > > Is there anything similar for java ? > The postgres JDBC driver is very good-- refer to pgsql-jdbc mailing list or look at jdbc.postgresql.org. I've had only limited experience with the mysql jdbc driver, but it seemed servicable enough, if you can live with their licensing and feature set.