Re: Need help to decide Mysql vs Postgres

From: Mark Lewis <mark(dot)lewis(at)mir3(dot)com>
To: weigelt(at)metux(dot)de
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Need help to decide Mysql vs Postgres
Date: 2005-07-08 16:08:10
Message-ID: 1120838891.3326.79.camel@archimedes.mirlogic.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Fri, 2005-07-08 at 16:43 +0200, Enrico Weigelt wrote:
> * PFC <lists(at)boutiquenumerique(dot)com> wrote:
>
> <snip>
> > 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.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Moises Alberto Lindo Gutarra 2005-07-08 16:22:38 Re: Need help to decide Mysql vs Postgres
Previous Message Enrico Weigelt 2005-07-08 15:36:38 Re: Why the planner is not using the INDEX .