Re: SQLJSON

From: Vladimir Sitnikov <sitnikov(dot)vladimir(at)gmail(dot)com>
To: Álvaro Hernández Tortosa <aht(at)8kdata(dot)com>
Cc: List <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: SQLJSON
Date: 2015-06-29 23:00:35
Message-ID: CAB=Je-H-tgJ-hGUqWk83A4M7mheBELGUXKj2qe4ECbVPeyaebA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Álvaro, Dave,

If I understand you right, you "just" want to make "usage of json
feature" easy for end-users.
So do I.
If there is more, please add.

What if we do the following?
1) We keep "base" part of driver "unaware" of json. In other words,
calls like getObject(1, JsonValue.class) would end up in "@throws
SQLException if conversion is not supported" (as per ResultSet's
javadoc)
2) Add "pgjdbc-json" module (i.e. jar) that adds support for
getObject(1, JsonValue.class), setObject(1, JsonValue) kind of calls.
3) Document "best choice of json dependencies" right in the readme. I
think we would be fine even with simple "we tested just jackson and it
works with pgjdbc".

From the end-user perspective it will be:
1) Using driver as usual -- "just add one mvn dependency" --
'org.postgresql:postgresql:9.4-1201-jdbc41'
2) Adding json support -- add additional one --
'org.postgresql:postgresql-json:9.4-1201-jdbc41' and
'best-of-the-best-pgjdbc-approved-json-impl:3.14.15'.

Both items would be available on the top of readme as copy&paste ready snippets.

This covers "json support" and it is user-friendly: no additional
googling is required to use the feature.
Am I missing anything?

Vladimir

In response to

  • Re: SQLJSON at 2015-06-29 22:37:12 from Álvaro Hernández Tortosa

Responses

  • Re: SQLJSON at 2015-06-29 23:33:58 from Dave Cramer
  • Re: SQLJSON at 2015-06-29 23:40:32 from Álvaro Hernández Tortosa
  • Re: SQLJSON at 2015-06-30 07:07:14 from Stephen Nelson

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2015-06-29 23:33:58 Re: SQLJSON
Previous Message Vladimir Sitnikov 2015-06-29 22:39:48 Re: SQLJSON