3 ms·
I loaded these all into a SQLite database so I could explore them with Datasette Lite (Datasette running in WebAssembly). Here's the result: https://lite.data
by simonw 3y ago
I loaded these all into a SQLite database so I could explore them with Datasette Lite (Datasette running in WebAssembly).
Here's the result:
https://lite.datasette.io/?sql=https://gist.github.com/simonw/0b8a2ddaeab76fe407b08a2b2041292a#/data/ios?_facet_array=languages&_facet=ios https://lite.datasette.io/?sql=https://gist.github.com/simon...
You can use this to answer questions like which binaries are new in iOS 17 compared to iOS 16:
https://lite.datasette.io/?sql=https://gist.github.com/simonw/0b8a2ddaeab76fe407b08a2b2041292a#/data?sql=select+rowid%2C+ios%2C+path%2C+parent%2C+filename%2C+languages+from+ios+where+%22ios%22+%3D+%3Acurrent+and+path+not+in+%28select+path+from+ios+where+ios+%3D+%3Aprevious%29+order+by+rowid+limit+101¤t=iOS17&previous=iOS16 https://lite.datasette.io/?sql=https://gist.github.com/simon...
Or here's just the binaries in the /System/Library/VideoDecoders folder - it's interesting to compare iOS 1 (just H264H1 and MP4VH1) to iOS 17 (AppleProResHWDecoder, AppleProResSWDecoder, AV1SW, AVD, H264H8, JPEGH1, MP4VH8, VCH263, VCPMP4V) https://lite.datasette.io/?sql=https://gist.github.com/simonw/0b8a2ddaeab76fe407b08a2b2041292a#/data/ios?_filter_column_1=&_filter_op_1=arraynotcontains&_filter_value_1=Objective-C&_filter_column_2=&_filter_op_2=arraynotcontains&_filter_value_2=Swift&_filter_column_3=parent&_filter_op_3=exact&_filter_value_3=%2FSystem%2FLibrary%2FVideoDecoders&_filter_column=&_filter_op=exact&_filter_value=&_sort=rowid&_facet_array=languages&_facet_size=max&_facet=ios&_facet=parent https://lite.datasette.io/?sql=https://gist.github.com/simon...
Details on how I built this here: https://gist.github.com/simonw/0b8a2ddaeab76fe407b08a2b2041292a?permalink_comment_id=4732049#gistcomment-4732049 https://gist.github.com/simonw/0b8a2ddaeab76fe407b08a2b20412...
- Timac 3y agoReally nice, thanks for sharing!