COPY support survey

Поиск
Список
Период
Сортировка
От Kris Jurka
Тема COPY support survey
Дата
Msg-id Pine.BSO.4.62.0508190108180.141@leary.csoft.net
обсуждение исходный текст
Ответы Re: COPY support survey  (Dave Cramer <pg@fastcrypt.com>)
Re: COPY support survey  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: COPY support survey  (Josh Berkus <josh@agliodbs.com>)
Список pgsql-jdbc
On and off there's been discussions of getting COPY support into the JDBC
driver and I produced a patch to provide a stream based interface over a
year and a half ago [1].  At the time we did not commit that because we
had grand plans to provide a friendly interface to users so they did not
have to know the internals of how COPY actually represents data.  This
mostly happened off-list between Oliver and I, but the key suggestion is
available here [2].  This allows you to use SQLOutput [3] calls like
writeTimestamp or writeArray to directly send Java objects to the database
without having to know the Postgresql specific text representation of
them.  This turned out to be harder and more involved than it looked and I
just let the patch languish, always intending to return to it, but as time
has passed I've actually had less time to dedicate to the driver instead
of more.

I know a number of people are already/still using the original patch I
provided, but at the same time they have also (indirectly) indicated that
some additional support is needed [4].

So the question is what should we do?

1) Just get the raw stream interface into the official release and let the
end user deal with reading and writing the stream.  That's all I'll use
and I don't care about anything else.

2) Don't give up, get the friendly SQLInput/SQLOutput interface in because
this is what I really want.

3) Put in the raw stream interface, but keep working to also add the
friendly one.  I'll understand if the interface changes and I have to
modify my code a bit.

Kris Jurka

[1] http://archives.postgresql.org/pgsql-jdbc/2003-12/msg00186.php
[2] http://www.ejurka.com/pgsql/copy/doc/sqlinputoutput.txt
[3] http://java.sun.com/j2se/1.4.2/docs/api/java/sql/SQLOutput.html
[4] http://archives.postgresql.org/pgsql-jdbc/2004-06/msg00165.php

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Kris Jurka
Дата:
Сообщение: Re: Updated high-unicode patch
Следующее
От: Dave Cramer
Дата:
Сообщение: Re: COPY support survey