Simon Willison’s Weblog

Subscribe

Wednesday, 10th January 2018

How to compile and run the SQLite JSON1 extension on OS X. Thanks, Stack Overflow! I’ve been battling this one for a while—it turns out you can download the SQLite source bundle, compile just the json1.c file using gcc and load that extension in Python’s sqlite3 module (or with Datasette’s --load-extension= option) to gain access to the full suite of SQLite JSON functions—json(), json_extract() etc.

# 9:01 pm / json, osx, sqlite, stackoverflow, datasette

2018 » January

MTWTFSS
1234567
891011121314
15161718192021
22232425262728
293031