Re: [sqlalchemy] Re: Wierdness with JSONB / Python dictionary

And, for that matter, the trouble I was having should have warned me about my data structure - I need to use an association table, not bury data in a JSONB column. Thanks again. -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example

Re: [sqlalchemy] Re: Wierdness with JSONB / Python dictionary

It helps a great deal, thank you Simon. Thanks for taking the time to explain it for me. -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See

Re: [sqlalchemy] Re: Wierdness with JSONB / Python dictionary

On Wed, Jun 28, 2017 at 1:35 AM, Andrew M wrote: > I can also replicate it with JSON, with a table defined as follows: > > class Test(Base): > __tablename__ = 'test' > id = Column(INT, primary_key=True, index=True) > json = Column(JSON, default={}) > > And