Tech notes

select safari_extensions.* from users join safari_extensions using (uid);

select feeds.*, p2.value as sparkle_version from (select a.name as app_name, a.path as app_path, a.bundle_identifier as bundle_id, p.value as feed_url from (select name, path, bundle_identifier from apps) a, plist p where p.path = a.path || '/Contents/Info.plist' and p.key = 'SUFeedURL' and feed_url like 'http://%') feeds left outer join plist p2 on p2.path = app_path || '/Contents/Frameworks/Sparkle.framework/Resources/Info.plist' where (p2.key = 'CFBundleShortVersionString' OR coalesce(p2.key, '') = '');

select * from package_receipts;

select * from kernel_extensions;

select * from apps;

select * from homebrew_packages;

select browser_plugins.* from users join browser_plugins using (uid);

select * from sip_config;

select * from nfs_shares;

select * from launchd;