edelooff / sqlalchemy-json

Full-featured JSON type with mutation tracking for SQLAlchemy
http://variable-scope.com/posts/mutation-tracking-in-nested-json-structures-using-sqlalchemy
BSD 2-Clause "Simplified" License
189 stars 34 forks source link

Trivial doc request re SQLite support for JSON #32

Closed chrisinmtown closed 2 years ago

chrisinmtown commented 2 years ago

Thanks for this package. I just want to ask if it might be appropriate to update this README.rst text:

.. your database does not natively support JSON (e.g. SQLite),
or you wish to serialize to a format other than JSON,
you'll need to provide a different backing type.

I believe - but please correct me if I got this wrong - that SQLite supports JSON natively since version 3.9. The current version in Python 3.9 is 3.36.

Hope this helps.

jeanmonet commented 2 years ago

Certainly the case - I'm currently working with JSON fields in SQLite.

FYI: https://dba.stackexchange.com/questions/122198/is-it-possible-to-store-and-query-json-in-sqlite

SQLite 3.9 introduced a new extension (JSON1) that allows you to easily work with JSON data . Also, it introduced support for indexes on expressions, which (in my understanding) should allow you to define indexes on your JSON data as well.

edelooff commented 2 years ago

Updated in #34