JSONB marshalling

From: Damian Dimmich <damian(at)tauri-tec(dot)com>
To: psycopg(at)postgresql(dot)org
Subject: JSONB marshalling
Date: 2014-07-22 10:03:47
Message-ID: 53CE3703.4090601@tauri-tec.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: psycopg

Hello,

I'm testing out the jsonb functionality on postgres 9.4 and up. I added
an extension to sqlalchemy which enables nicer jsonb access through the
orm and extends support for all the query types:

http://docs.sqlalchemy.org/en/rel_0_9/dialects/postgresql.html?highlight=json#sqlalchemy.dialects.postgresql.JSON

The psycopg2 driver doesn't recognise jsonb yet however and results
don't get run through json.reads.

According to http://schinckel.net/2014/05/24/python,-postgres-and-jsonb/
the oid and typarray are 3802 and 3807 respectively.

Are there any plans to add jsonb support to psycopg2, and/or is someone
working on this already?

Thanks!

Damian

Responses

Browse psycopg by date

  From Date Subject
Next Message Daniele Varrazzo 2014-07-24 21:05:34 Re: JSONB marshalling
Previous Message Daniele Varrazzo 2014-07-20 11:19:47 Cancelling a query from Python