Received: from maia.hub.org (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id 2967E63326C;
	Tue, 20 Apr 2010 16:57:51 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia,
	port 10024)
	with ESMTP id 96830-06; Tue, 20 Apr 2010 19:57:27 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-wy0-f174.google.com (mail-wy0-f174.google.com
	[74.125.82.174])
	by mail.postgresql.org (Postfix) with ESMTP id A16E1633547;
	Tue, 20 Apr 2010 16:57:39 -0300 (ADT)
Received: by wyb39 with SMTP id 39so3562855wyb.19
	for <multiple recipients>; Tue, 20 Apr 2010 12:57:38 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:received:in-reply-to:references
	:from:date:received:message-id:subject:to:cc:content-type;
	bh=yF60drMfsPEp+P4mB+Lk6DW7CAuj71tBw0f3Pgmgu2E=;
	b=eZnp3BMFOQ9P78vSYkr8wT6j+PZ90IPcOX7sAkpmK+X3N02rlLYXY9r65BiNXTLUho
	AbYCf74zHNRrpu2hmQeXpGGYOFzYo8yEJRGtetZSfVnyNIoJI2BHHgOYp3ukZY8ZuUy5
	4sjhjA1OR344f0D5tvnCMXAr5t2zO2U6YeKZ8=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:from:date:message-id:subject:to
	:cc:content-type;
	b=enBArK/ZTX0pPVQDvxnrXTC/W3ZEvbBGToNzm7VjDHIXC7RFDa923RXHz6XhjL3IlD
	hwaN8R0abJx8Wfjf4M6O/gjs3xKfLhfeUJmyRpSh44dyAyUvw13O2drMq2TTjJ9U6SWW
	P5kg1jGfGulcHUPUl0M1Wut2EoIiMEz+roD3g=
MIME-Version: 1.0
Received: by 10.216.58.204 with HTTP; Tue, 20 Apr 2010 12:57:18 -0700 (PDT)
In-Reply-To: <x2zca24673e1004201229n653f4e69vd274af4a4aa22d09@mail.gmail.com>
References: <q2sca24673e1004191633j10b1124amf1eb51f3bd84f19a@mail.gmail.com>
	<4BCD73AF0200002500030BC2@gw.wicourts.gov>
	<w2kca24673e1004200847k77429a1cra0a6f3560d407d8e@mail.gmail.com>
	<4BCD90D80200002500030BDD@gw.wicourts.gov>
	<x2zca24673e1004201229n653f4e69vd274af4a4aa22d09@mail.gmail.com>
From: Nikolas Everett <nik9000@gmail.com>
Date: Tue, 20 Apr 2010 15:57:18 -0400
Received: by 10.216.157.145 with SMTP id o17mr2004399wek.125.1271793458413;
	Tue, 20 Apr 2010 12:57:38 -0700 (PDT)
Message-ID: <t2kd4e11e981004201257j8d3535d9s17e7eb059ff3320e@mail.gmail.com>
Subject: Re: SOLVED ... Re: Getting rid of a cursor from JDBC .... Re:
	[PERFORM] Re: HELP: How to tame the 8.3.x JDBC driver with a biq guery
	result set
To: Dave Crooke <dcrooke@gmail.com>
Cc: Kevin Grittner <Kevin.Grittner@wicourts.gov>, pgsql-jdbc@postgresql.org,
	pgsql-performance <pgsql-performance@postgresql.org>,
	Scott Carey <scott@richrelevance.com>
Content-Type: multipart/alternative; boundary=0016367faf8d50fee70484b07da9
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.158 tagged_above=-10 required=5 tests=AWL=-0.659,
	BAYES_05=-0.5, HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 201004/36
X-Sequence-Number: 20447

--0016367faf8d50fee70484b07da9
Content-Type: text/plain; charset=ISO-8859-1

On Tue, Apr 20, 2010 at 3:29 PM, Dave Crooke <dcrooke@gmail.com> wrote:
>
> I wouldn't hold MySQL up to be a particularly good implmentation of
> anything, other than speed (MyISAM) and usability (the CLI) .... I find
> Oracle's JDBC implmentation to be both user friendly and (largely) standards
> compliant.
>

Dave,

I've been following along at home and agree with you right up until you
mention the MySQL CLI being usable.  I work with the thing every day.  The
plain, vanilla install on my Ubuntu laptop lacks proper readline support.
 Hitting ctrl-c will sometimes kill the running query and sometimes kill the
CLI.  Its far from a paragon of usability.  That last time I used psql it
didn't have any of those issues.

Full disclosure:  mysql does have proper readline support on a Centos
machine I have access to.  ctrl-c still kills the shell.

Your other points are good though.

--Nik

--0016367faf8d50fee70484b07da9
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<br><br><div class=3D"gmail_quote">On Tue, Apr 20, 2010 at 3:29 PM, Dave Cr=
ooke <span dir=3D"ltr">&lt;<a href=3D"mailto:dcrooke@gmail.com">dcrooke@gma=
il.com</a>&gt;</span> wrote:<blockquote class=3D"gmail_quote" style=3D"marg=
in:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">

<div class=3D"gmail_quote"><div>I wouldn&#39;t hold MySQL up to be a partic=
ularly good implmentation of anything, other than speed (MyISAM) and usabil=
ity (the CLI) .... I find Oracle&#39;s JDBC implmentation to be both user f=
riendly and (largely) standards compliant. <br>

</div></div></blockquote><div><br></div><div>Dave,</div><div><br></div><div=
>I&#39;ve been following along at home and agree with you right up until yo=
u mention the MySQL CLI being usable. =A0I work with the thing every day. =
=A0The plain, vanilla install on my Ubuntu laptop lacks proper readline sup=
port. =A0Hitting ctrl-c will sometimes kill the running query and sometimes=
 kill the CLI. =A0Its far from a paragon of usability. =A0That last time I =
used psql it didn&#39;t have any of those issues.</div>

<div><br></div><div>Full disclosure: =A0mysql does have proper readline sup=
port on a Centos machine I have access to. =A0ctrl-c still kills the shell.=
</div><div><br></div><div>Your other points are good though.</div><div><br>

</div><div>--Nik</div></div>

--0016367faf8d50fee70484b07da9--