JSONField for SQLite on macos - cannot set DYLD_LIBRARY_PATH

[zach valenta]

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?

[Mariusz Felisiak]

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

JSON1Extension is a Wiki page, so you can add a warning or describe a workaround on your own.

Closing per TicketClosingReasons/UseSupportChannels.

[Sage Abdullah]

Hi Zach,

Thanks for the report. Unfortunately, I don't have a macOS device, so I cannot test it or confirm any workarounds. Looking at this ​commit, it looks like it's included on the official macOS installer since 3.7. If that's not an option for you, you may try ​compiling the extension and enabling it when the connection is created (using Django's ​connection_created signal). As Mariusz has pointed out, this isn't really the place to discuss this. I'll try editing the wiki page to point to those links. If you want to discuss how we can document this better, we can take it to the ​mailing list or the ​forum.