JSONField for SQLite on macos - cannot set DYLD_LIBRARY_PATH

Using Django
1

Trying to use JSONField with SQLite on macOS [Mojave 10.14].

I followed the instructions for how to enable SQLite’s JSON1 extension but was unable to set DYLD_LIBRARY_PATH as an environmental variable.

# attempt to export
$ export DYLD_FALLBACK_LIBRARY_PATH=path/to/dir
# no stdout
$ env | rg DYLD

Based on Stack Overflow, inability to set this env var is the result of a macOS security policy.

Should the docs for JSONField using SQLite be updated? Is there a commonly used workaround to this problem in the Django community?

2

Have you tried just trying to use a JSON field with sqlite3?

I’m running Catalina 10.15.6 with sqlite3 3.28.0, and I’m not needing to load any additional modules to create or query a JSON field. (I’ve never tried doing anything specific with this, so I have no idea whether or not my little test really indicates anything.)

Ken