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 EEF7452A72 for ; Fri, 8 Jul 2005 13:23:09 -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 94739-07 for ; Fri, 8 Jul 2005 16:23:04 +0000 (GMT) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.202]) by svr1.postgresql.org (Postfix) with ESMTP id 78F7852A26 for ; Fri, 8 Jul 2005 13:23:03 -0300 (ADT) Received: by wproxy.gmail.com with SMTP id i31so456845wra for ; Fri, 08 Jul 2005 09:23:03 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=Dw3ZQKAKAna4HtrkGP05mcCztrJRoCd+RMZoZ4fYMmOYSSuskfqLdZemev7ZiROYBncrkE6ENsH4clIE7lAy6eANJItxrRVa0qtXKKLB6mOp7Ns5Ve/V+VV25yxbJ2te6xDO4fwc51u2oZxzH5uR4TODh1LFiSK4pWhO6vJPe/I= Received: by 10.54.16.77 with SMTP id 77mr300612wrp; Fri, 08 Jul 2005 09:22:38 -0700 (PDT) Received: by 10.54.30.27 with HTTP; Fri, 8 Jul 2005 09:22:38 -0700 (PDT) Message-ID: <5db591c00507080922236f9192@mail.gmail.com> Date: Fri, 8 Jul 2005 11:22:38 -0500 From: Moises Alberto Lindo Gutarra Reply-To: Moises Alberto Lindo Gutarra To: weigelt@metux.de, pgsql-performance@postgresql.org Subject: Re: Need help to decide Mysql vs Postgres In-Reply-To: <1120838891.3326.79.camel@archimedes.mirlogic.com> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <001c01c56acb$bc9ba730$797ba8c0@jfradkin> <20050708144336.GC6368@nibiru.borg.metux.de> <1120838891.3326.79.camel@archimedes.mirlogic.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.007 tagged_above=0 required=5 tests=AWL, RCVD_BY_IP, RCVD_IN_BL_SPAMCOP_NET X-Spam-Level: * X-Archive-Number: 200507/88 X-Sequence-Number: 13329 Linux(Debian) + Java + PostgreSQL =3D Fastest 2005/7/8, Mark Lewis : > 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 q= uoting, > > > and knows about type conversions, it will automatically convert a > > > Python List into a postgres Array and do the right thing with quotin= g, > > > 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 <=3D> python Decimal) and you can even add your own typ= es. > > > That's really cool, plus the developer is a friendly guy. > > > > Is there anything similar for java ? > > >=20 > 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. >=20 >=20 >=20 >=20 > ---------------------------(end of broadcast)--------------------------- > TIP 5: don't forget to increase your free space map settings >=20 --=20 Atte Moises Alberto Lindo Gutarra Consultor y Desarrollador Java / Open Source TUMI Solutions SAC Tel: +51.13481104 Cel: +51.197366260=20 MSN : mlindo@tumisolutions.com