I'm trying to port some SQLite and Python scripts from Linux to my new M3 Mac (macOS 15).

I'm running into problems because I can't load extensions - it's forbidden due to System Policy.

I have created a self-signed code-signing cert (SGH_sqlite_extensions), and signed the extensions (in /usr/local/lib/sqlite) using codesign. I still get no joy. When I interogate the dylibs using spctl I get the following:

% spctl -a -vv math.dylib
math.dylib:rejected
origin=SGH_sqlite_extensions

What am I doing wrong? What do I need to do to enable dylibs to load as sqlite3 extensions?