RE: BLOB / CLOB support in PostgreSQL

2020-09-29 Thread tsunakawa.ta...@fujitsu.com
From: Vladimir Sitnikov > Just in case, I'm PgJDBC committer. Thank you very much for your great efforts for the wonderful PgJDBC. I saw you active. # I'd be happy if you send emails in text format so that the reply looks nice. Your email seems to be in HTML. > and apparently, Andrew is sur

Re: BLOB / CLOB support in PostgreSQL

2020-09-29 Thread Vladimir Sitnikov
Andrew>It needs to contain a substantial implementation plan Here's an implementation plan, again, quoted from the very same mail: Vladimir>Of course both variations above fail to support streaming Vladimir> (as in "need to process all the contents in order to get the last character"), so it migh

Re: BLOB / CLOB support in PostgreSQL

2020-09-29 Thread Andrew Dunstan
On 9/29/20 3:48 PM, Vladimir Sitnikov wrote: > Andrew>You and I clearly have a different idea from what constitutes a > concrete > Andrew>proposal. This is hardly the ghost of a proposal. > > Can you please clarify what is a proposal from your point of view? > Is it documented? > > I think I have

Re: BLOB / CLOB support in PostgreSQL

2020-09-29 Thread Vladimir Sitnikov
Andrew>You and I clearly have a different idea from what constitutes a concrete Andrew>proposal. This is hardly the ghost of a proposal. Can you please clarify what is a proposal from your point of view? Is it documented? I think I have read the relevant TODO items: https://wiki.postgresql.org/wi

Re: BLOB / CLOB support in PostgreSQL

2020-09-29 Thread Andrew Dunstan
On 9/29/20 2:39 PM, Dave Cramer wrote: > > > On Tue, 29 Sep 2020 at 14:33, Andrew Dunstan > > wrote: > > > On 9/29/20 10:26 AM, Peter Eisentraut wrote: > > On 2020-09-28 15:46, Vladimir Sitnikov wrote: > >> The concerns to avoid "Clob maps to te

Re: BLOB / CLOB support in PostgreSQL

2020-09-29 Thread Dave Cramer
On Tue, 29 Sep 2020 at 14:33, Andrew Dunstan wrote: > > On 9/29/20 10:26 AM, Peter Eisentraut wrote: > > On 2020-09-28 15:46, Vladimir Sitnikov wrote: > >> The concerns to avoid "Clob maps to text" could be: > >> a) Once the behavior is implemented, it is hard to change. That is > >> applications

Re: BLOB / CLOB support in PostgreSQL

2020-09-29 Thread Andrew Dunstan
On 9/29/20 10:26 AM, Peter Eisentraut wrote: > On 2020-09-28 15:46, Vladimir Sitnikov wrote: >> The concerns to avoid "Clob maps to text" could be: >> a) Once the behavior is implemented, it is hard to change. That is >> applications would rely on it (and it becomes a defacto standard), >> and it

Re: BLOB / CLOB support in PostgreSQL

2020-09-29 Thread Peter Eisentraut
On 2020-09-28 15:46, Vladimir Sitnikov wrote: The concerns to avoid "Clob maps to text" could be: a) Once the behavior is implemented, it is hard to change. That is applications would rely on it (and it becomes a defacto standard), and it would be hard to move to the proper "text with streaming

Re: BLOB / CLOB support in PostgreSQL

2020-09-29 Thread Dave Cramer
On Mon, 28 Sep 2020 at 20:08, Andy Fan wrote: > > > On Tue, Sep 29, 2020 at 5:22 AM Vladimir Sitnikov < > sitnikov.vladi...@gmail.com> wrote: > >> >100% compatible with the MySQL >> >> It is hardly a justification for a feature or for a change request. >> >> Vladimir >> > I would have to agree. T

Re: BLOB / CLOB support in PostgreSQL

2020-09-28 Thread Andy Fan
On Tue, Sep 29, 2020 at 5:22 AM Vladimir Sitnikov < sitnikov.vladi...@gmail.com> wrote: > >100% compatible with the MySQL > > It is hardly a justification for a feature or for a change request. > > Vladimir > > Glad to see this topic. The obviously different opinion for this feature is based on i

Re: BLOB / CLOB support in PostgreSQL

2020-09-28 Thread Vladimir Sitnikov
>100% compatible with the MySQL It is hardly a justification for a feature or for a change request. Vladimir

Re: BLOB / CLOB support in PostgreSQL

2020-09-28 Thread Andrew Dunstan
On 9/28/20 4:44 PM, Vladimir Sitnikov wrote: > Andrew>To the best of my knowledge there is no concrete proposal for > the type > Andrew>of data type / interface you suggest.  > > To the best of my knowledge, one of the concrete proposals was in the very > first message. > > Let me please copy it:

Re: BLOB / CLOB support in PostgreSQL

2020-09-28 Thread Vladimir Sitnikov
Andrew>To the best of my knowledge there is no concrete proposal for the type Andrew>of data type / interface you suggest. To the best of my knowledge, one of the concrete proposals was in the very first message. Let me please copy it: Vladimir> **Here goes the question**: do you think such an

Re: BLOB / CLOB support in PostgreSQL

2020-09-28 Thread Andrew Dunstan
On 9/28/20 9:46 AM, Vladimir Sitnikov wrote: > Let me please bump the thread. > > Just in case, I'm PgJDBC committer. > > PgJDBC receives requests to "support CLOB" from time to time, however, > I believe it is impossible without the support from the database. > To my best knowledge, the database

Re: BLOB / CLOB support in PostgreSQL

2020-09-28 Thread Vladimir Sitnikov
Let me please bump the thread. Just in case, I'm PgJDBC committer. PgJDBC receives requests to "support CLOB" from time to time, however, I believe it is impossible without the support from the database. To my best knowledge, the database does not have APIs for "streaming large text data". The on

BLOB / CLOB support in PostgreSQL

2018-07-25 Thread Vladimir Sitnikov
Hi, According to Pgjdbc GitHub statistics, the most popular page is https://github.com/pgjdbc/pgjdbc/issues/1102 which is "org.postgresql.jdbc.PgConnection.createClob() is not yet implemented" issue (1600 visits from 1400 unique visitors per a fortnight). There are workarounds to silence the err