A review of querying/searching and mutability tracking on Postgres SQL JSON and JSONB field implementations using SQLAlchemy and Sqlalchemy-Json

[Victor Reichert]

Hi,

I've been trying to better understand the properties of different Postgres JSON field implementations.  I wrote s script with my tests and I thought I would share it.  It can be found at:

https://gist.github.com/vfr292/41530bfb56778ffc26fe53c605f40feb

FWIW, I found implementing the field as Column(sqlalchemy_json_NestedMutable.as_mutable(pg_JSONB)) had the mutation tracking and querying I was looking for.

I hope this is of use to someone :)

~Victor