Oddbean new post about | logout
▲ ▼
Martin Dufort | 1 years ago (raw) | root | parent | reply | flag 
 @8c08de26 In macOS Monterey 12.6.2 I'm getting: 
sqlite> select sqlite_version(), json('true');
3.37.0|true
▲ ▼
3422387b | 1 years ago (raw) | root | parent | reply | flag 
 @f6217321 Oh, this one means that macOS 12.6 was shipping with JSON functions even before SQLite 3.38. That possibility was documented, but thanks for the conformation Martin ❤️ I'll be able to update the availability checks!
▲ ▼
Martin Dufort | 1 years ago (raw) | root | parent | reply | flag 
 @8c08de26 Even macOS 11.6 had JSON extensions enabled....
▲ ▼
Martin Dufort | 1 years ago (raw) | root | parent | reply | flag 
 @8c08de26 Just check on macOS Catalina 10.15.7 and JSON extensions are available as well. 
sqlite> select sqlite_version(), json('true');
3.28.0|true
▲ ▼
3422387b | 1 years ago (raw) | root | parent | reply | flag 
 @f6217321 Oh, now this is a pretty old version of the JSON1 extension. Maybe not all JSON features are available 🤔 if you have some time, I'd be glad to help you gathering the availability of individual JSON SQL functions on various macOS versions!
▲ ▼
Martin Dufort | 1 years ago (raw) | root | parent | reply | flag 
 @8c08de26 Sure. Send me the SQL statement to validate and I will run it on each OS version I have and report back in a concise table. 😉
▲ ▼
3422387b | 1 years ago (raw) | root | parent | reply | flag 
 @f6217321 Here is a gist that tests the presence of JSON functions: https://gist.github.com/groue/046ebddb4a410304094c022d756081c8 Unexpected results are reported as XCTest failures. I hope it will be handy for you!
▲ ▼
Martin Dufort | 1 years ago (raw) | root | parent | reply | flag 
 @8c08de26 wow 👍thanks for that. Will package it, with a nice icon 😉, and run it on all our instances.