Thank you! Any contribution in this direction is important.
Doru On Thu, Sep 4, 2014 at 9:43 PM, Esteban A. Maringolo <emaring...@gmail.com> wrote: > Oh, I forgot. > > The datatype fields are converted to instances of JsonObject, from the > PharoExtras/JSON package. > So the version 2.4 loads such package. > > Even though I don't use PharoExtras/JSON for my daily JSON > manipulation (I use Seaside-JSON and NeoJSON), I found it to be the > most "modular"/"independent" JSON package out there. > > The fieldConverter can be replaced "live" in the PGConnection object > by anything you like. > > Regards! > > Esteban A. Maringolo > > > 2014-09-04 16:34 GMT-03:00 Esteban A. Maringolo <emaring...@gmail.com>: > > Spurred by the last discussion about GLORP, Postgres and friends, I > > spent the last few hours looking into the workings of PostgresV2 to > > add support to the native JSON datatype provided by PostgreSQL 9.2. > > > > According to PostgreSQL docs [1]: > > "The json data type can be used to store JSON (JavaScript Object > > Notation) data, as specified in RFC 4627. Such data can also be stored > > as text, but the json data type has the advantage of checking that > > each stored value is a valid JSON value. There are also related > > support functions available; see Section 9.15." > > > > It is available at ConfigurationOfPostgresV2-EstebanMaringolo.12 in > > SmalltalkHub, blessed as #development (v2.4). It includes a testcase > > for the field converter (if the database server supports it). > > > > JSON datatype allows the indexing and querying of data inside the > > structure of the json object. > > > > Eg: > > SELECT jsonField->'attribute1'->'attribute2' FROM sampleTable; > > > > Adding support of this to GLORP should be easy, but I have no time now :) > > > > DISCLAIMER: > > I'm not using this in production, I tested it and seems to work as > > expected, and fail nosiliy when it should. This is why I blesed it as > > #development. If anybody is bold enough, bless it as #stable :) > > > > Best regards, > > > > Esteban A. Maringolo > > > > [1] http://www.postgresql.org/docs/9.2/static/datatype-json.html > > -- www.tudorgirba.com "Every thing has its own flow"
